SQLite Documentation
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 …
About SQLite
About SQLite SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain …
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 …
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. …
JSON Functions And Operators - SQLite
Nov 13, 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 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 …
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 …
Query Language Understood by SQLite
Apr 1, 2024 · SQL As Understood By SQLite SQLite understands most of the standard SQL language. But it does omit some features while at the same time adding a few features of its …
SQL Language Expressions - SQLite
May 31, 2025 · 15. Functions SQLite supports many simple, aggregate, and window SQL functions. For presentation purposes, simple functions are further subdivided into core …
Implementation Limits For SQLite
Oct 28, 2025 · Limits In SQLite "Limits" in the context of this article means sizes or quantities that can not be exceeded. We are concerned with things like the maximum number of bytes in a …