News for hackers. Stuff that matters.

A comment on SpatiaLite: Extends SQLite core to support Spatial SQL capabilities. Parent comment

Re:SpatiaLite: Extends SQLite core to support Spatial SQL ca... by fortysixdegrees on Friday July 22, 2022 @11:30PM (#32200056)
Strongly recommending not using it in a blanket way is not helpful.

I have used it extensively in an embedded product for many years, and it has just worked.

Sure it doesn't have all the postgis goodies, but it has enough that it's not usually hard to find a good way to do the spatial queries you need.

I'm quite surprised by this thread so far, given how robust it's been for me for many years using it in many different ways.

[ Parent | on HN ]
Re:SpatiaLite: Extends SQLite core to support Spatial SQL ca... by teruakohatu on Friday July 22, 2022 @11:37PM (#32200084)
To be specific, they changed the KNN backend, but the docs refer to the new unreleased backend. The old one is deprecated but unreleased, which is a strange confusing situation.

https://www.gaia-gis.it/fossil/libspatialite/wiki?name=KNN2

[ Parent | on HN ]
Re:SpatiaLite: Extends SQLite core to support Spatial SQL ca... by fortysixdegrees on Friday July 22, 2022 @11:46PM (#32200141)
For the average HN reader spatialite is a tool which should be considered. If the KNN issues are a breaking point for someone, they are probably already in postgis territory.
[ Parent | on HN ]