SQLite in GIS I had known about Spatialite, but I hadn't realized that QGIS was using SQLite (both indpendently and through Spatialite).
"While PostGIS is generally used on a server to provide spatial database capabilities to multiple users at the same time, QGIS also supports the use of a file format called *spatialite* that is a lightweight, portable way to store an entire spatial database in a single file. ...Using the [Database] Browser panel, we can create a new *spatialite database* and get it setup for use in QGIS" http://docs.qgis.org/2.0/en/docs/training_manual/databases/spatialite.html A YouTube video https://www.youtube.com/watch?v=3nG-oY5p9O0 "QGIS has support for approximately 2,700 known CRSs [Coordinate Reference Systems]. Definitions for each CRS are stored in a *SQLite database* that is installed with QGIS." https://docs.qgis.org/2.2/en/docs/user_manual/working_with_projections/working_with_projections.html For more information on the Spatialite family of projects: http://www.gaia-gis.it/gaia-sins/ Jim Callahan Orlando, FL On Wed, Feb 18, 2015 at 9:34 AM, Richard Hipp <drh at sqlite.org> wrote: > In a feeble effort to do "marketing", I have revised the "Appropriate > Uses For SQLite" webpage to move trendy buzzwords like "Internet of > Things" and "Edge of the Network" above the break. See: > > https://www.sqlite.org/whentouse.html > > Please be my "focus group", and provide feedback, comments, > suggestions, and/or criticism about the revised document. Send your > remarks back to this mailing list, or directly to me at the email in > the signature. > > Thank you for your help. > > -- > D. Richard Hipp > drh at sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >