.sqlite File — SQLite Database

SQLite is a self-contained, serverless, zero-configuration, transactional SQL database engine that stores the entire database as a single cross-platform file. Created by D. Richard Hipp in 2000, SQLite is the most widely deployed database engine in the world — it's embedded in every smartphone (iOS and Android), every major web browser, most operating systems, and countless applications. SQLITE files contain a complete relational database with multiple tables, indexes, views, triggers, and full SQL support. SQLite implements most of the SQL92 standard and supports ACID transactions, full-text search (FTS5), JSON functions, window functions, common table expressions, and generated columns. The database engine is remarkably compact (under 750 KB) and requires no server process — applications link the SQLite library directly and access the database file through API calls. SQLite is ideal for embedded applications, local storage, testing, prototyping, small to medium websites, and data analysis. The file format is stable, backward-compatible, and archival-quality — the Library of Congress recommends SQLite for long-term data storage. SQLite databases can handle terabytes of data with proper configuration.