|
- SQLite Home Page
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
- 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 contents and download historical versions of individual files or ZIP archives of historical check-ins You can also clone the entire repository
- Command Line Shell For SQLite
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 application that accepts user input and passes it down into the SQLite library for evaluation Understand that these are two different things When somebody says "SQLite" or "sqlite3" they might be referring to either
- How SQLite Works
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 message containing some SQL over to a separate server thread or process
- 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 of how the new locking code in version 3 increases concurrency and decreases the problem of writer starvation
- Query Language Understood by SQLite
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 own This document attempts to describe precisely what parts of the SQL language SQLite does and does not support A list of SQL keywords is also provided
- 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 sqlite3_busy_timeout (), for blocking locks on builds that support blocking locks
- 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 sqlite3_busy_timeout (), for blocking locks on builds that support blocking locks
|
|
|