SQLite

SQLite is a lightweight, embedded relational database engine that stores an entire database in a single file on your device.

  • Databases
SQLite is a lightweight, embedded relational database engine that stores an entire database in a single file on your device. It runs with no server process or separate configuration, making it ideal for applications that need fast, reliable local storage for settings, notes, or history.

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

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

Collected 48 days ago - public community threads