SQLite is a software library that implements a self-contained SQL database engine. SQLite can be used as a database underlying a website, or as a substitute for a Relational Database Management System (RDBMS).
SQLite supports atomic, consistent, isolated, and durable (ACID) transactions and has easy setup and administration. A complete SQLite database is stored in a single disk file. SQLite supports large databases (up to 1 TB in size). It supports a relatively simple application programmer’s interface (API) and has no external dependencies. SQLite comes with a stand-alone command line interface client that can be used to administer SQLite databases.
An additional extension for SQLite called SpatiaLite exists for adding support for spatial data to SQLite databases. SpatiaLite is conformant with OpenGIS specifications. See the SpatiaLite tool entry for additional information.
The source code for SQLite is in the public domain and implements most of the SQL Standard. Ongoing development and maintenance of SQLite is sponsored by the SQLite Consortium, which includes Mozilla, Bloomberg, Oracle, Nokia, and Adobe. Because of its small size and overhead SQLite is suitable for use in mobile devices such as cellular phones.
A free plugin called SQLite Manager for viewing and editing SQLite databases is available for Mozilla Firefox at https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager-webext/.
The SpatialLite Extensions for SQLite can be accessed at http://www.gaia-gis.it/spatialite/.