Tuesday, August 11, 2020

Spatial lite 5 is out

 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.