3 ms·
For anything involving location, choose Postgres because PostGIS is just so good.
by Doctor_Fegg 3y ago
For anything involving location, choose Postgres because PostGIS is just so good.
- frizlab 3y agoGood to know! I’m starting a project that will use location, and I chose Postgres, I’m happy to hear this :-)
- solarkraft 3y agoPostGIS is somewhat of a standard interface for geolocation data and one of the main interfaces of QGis, the other being based on SQLite. It's kind of cool how powerful it is, being a "real" database instead of some more contrived format. My adventures with QGis+PostGIS have also led me to discover the fun fact that even setting the TLS mode to "enforce" may enforce that you're using TLS ... but not that the certificates are correct. Silly. It also won't use the system's store when set to "full". Oh well. By the way: I find Railway to be a great home for low-use Postgres/PostGIS databases. You basically pay for operations and the free tier is totally fine for semi-casual use (about 1-2k entities) with a few people from across the pond.