thank you so much for interacting with the post.
I have never worked with PostgreSQL to deal with Geospatial data, even though I'm aware it is widely used around the world this purpose.
But I had the chance to work with MySQL 5.6/5.7 to manage layer and GeoJSON in a smart city project I've participated in.
I don't have any bookmarks stored from that time, but what I can tell you is that, back at that time, we chose to migrate our geospatial database to MongoDB and the results were incredible.
We had more than 50k features (geometries represented in GeoJSON) and we had to query them frequently.
The speed increased considerably when we moved to the NoSQL database.
Another thing I can mention is that, using MongoDB, at least the way we were implementing the project, made our efforts to build the queries smaller because instead of building SQL strings to perform complex queries, we took advantage of the object-formatted way of building queries using a lib for MongoDB.
By the way, it is important to say that we used PHP in that project.
I hope it helped you!
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Hi @definitelydaphne,
thank you so much for interacting with the post.
I have never worked with PostgreSQL to deal with Geospatial data, even though I'm aware it is widely used around the world this purpose.
But I had the chance to work with MySQL 5.6/5.7 to manage layer and GeoJSON in a smart city project I've participated in.
I don't have any bookmarks stored from that time, but what I can tell you is that, back at that time, we chose to migrate our geospatial database to MongoDB and the results were incredible.
We had more than 50k features (geometries represented in GeoJSON) and we had to query them frequently.
The speed increased considerably when we moved to the NoSQL database.
Another thing I can mention is that, using MongoDB, at least the way we were implementing the project, made our efforts to build the queries smaller because instead of building SQL strings to perform complex queries, we took advantage of the object-formatted way of building queries using a lib for MongoDB.
By the way, it is important to say that we used PHP in that project.
I hope it helped you!