¶ 
SQLite History
¶ Origins and Development
SQLite was designed by D. Richard Hipp as an embedded SQL engine with zero-administration goals and a strong focus on reliability. It was initially released in 2000 and has since become one of the most widely deployed database engines in the world.
¶ Key Milestones
- 2000: First public release of SQLite
- 2003: Version 3.0 released with major architectural improvements
- 2004: SQLite becomes the default database for Apple’s iTunes and iOS applications
- 2008: SQLite 3.6.0 introduces FTS (Full-Text Search) support
- 2010: SQLite 3.7.0 introduces Write-Ahead Logging (WAL) mode
- 2013: SQLite 3.8.0 introduces Common Table Expressions (CTEs) and ALTER TABLE enhancements
- 2016: SQLite 3.11.0 introduces JSON1 extension for JSON support
- 2019: SQLite 3.27.0 introduces UPSERT support
- 2020: SQLite 3.32.0 introduces RETURNING clause
- 2022: SQLite 3.38.0 introduces DROP COLUMN support
- 2024: SQLite 3.45.0 introduces new JSON functions and performance improvements
- 2025: SQLite 3.50.0 introduces new JSONB functions, enhanced CLI, and new APIs
- 2026: SQLite 3.51.2 (latest) released January 9, 2026, with enhanced security features and performance optimizations
¶ Architecture Evolution
SQLite’s file-based architecture and broad language integration made it the default choice for local application state in many ecosystems. Unlike traditional client-server database systems, SQLite is embedded directly into the application, eliminating the need for a separate database server process.
¶ Current Status
SQLite remains a core building block for embedded and edge workloads where a network database server is unnecessary. It’s used in smartphones, tablets, web browsers, game consoles, televisions, cars, and thousands of applications worldwide. The project continues active development with regular releases that add new features while maintaining backward compatibility.
¶ Philosophy
The SQLite project follows a philosophy of:
- Reliability: Extensive testing with millions of test cases
- Simplicity: Zero-configuration, serverless architecture
- Portability: Cross-platform compatibility
- Performance: Optimized for common use cases
- Public Domain: No licensing restrictions
¶ Recent Developments
Recent versions have focused on:
- Enhanced JSON capabilities with new
jsonb_*functions - Improved performance for complex queries
- Better CLI tools with enhanced formatting
- New APIs for application developers
- Security enhancements for processing untrusted data