SQLite

SQLite is an open-source embedded relational database engine created by D Richard Hipp in 2000, distinguished as the most widely deployed database in the world with over one trillion active instances running on billions of smartphones, computers, web browsers, and embedded devices, providing a self-contained serverless zero-configuration transactional SQL database that operates directly on local files without requiring a separate server process, making it the default local storage engine for Android, iOS, Chrome, Firefox, Safari, and countless desktop applications. The serverless architecture eliminates the need for a separate database server process, network configuration, or administration overhead, as the entire database engine is compiled into a single C library that is linked directly into the application, reading and writing directly to ordinary disk files, enabling applications to store structured data with zero setup and zero administration. The SQL feature set is comprehensive, supporting transactions with full ACID compliance, prepared statements, common table expressions including recursive variants, window functions, full-text search through the FTS5 module, JSON functions and operators, generated columns, UPSERT, returning clause, and common SQL standard features, making it suitable for complex queries despite the embedded nature. The file format is cross-platform and stable, with databases portable between thirty-two bit and sixty-four bit systems and between big-endian and little-endian architectures, and backward compatible guarantees ensuring databases created decades ago still work with current versions. The concurrent access uses file locking with WAL mode enabling simultaneous readers and a single writer without blocking. The PRAGMA commands control engine behavior. The database size limit is two hundred eighty-one terabytes. Designed for application developers, mobile developers, embedded systems engineers, and anyone needing local data storage.