SQLite is a lightweight, open source, cross-platform, and freely distributed database application. An SQLite database is stored as an ordinary file on disk, making it easy to manage and transport. Among other uses, SQLite databases can be a convenient way to store tabular scientific data in a relational, SQL-compliant structure without introducing the complexities of other relational database management systems (RDBMS). Moreover, SQLite data can be easily accessed within open-source analytical environments such as R (via the RSQLite package) and GRASS. For general information on suggested uses of SQLite, see here.

SQLite resources on the web

Resource portals

Online tutorials and demos