SQLite In 5 Minutes Or Less
The Command Line Interface or "CLI" is a simple command-line program that accepts SQL input text and passes it through to the SQLite database engine core to be executed. The name of …
Features Of SQLite
Nov 13, 2025 · Features Of SQLite Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures. Zero-configuration - no setup or …
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 …
CREATE TABLE - SQLite
Apr 30, 2025 · SQLite supports UNIQUE, NOT NULL, CHECK and FOREIGN KEY constraints. Optionally, a generated column constraint. Whether the table is a WITHOUT ROWID table. …
Datatypes In SQLite
Nov 27, 2021 · SQLite uses a more general dynamic type system. In SQLite, the datatype of a value is associated with the value itself, not with its container. The dynamic type system of …
Temporary Files Used By SQLite
Jun 12, 2025 · SQLite uses a page cache of recently read and written database pages. This page cache is used not just for the main database file but also for transient indices and tables stored …
SQLite Release 3.46.1 On 2024-08-13
May 23, 2024 · SQLite Release 3.46.1 On 2024-08-13 Prior changes from version 3.46.0 (2024-05-23): Enhance PRAGMA optimize in multiple ways, to make it simpler to use: PRAGMA …
SQLite Release 3.50.3 On 2025-07-17
SQLite Release 3.50.3 On 2025-07-17 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 FTS5 Extension
Jul 12, 2025 · 1. Overview of FTS5 FTS5 is an SQLite virtual table module that provides full-text search functionality to database applications. In their most elementary form, full-text search …
sqlite3 WebAssembly & JavaScript Documentation Index
This site is home to the documentation for the SQLite project's WebAssembly- and JavaScript-related APIs, which enable the use of sqlite3 in modern WASM-capable browsers.