how to add longditude/langditude to DB - float?

Linda MacDonald

Hey there folks hope all is well? does anyone here know how to add geolocation info to the database - is it float? or is there a better/optimized way?
thanks in advance
Linda

thanks in advance
Linda

Pierre SULPICE

Hello Linda,

Here is a nice representation of the precision you'll have depending your choice : http://mysql.rjweb.org/doc.php/latlng
float would be 1.7m, so it all depends what you want to do with it.

Ideally you should the POINT from this : https://dev.mysql.com/doc/refman/8.0/en/spatial-types.html
But I don't think it's available on AppDrag ? I'll let them answer on that one ^^"

Good day

Joseph Benguira

Thanks Pierre, indeed Float & Doubles are good choices,
Point is to be used in Spatial mode

Indeed we don't expose Point (PT) type for now, this may be added later

In the meantime you can use "New Query" in the left menu to add your column with SQL:
https://dev.mysql.com/doc/refman/8.0/en/creating-spatial-columns.html

Linda MacDonald

@Pierre-SULPICE super duper cool thanks a mil Pierre

Linda MacDonald

@Joseph-Benguira hey there Joseph thank you so much for the info, would be excellent if you guys add the PT type will be looking forward

Linda MacDonald

Any chance that you Guys are considering integration options with mongodb?

Joseph Benguira

Hey Linda,

maybe yes, we are thinking about it (also for Redis, MongoDB, PostgreSQL)

But in the meantime you can use external mongodb providers like MongoDB Atlas:
https://www.mongodb.com/cloud/atlas
https://www.mongodb.com/pricing

They even provide a free tier for small databases

you can they use it from your cloud functions with the NPM package: https://www.npmjs.com/package/mongodb


const MongoClient = require('mongodb').MongoClient;
const uri = "mongodb+srv://root:<password>@XXXXXXXXX.mongodb.net/<dbname>?retryWrites=true&w=majority";
const client = new MongoClient(uri, { useNewUrlParser: true });
client.connect(err => {
  const collection = client.db("test").collection("devices");
  // perform actions on the collection object
  client.close();
});

Linda MacDonald

@Joseph-Benguira yup atlas is cool, was just wondering if you where considering getting it into the appdrag ecosystem

REMINDER

how to add longditude/langditude to DB - float?