¶ :database: SQLite
Latest Version: 3.51.2 (released January 9, 2026)
Stable Version: 3.51.2 (2026-01-09)
License: Public Domain
Language: C
SQLite is an embedded relational database library used inside applications, scripts, edge services, and local tools. It’s a self-contained, serverless, zero-configuration, transactional SQL database engine.
¶ 
Best For
- Single-host applications with local persistent storage
- Lightweight tooling, automation, and prototyping workloads
- Read-heavy datasets with moderate write concurrency
- Mobile applications and embedded systems
- Local development and testing environments
- Edge computing and IoT devices
¶ 
Key Features
- Serverless architecture (no daemon required)
- ACID transactions with a single database file
- Minimal operational overhead and strong portability
- Broad support in programming languages and frameworks
- Self-contained - no external dependencies
- Cross-platform compatibility (Linux, Windows, macOS, iOS, Android)
- High reliability - extensively tested with millions of test cases
¶ 
Recent Enhancements (v3.50+)
- New JSON functions:
jsonb_each()andjsonb_tree()for better performance - Enhanced CLI: Improved formatting, new
.impostercommand, better column width controls - Performance improvements: Optimized scalar subqueries, faster window functions
- New APIs:
sqlite3_setlk_timeout(),sqlite3_db_status64(), enhanced session extension - Built-in extensions:
carrayandpercentilenow included in amalgamation
¶ 
Usage Hints for Latest Releases
- WAL Mode Performance: Use
PRAGMA journal_mode=WALfor better concurrency - Memory Management: Leverage
PRAGMA mmap_sizefor improved read performance - JSON Capabilities: Take advantage of new
jsonb_*functions for better JSON performance - Timeout Controls: Use
sqlite3_setlk_timeout()for separate lock timeout handling - CLI Enhancements: Utilize new formatting options and the
.impostercommand for debugging
¶ 
Limitations to Consider
- Not suitable for heavy concurrent write workloads
- No built-in network access (embedded only)
- Limited user management (no users/roles like server databases)
- Encryption requires third-party extensions (not built-in)
Setup
History and References