SQLite

sqlite.org

Embedded relational database engine used in mobile, edge, and local-first applications.

Visit website
Database

Overview

SQLite is a C-language library that implements a small, fast, self-contained, high-reliability SQL database engine. It is the most widely used database engine in the world, built into all mobile phones and most computers, and bundled inside countless applications.

The database is fully featured with support for SQL syntax, pragmas, aggregate and window functions, JSON functions, and more. SQLite source code is in the public domain and free for anyone to use for any purpose.

Key features

  • Self-contained SQL database
  • Zero configuration
  • Serverless architecture
  • Full SQL support
  • JSON functions
  • Window functions
  • Public domain license
  • Cross-platform compatibility
Pros
  • Extremely lightweight and fast
  • No external dependencies or server required
  • Public domain—free for any use
  • Built into all major platforms
  • Comprehensive SQL feature support
  • Excellent documentation and community
Cons
  • Limited concurrent write support
  • Not ideal for very large datasets or high-concurrency scenarios
  • Single-file database can be a limitation for some architectures
Use this if
You need a lightweight, zero-configuration database for mobile apps, embedded systems, or local data storage without server overhead.
Skip this if
You require high-concurrency write operations, distributed database capabilities, or are building large-scale enterprise systems with complex replication needs.

Best for

Mobile applicationsEmbedded systemsDesktop applicationsLocal data storageSmall to medium projects

Alternatives

PostgreSQLMySQLMongoDBMariaDBH2 Database

Compare SQLite alternatives

More Database

Compare all
View PocketBase
PocketBaseFeatured

Open-source backend in a single file: database, auth, file storage, and admin UI.

View MariaDB
MariaDB

Community-developed SQL database fork of MySQL with compatible APIs and enterprise features.

View Microsoft Access
Microsoft Access

Desktop database and app builder for teams that need forms, reports, and relational data.

View Microsoft SQL Server
Microsoft SQL Server

Enterprise relational database for transactional workloads, analytics, and hybrid cloud.