Can we use innodb to store latitutude and logitude and retrieve 20 closest points well?

Question

I've heard that innodb Why innodb doesn't store geospatial data? store geospatial data but cannot index it.

Not really sure what it means. Is it a good idea to ask 20 closest businesses if point is stored in innodb?

Answer 1

An efficient, but complex, solution: http://mysql.rjweb.org/doc.php/latlng (The design actually prefers InnoDB.)