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 …
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 …
How SQLite Works
May 31, 2025 · SQLite is a serverless software library, whereas the other systems are client-server based. With MySQL, PostgreSQL, SQL-Server, and others, the application sends a …
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.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 …
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 …
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 …
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 …
Database File Format - SQLite
Apr 30, 2025 · This document describes and defines the on-disk database file format used by all releases of SQLite since version 3.0.0 (2004-06-18).
File Locking And Concurrency In SQLite Version 3
May 31, 2025 · 1.0 File Locking And Concurrency In SQLite Version 3 SQLite Version 3.0.0 introduced a new locking and journaling mechanism designed to improve concurrency over …