Global web icon
sqlite.org
https://sqlite.org/
SQLite Home Page
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.
Global web icon
sqlite.org
https://sqlite.org/features.html
Features Of SQLite
Features Of SQLite Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures. Zero-configuration - no setup or administration needed. Full-featured SQL implementation with advanced capabilities like partial indexes, indexes on expressions, JSON, common table expressions, and window functions.
Global web icon
sqlite.org
https://sqlite.org/cli.html
Command Line Shell For SQLite
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" is an application that accepts user input and passes it down into the SQLite library for evaluation. Understand that these are two different things. When somebody says "SQLite" or "sqlite3" they might be referring to either ...
Global web icon
sqlite.org
https://www3.sqlite.org/docs.html
Documentation - SQLite
Customizing And Porting SQLite → This document explains how to customize the build of SQLite and how to port SQLite to new platforms. Locking And Concurrency In SQLite Version 3 → A description of how the new locking code in version 3 increases concurrency and decreases the problem of writer starvation.
Global web icon
sqlite.org
https://www2.sqlite.org/matrix/download.html
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 repository contents and download historical versions of individual files or ZIP archives of historical check-ins. You can also clone the entire repository.
Global web icon
sqlite.org
https://sqlite.org/different.html
Distinctive Features Of SQLite
Distinctive Features Of SQLite This page highlights some of the characteristics of SQLite that are unusual and which make SQLite different from many other SQL database engines. Zero-Configuration SQLite does not need to be "installed" before it is used. There is no "setup" procedure. There is no server process that needs to be started, stopped, or configured. There is no need for an ...
Global web icon
sqlite.org
https://sqlite.org/pragma.html
Pragma statements supported by SQLite
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) data. The PRAGMA statement is issued using the same interface as other SQLite commands (e.g. SELECT, INSERT) but is different in the following important respects:
Global web icon
sqlite.org
https://sqlite.org/releaselog/3_50_4.html
SQLite Release 3.50.4 On 2025-07-30
SQLite Release 3.50.4 On 2025-07-30 Prior changes from version 3.50.0 (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 support blocking locks.
Global web icon
sqlite.org
https://sqlite.org/lang_corefunc.html
Built-In Scalar SQL Functions - SQLite
The sqlite_offset (X) SQL function is only available if SQLite is built using the -DSQLITE_ENABLE_OFFSET_SQL_FUNC compile-time option. sqlite_source_id () The sqlite_source_id () function returns a string that identifies the specific version of the source code that was used to build the SQLite library.
Global web icon
sqlite.org
https://sqlite.org/releaselog/3_50_0.html
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 support blocking locks.