sqlite.orgSQLite Home Page

Small. Fast. Reliable. Choose any three. Home Menu About Documentation Download License Support Purchase Search About Documentation Download Support Purchase Search Documentation Search Changelog Common Links Features When to use SQLite Getting Started Prior Releases SQL Syntax Pragmas SQL functions Date & time functions Aggregate functions Window functions Math functions JSON functions C/C++ Interface Spec Introduction List of C-language APIs The TCL Interface Spec Quirks and Gotchas Frequently Asked Questions Commit History Bugs News What Is SQLite? SQLite is a C-language library that implements a small , fast , self-contained , high-reliability , full-featured , SQL database engine. SQLite is the most used database engine in the world. SQLite is built into all mobile phones and most computers and comes bundled inside countless other applications that people use every day. More Information... The SQLite file format is stable, cross-platform, and backwards compatible and the developers pledge to keep it that way through the year 2050 . SQLite database files are commonly used as containers to transfer rich content between systems [1] [2] [3] and as a long-term archival format for data [4] . There are over 1 trillion (1e12) SQLite databases in active use [5] . SQLite source code is in the public-domain and is free to everyone to use for any purpose. Latest Release Version 3.35.3 (2021-03-26). Download Prior Releases Common Links Features When to use SQLite Getting Started Prior Releases SQL Syntax Pragmas SQL functions Date & time functions Aggregate functions Window functions Math functions JSON functions C/C++ Interface Spec Introduction List of C-language APIs The TCL Interface Spec Quirks and Gotchas Frequently Asked Questions Commit History Bugs News Ongoing development and support of SQLite is made possible in part by SQLite Consortium members, including:...