Directly from the Spatialite site (Wikipedia):
- SpatiaLite is an open source library intended to extend the SQLite core to support fully fledged Spatial SQL capabilities.
- SQLite is intrinsically simple and lightweight:
- a single lightweight library implementing the full SQL engine
- standard SQL implementation: almost complete SQL-92
- no complex client/server architecture
- a whole database simply corresponds to a single monolithic file (no size limits)
- any DB-file can be safely exchanged across different platforms, because the internal architecture is universally portable
- no installation, no configuration
- Source code can be found here.
- Last but not least, Spatial lite is an open source effort by Alessandro Furieri
For who are treating geospatial data, putting all of it in a small sqlite database is a valuable option. We did not investigate this option enough and, I promise, in future, we'll do better. However, the Adige database, is implemented as an sqlite/spatialite file. More information in the sqlite website.
