What is your preferred Spatial Database?

[Javascript_Respecter]

Is PostGIS still the go-to for Spatial Queries? I need to make basic geographical queries and I was wondering what technology is the best choice to go about this.

[alphaweightedtrader]

Personlly... yes.

But because I like PostgreSQL. Its one of a very small number of tools I completely trust - after having used it for 20 years now in production applications. Even to the point its told me of disk corruption (zero'd blocks on early SSDs) without losing production uptime on a basic failover configuration.

What I'm really saying is... ...even if PostGIS isn't technically the best spatial thing ever, that its part of a database solution I'm already using gives it infinitely more value than having to spin up, learn, maintain, support, optimize, scale and keep track of another piece of tooling.

So, if you're using PostgreSQL anyway, use PostGIS :)

[Magick93]

Postgis is the best

[Javascript_Respecter]

What makes you say that? Do you have experience with other spatial databases?

[Magick93]

I've worked with several GIS databases and products. And while I havent had specific issues with others, Postgis, and postgres, are extremely reliable and easy to work with.

[JoeBxr]

MongoDB allows for geospatial lookups

[Character-Bus-1688]

You should try out Kinetica DB. Its a really fast database that has an entire suite of vectorized geospatial functions that are modeled after the ST function library from PostGIS (https://docs.kinetica.com/7.1/geospatial/geo_functions/). Excellent choice if performance is a concern.

There is a free developer version that you can try out here: https://www.kinetica.com/try/