SQLite
Small. Fast. Reliable. Choose any three.
SQLite is an embedded, serverless SQL database engine implemented as a C-language library. It runs in-process with no separate server, requires no configuration or administration, and reads and writes directly to ordinary disk files, with a complete database stored in a single cross-platform file. Transactions are ACID even after system crashes and power failures.
The engine provides a full-featured SQL implementation including partial indexes, indexes on expressions, JSON, common table expressions, and window functions. It is written in ANSI-C, ships as a single source file with no external dependencies, and includes TCL bindings plus a standalone command-line interface client; bindings for other languages are available separately. Supported platforms include Android, BSD, iOS, Linux, Mac, Solaris, VxWorks, and Windows.
SQLite is intended for use as an embedded database in applications, as an application file format, as a database for small to medium-sized websites, as a database for Internet of Things and electronic devices, and as a stand-in for an enterprise RDBMS in demonstrations and testing. The source code is in the public domain and free for any purpose; professional support is available separately.
12 alternatives to SQLite
Ranked by how well each tool replaces SQLite: shared features, audience, price and popularity.
Open source object-relational database system
Covers 5 of 15 key features and has a free plan.
Free planOpen source64 out of 100 matchFreeA high quality, visual, open source tool to create, search, and edit SQLite or SQLCipher 3
Covers 1 of 15 key features and has a free plan.
Free planOpen source62 out of 100 matchFreeBrowser-based SQL editor for SQLite, PostgreSQL, MySQL and other databases
Covers 0 of 15 key features and has a free plan.
Free plan61 out of 100 matchContact salesCreate, edit, browse SQLite databases.
Covers 0 of 15 key features and has a free plan.
Free planOpen source60 out of 100 matchFreeFree open-source database client for Windows, Linux and macOS
Covers 1 of 15 key features and has a free plan.
Free planOpen source60 out of 100 matchFreeThe best backend for AI-coded apps
Covers 0 of 15 key features and has a free plan.
Free planOpen source60 out of 100 matchFree- 59 out of 100 match—
Seamless multi-primary sync, that scales from Big Data to Mobile, with an Intuitive HTTP/2
Covers 0 of 15 key features.
Open source59 out of 100 match—Modern, easy-to-use SQL client for MySQL, Postgres, SQLite, SQL Server, Firebird, and more
Covers 0 of 15 key features and has a free plan.
Free planOpen source58 out of 100 match$9/mo- 57 out of 100 match—
A schema-less document database that creates and optimizes its own indexes, with AI and RQ
Covers 1 of 15 key features and has a free plan.
Free planOpen source56 out of 100 matchFree