SQLite Home Page
3 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 …
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 …
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
4 days ago · 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 …
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 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 …
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 …
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 …