4 ms·
We picked MongoDB a while ago because of its built in geospatial indexing support. Would be happy to add support of other databases. Any strong candidates on to
by dszeto 13y ago
We picked MongoDB a while ago because of its built in geospatial indexing support. Would be happy to add support of other databases. Any strong candidates on top of your head?
- yaph 13y agoPostgreSQL / PostGIS
- todazar 13y agoRethinkDB!
- saosebastiao 13y agoBoth Postgres and SQLite have extensive geospatial support (PostGIS and SpatiaLite respectively), including indexing and boatloads of useful geospatial functions. And in my experience, both of them are far more advanced than Mongo's geospatial support.
- bduerst 13y agoI know it's a pain to get data into it, but how about Big Query?
- tstonez 13y agoIdeally open-source. Surprised MongoDB 2.2+ is such an issue but thanks for the feedback and suggestions. We'll look into PostgreSQL, Riak and RethinkDB.
- bduerst 13y agoIt is based on an open-sourced db called Dremel: https://code.google.com/p/dremel/ https://code.google.com/p/dremel/
- yipjustin 13y agoBut dremel doesn't support incremental updates. Dremel is designed for read-only data. All its columns are indexed. The whole table needs to be re-built after update.
- duaneb 13y agoI haven't worked with geospatial databases as much (so verify this with someone who has), but Postgres is a good bet for an alternative to mongo in this scenario.