SQLite Home Page
Dec 10, 2025 · 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.
Appropriate Uses For SQLite
May 31, 2025 · SQLite is not directly comparable to client/server SQL database engines such as MySQL, Oracle, PostgreSQL, or SQL Server since SQLite is trying to solve a different problem. …
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 …
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 …
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 Indexes …
Distinctive Features Of SQLite
May 31, 2025 · 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 …
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 …
Built-In Scalar SQL Functions - SQLite
Nov 13, 2025 · 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 …
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 decompose a …
Write-Ahead Logging - SQLite
May 31, 2025 · 1. Overview The default method by which SQLite implements atomic commit and rollback is a rollback journal. Beginning with version 3.7.0 (2010-07-21), a new "Write-Ahead Log" …