It's pronounced Diane. I do data architecture, operations, and backend development. In my spare time I maintain Massive.js, a data mapper for Node.js and PostgreSQL.
This is something you want the PostGIS extension for. Store the location as a geographic point with latitude and longitude, and in your query first filter by a bounding box big enough to contain a circle of 3km radius around your user.
This is something you want the PostGIS extension for. Store the location as a geographic point with latitude and longitude, and in your query first filter by a bounding box big enough to contain a circle of 3km radius around your user.
See gis.stackexchange.com/questions/83... for more.
Thank you, Dian Fay
I will check the PostGIS