On: SpatiaLite: Extends SQLite core to support Spatial...

[teruakohatu]

This. I strongly recommend not using it at this point in time.

SQlite really lends itself to having a spatial backend and would likely become a bit player in this space if it did, but it probably needs a major overall first.

[fortysixdegrees → teruakohatu]

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.

[teruakohatu → fortysixdegrees]

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

[fortysixdegrees → teruakohatu]

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.