Alternatives to SQLite
A small, self-contained SQL database engine that stores a whole database in one file. The listings below can replace it for an important use case. Each note says what changes if you switch.
The original
SQLite
A small, self-contained SQL database engine that stores a whole database in one file.
Replacements
Listings that take over the same core job as SQLite.
DuckDB
In-process analytical database that queries CSV, JSON and Parquet directly.
DuckDB is also an embedded, in-process database but aimed at analytics, querying CSV, JSON and Parquet files directly, released under the MIT license.
Similar software
Related functionality, not a direct replacement.
DB Browser for SQLite
Opens a SQLite file in a spreadsheet-like window so you can look at the data without writing SQL.
Letos
A free, open-source desktop app for creating, editing and browsing SQLite databases, formerly SQLiteStudio.
LiteCLI
A command-line SQLite client with auto-completion and syntax highlighting.
sqlite-utils
A Python command-line tool and library for creating, querying and transforming SQLite databases.
Datasette
Publishes SQLite databases as an explorable website and JSON API.
PostgreSQL
The open-source relational database with 35 years behind it, known for correctness, extensibility and a long feature list.
