OSS TanbouOn this page
Overview
SQLite is an SQL database engine embedded directly in an application instead of operated as a separate server. It stores data in one file and provides transactions and a broad SQL implementation with little setup.
Features and best fit
Based on official documentation; not hands-on tested · Content checked:
Key features
Best fit
Fits local data, on-device storage, portable datasets, and test databases
Opening a file is enough to begin, which suits mobile and desktop applications, embedded devices, data interchange, and test fixtures. The command-line shell makes schema creation, a transaction, and a result query directly observable.
Before adoption
Evaluate serialized writes and the boundary with client/server databases
SQLite supports many readers, while writes to one database file are serialized. A shared network service or a workload with heavy concurrent writes may need another architecture. The GitHub repository is the official source-tree mirror. SQLite itself is in the public domain, but bundled tools or extensions can have separate terms, so consumers should inspect the files they redistribute.
Official sources
- [1]SQLite official Git mirror README at version-3.53.4(2026-10-04)
- [2]About SQLite(2026-10-04)
- [3]SQLite transaction documentation(2026-10-04)
- [4]SQLite command-line shell documentation(2026-10-04)
- [5]SQLite copyright and public-domain statement(2026-10-04)
- [6]SQLite 3.53.4 release notes(2026-10-04)
- [7]sqlite/sqlite GitHub repository metadata(2026-10-04)
Supplemental curator note
SQLite is a strong default when an application needs reliable SQL storage without operating a separate server. Adopt it with a clear understanding of serialized writes to one file and of GitHub serving as the official source-tree mirror.
Try it in 3 steps
- 1
Check the installed CLI version in a temporary directory
Requires the sqlite3 CLI. Enter an isolated temporary directory and print the version actually used; it may differ from the cited 3.53.4 source release.
sqlite_demo_dir=$(mktemp -d "${TMPDIR:-/tmp}/sqlite-demo.XXXXXX") && cd "$sqlite_demo_dir" && sqlite3 --version - 2
Write a transaction and result query
In the same directory, create an LF-terminated SQL file that inserts two rows, updates one, commits, and queries the result.
printf '%s ' 'BEGIN IMMEDIATE;' 'CREATE TABLE tasks(id INTEGER PRIMARY KEY, title TEXT NOT NULL, done INTEGER NOT NULL DEFAULT 0);' "INSERT INTO tasks(title) VALUES ('review schema'), ('run transaction');" 'UPDATE tasks SET done = 1 WHERE id = 1;' 'COMMIT;' '.headers on' '.mode column' 'SELECT id, title, done FROM tasks ORDER BY id;' > demo.sql - 3
Create the database and inspect the result
Execute the SQL and confirm that review schema has done=1 while run transaction has done=0.
sqlite3 demo.db < demo.sql
Growth
Growth trends · Last 30 days
10,596 Stars
Trend data is still being collected.
Development activity
Last 90 days · weekly
- Commits (last 30 days)
- 110
- Open PRs
- 24
Development activity is still being collected.
Built with
Categories and tags
Categories
GitHub data
GitHub dataView detailed GitHub data
- Stars
- 10,596
- Forks
- 1,680
- Watchers
- 150
- Open issues
- 0
- Contributors
- 0
- Owner type
- User
- Primary language
- C
- License
- Not determined
- Repository last updated
- Oct 4, 2026
Related information
Write a related articleShare a guide or use case for this OSS in Markdown. Articles are published after administrator approval.
Explore next
- PostgreSQL22,271 Stars
3 shared tag(s) · 1 shared category(s) · Same language
combine SQL transactions, constraints, indexes, and extensible types/functions in an object-relational database engine
C - DuckDB41,895 Stars
3 shared tag(s) · 1 shared category(s)
Run analytical SQL directly over CSV, Parquet, and DataFrames inside the application process without a database server
C++ - MySQL Server12,440 Stars
3 shared tag(s) · 1 shared category(s)
Run relational workloads with InnoDB transactions, SQL, replication, and high-availability tooling
C++ - MariaDB Server8,311 Stars
3 shared tag(s) · 1 shared category(s)
Provide MySQL-compatible protocols, pluggable storage engines, replication, and native vector search in one SQL database
C++ - mysql22,275 Stars
3 shared tag(s) · 1 shared category(s)
connect Ruby to MySQL or MariaDB and handle SQL queries, prepared statements, and streaming results
Ruby - DBeaver51,953 Stars
2 shared tag(s) · 1 shared category(s)
operate many database systems from one desktop SQL workspace
Java
Report incorrect information
Tell us if any listing information is incorrect or outdated.