What it does
SQLite implements a relational database as a C library rather than a separate server process. Applications can keep a database in a local file and use SQL through the library or the command-line shell. Its small deployment footprint makes it common in desktop, mobile, test, and single-machine applications where local storage is more useful than a network database.
The official five-minute guide is a sensible first stop: open a database, create a table, add rows, and query them with SQL. It is short enough to test the command-line shell before wiring the library into an application. In a program, the application links to SQLite and uses its API to execute statements and read results; there is no separate server to install or administer.
That simplicity is also the key design decision. SQLite is a strong fit for local state, embedded storage, and application data that lives with one device or process. It is not a network server that coordinates many remote application instances. If the system needs shared access across machines or centralized operational controls, choose a client/server database instead. The project states that SQLite is in the public domain; that is not the same as an OSI license, so this entry does not label it open source.
Strengths
- The library is self-contained and can be embedded in applications without a separate server.
- The official quickstart walks through opening a database and experimenting with SQL.
Watch out for
- SQLite is designed for embedded, local use rather than serving as a remote database server.
Best for
- Adding a local database to desktop, mobile, or single-machine software
- Trying SQL quickly with a lightweight command-line database
Sources
- SQLite Home Page (Oct 25, 2026)
- SQLite In 5 Minutes Or Less (Oct 25, 2026)
- SQLite Copyright (Oct 25, 2026)