Preface
Imagine that you have a SQLite database which besides other data has latitude and longitude stored as separate [floating point] columns representing the position in WGS-84 (or any other SRID). And at some point you would want to geographically analyse your data in your favorite desktop GIS ( QGIS for example). It would not be possible until the database is spatially enabled, or in other words, converted to a spatial database.