# SQLite

SQLite is a lightweight, embedded relational database engine that stores an entire database in a single file on your device. It is open source and self-hosted, installable on Docker Hub.

Canonical page: https://ourlocalhost.com/app/5849/sqlite

## Description

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.

## Health score

63/100 (Good), based on 3 of 4 factors.
- Maintained: 70 (last commit 16 days ago)
- Popular: 81 (10,927 GitHub stars)
- Easy to install: 25 (0 install platforms, install notes, Docker image)

## Links

- Official website: https://sqlite.org/
- Documentation: https://sqlite.org/support.html
- Docker Hub: https://hub.docker.com/r/mcp/sqlite
- GitHub: https://github.com/sqlite/sqlite

## 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.

## Alternatives

- 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.

---
Source: Our Local Host (https://ourlocalhost.com/app/5849/sqlite), the self-hosted and open-source app directory.
