Features Of SQLite

A uniquely capable and versatile SQL database engine.

ACID Transactions

Atomic, Consistent, Isolated, and Durable, even after system crashes and power failures.

Zero-Configuration

No setup or administration needed. It's serverless and self-contained.

Full-Featured SQL

Supports JSON, CTEs, window functions, and more. (Omissions)

Single-File Database

An entire database in one cross-platform file. Ideal as an application file format.

Small Footprint

Less than 750KiB fully configured, or much smaller with optional features omitted.

Blazing Fast

In some cases, SQLite is faster than direct filesystem I/O.

Suggested Uses

Internet of Things

A popular choice for cellphones, set-top boxes, and other electronic gadgets. SQLite's small footprint and zero-maintenance nature make it ideal for embedded devices.

Application File Format

Instead of a custom format, XML, or JSON, use an SQLite database. You'll avoid writing a parser, gain transactional updates, and make your data more accessible. Learn more...

Website Database

SQLite is a great choice for small to medium-sized websites. It requires no configuration and stores the entire site in a single, easily managed file.

Testing & Demos

Use SQLite as a fast, setup-free stand-in for an enterprise RDBMS during development, testing, or for product demonstrations.

See more suggestions and find out when to use SQLite →