O
O
Orkhan Jafarov2020-04-28 03:52:50
Database
Orkhan Jafarov, 2020-04-28 03:52:50

Which database to choose for working with geodata?

There is a project in which there will be mainly such operations:
- created an object with coordinates
- found objects within a radius of 1 km (for example)

It is expected that this will be used by a fairly large number of people.
So the question is which database or service to choose for these operations?

I consider options: PostGIS, Mongo (Geospatial Queries) or the Algolia service.
Since there is no need for difficult calculations and so on. the PostGIS variant seems cumbersome and Mongo weak (because of blocking on creation).

Answer the question

In order to leave comments, you need to log in

2 answer(s)
Y
Yo JLa, 2020-05-07
@blanger

I used MongoDb for geo data (creating amateur sports events + collecting a "team" for it, including in a circle of coordinates), it was more than 5-7 years ago, I did not observe any problems.
There was also a project with a geo base for 5-6 (something like that) million records on selections (the insert was pre-executed), it also worked quite quickly.

V
Vladimir, 2020-05-07
@dromenkojunior

I am for PostGIS. Even if difficult calculations are not needed now, they may be needed in the future. And you will have a database ready for such a development of events.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question