What is SpatiaLite / SQLite?
SpatiaLite extends SQLite with spatial types, indexes, and functions so a single portable database file can support GIS-style querying and editing workflows.
SpatiaLite is attractive because it combines the portability of SQLite with many of the practical benefits people expect from a spatial database.
It is especially useful when a project wants SQL-based filtering, joins, and structured storage without depending on a heavier server database or a loose collection of flat files.