SQLite Home Page
6 days ago · 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 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 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
Nov 13, 2025 · 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 …
Command Line Shell For SQLite
6 days ago · 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" …
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 …
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 …
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 …
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 …
Pragma statements supported by SQLite
Nov 13, 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) …