
SQLite Home Page
2 days ago · 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 …
SQLite Download Page
The SQLite source code is maintained in three geographically-dispersed self-synchronizing Fossil repositories that are available for anonymous read-only access. Anyone can view the …
Command Line Shell For SQLite
Dec 29, 2025 · 1.1. SQLite command-line program versus the SQLite library The SQLite library is code that implements an SQL database engine. The "sqlite3" command-line program or "CLI" …
Full-Featured SQL - SQLite
SQLite has a full-featured SQL implementation, including: Tables, indexes, triggers, and views in unlimited quantity Up to 32K columns in a table and unlimited rows Multi-column indexes …
SQLite Release 3.50.2 On 2025-06-28
SQLite Release 3.50.2 On 2025-06-28 Prior changes from version 3.50.0 (2025-05-29): Add the sqlite3_setlk_timeout () interface which sets a separate timeout, distinct from the …
SQLite Release 3.50.0 On 2025-05-29
SQLite Release 3.50.0 On 2025-05-29 Add the sqlite3_setlk_timeout () interface which sets a separate timeout, distinct from the sqlite3_busy_timeout (), for blocking locks on builds that …
Pragma statements supported by SQLite
Nov 13, 2025 · The PRAGMA statement is an SQL extension specific to SQLite and used to modify the operation of the SQLite library or to query the SQLite library for internal (non-table) …
Date And Time Functions - SQLite
Nov 13, 2025 · The first six date and time functions take an optional time-value as an argument, followed by zero or more modifiers. The strftime () function also takes a format string as its first …
JSON Functions And Operators - SQLite
Nov 27, 2025 · 1. Overview By default, SQLite supports thirty functions and two operators for dealing with JSON values. There are also four table-valued functions that can be used to …
SQLite Version 3 Overview
Jun 12, 2025 · SQLite Version 3 Overview SQLite version 3.0 introduces important changes to the library, including: A more compact format for database files. Manifest typing and BLOB …