3 ms·
TBH, that should be easily doable for any database. I've built something like this with SQLite and on another occasion with Elasticsearch (where it's obviously
by hobofan 7y ago
TBH, that should be easily doable for any database. I've built something like this with SQLite and on another occasion with Elasticsearch (where it's obviously much easier). If you leverage Geohash, and precalculate the geohash for every location, you don't even need any builtin geo-capabilities from the database.
- jessermeyer 7y agoSQLite now supports R*Trees for spatial queries. https://sqlite.org/rtree.html https://sqlite.org/rtree.html