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.

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 …

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 …

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 …

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 …

Oct 19, 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 …

May 31, 2025 · The core API is small, simple, and easy to learn. This article summarizes the core API. A separate document, The SQLite C/C++ Interface, provides detailed specifications for all …

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 …

Sep 23, 2025 · 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) …

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 …