CODEWITHSUNDEEP
mysqlmongodbgeolocation
Shashank Chavan
Shashank Chavan

Reputation: 131

Does MySQL have inbuilt feature for Geo location based queries?

Does MySQL have inbuilt feature for Geo location based queries? I have found this one Spatial extension http://dev.mysql.com/doc/refman/5.1/en/spatial-extensions.html How's it as compare to MongoDB GeoSpatial feature?? What's the difference in between them??

Upvotes: 0

Views: 469

Answers (1)

O. Jones
O. Jones

Reputation: 108776

MySQL's geospatial extension implements planar, not spherical or projection, geometry in a native fashion. It is possible to use a spatial index to accelerate latitude / longitude lookup, but the spherical geometry computations need to be done in MySQL queries or stored functions provided by you, the user of the geospatial extension. Here's a writeup on that.

http://www.plumislandmedia.net/mysql/using-mysqls-geospatial-extension-location-finder/

Mongo has multiple projections supported in the geospatial projection.

Upvotes: 2

Related Questions