What is the best way to organize a geo search?

Question

MySQL

Hey!
There are many points with coordinates that are stored in the MYSQL database (5.6). It is necessary to determine the nearest point to any selected one. What mechanisms exist to carry out such a search? I heard about PostGIS from Postgres, is it suitable for these purposes? Is there an alternative to MySQL?

Answer 1

Implemented by searching on the polygon data type

Answer 2

So make it simple.
(DBLat - FindLat) + (DBLon - FindLon) sort by result.
The smallest value is what you want.