SQLite
SQLite is a lightweight, embedded relational database engine that stores an entire database in a single file on your device.
Platform availability
Available on 0 of 10 platforms
- Unraid (not listed)
- TrueNAS (not listed)
- Umbrel (not listed)
- ZimaOS (not listed)
- Proxmox (not listed)
- Helm (not listed)
- Mac (not listed)
- Windows (not listed)
- Linux (not listed)
- Any server (not listed)
Health score?A 0-100 score computed nightly from four factors: maintained (40%: recent commits and steady activity), popular (25%: GitHub stars, log scale), easy to install (20%: platforms, install notes, setup guides, Docker image) and light to run (15%: minimum RAM, ARM support). When the source code has been checked, a fifth factor, security check (20%: automated scan for committed secrets, unsafe desktop-app settings, known-vulnerable dependencies and project hygiene; any serious finding caps it at 20), is added. Factors without data are left out and the rest are rescaled.
63/100 Good
- Maintained
- 70last commit 16 days ago
- Popular
- 8110,927 GitHub stars
- Easy to install
- 250 install platforms, install notes, Docker image
- Light to run
- No data
Based on 3 of 4 factors.
- GitHub stars
- 10,927
- Open issues
- 26
- Last commit
- 2026-11-05
- Activity
- stale
Checked 16 days ago - source: GitHub (sqlite/sqlite)
Resources & Compatibility
ARM (e.g. Raspberry Pi) is supported.
Checked 54 days ago - source: Docker Hub image tags and published docs
First-install notes
- Back up the database file first SQLite keeps its data in the database file you open, such as app.db, so copy that file to a safe backup before testing restores. If a restore points at your live database, it can replace your current data. source
- Turn on foreign keys if you need them SQLite does not enforce foreign-key relationships by default, so run the SQLite settings command PRAGMA foreign_keys = ON for each connection that should check them. Without it, invalid related rows can be saved and your data may become inconsistent. source
Fetched 42 days ago - each note links to its source
Variants
Alternatives (11)
- CockroachDB - CockroachDB is a distributed SQL database for developers and operators of transactional applications that need horizontal scaling and resil…
- DuckDB - There are many database management systems (DBMS) out there.
- FerretDB - FerretDB is an open-source MongoDB compatibility proxy for self-hosted stacks.
- Firebird - Firebird is a relational database offering many ANSI SQL-92 features that runs on Linux, Windows, and a variety of Unix platforms.
- Microsoft SQL Server - SQL Server delivers on Microsoft’s Data Platform vision by helping your organization manage your data by enabling you to store data from st…
- MongoDB - MongoDB is an open-source, document-oriented NoSQL database that stores flexible, JSON-like documents, helping developers and self-hosters…
- MySQL Community Edition - Free GPL database platform supporting SQL and NoSQL applications with InnoDB storage, replication, clustering, connectors, and cross-platfo…
- PostgreSQL - PostgreSQL (Postgres) is an open source object-relational database known for reliability and data integrity.
- libSQL - We aim to evolve it to suit many more use cases than SQLite was originally designed for, and plan to use third-party OSS code wherever it m…
- mariadb - MariaDB is a fast, open-source relational database server forked from MySQL by its original developers.
- rethinkdb - RethinkDB is an open-source, distributed NoSQL database built for realtime web applications.
Checked 54 days ago - source: AlternativeTo
Common questions
Does SQLite need a separate database service to run a self-hosted app?
SQLite is a C-language library and self-contained SQL database engine, so it can be embedded directly in the application.
What should I watch for when storing the SQLite file on a network?
Self-hosted discussions mention caution when accessing a SQLite file over a network.
Where can I get free help with a self-hosted SQLite problem?
Use the SQLite Forum, because the former mailing list is deprecated.
Can I use encrypted SQLite files without paying for the core library?
The core library is public domain, but the SQLite Encryption Extension is a proprietary licensed extension that reads and writes AES-encrypted database files.
Answers sourced from sqlite.org, sqlite.org, www.reddit.com
Community
- Simple self-hosted personal wiki : r/selfhosted - Reddit (reddit)
- SQlite or another database? : r/selfhosted - Reddit (reddit)
- SQLite Database app? : r/selfhosted - Reddit (reddit)
Collected 48 days ago - public community threads