- 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
- About SQLite
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 and is thus free for use for any purpose, commercial or private
- Appropriate Uses For SQLite
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 problem Client server SQL database engines strive to implement a shared repository of enterprise data They emphasize scalability, concurrency, centralization, and control SQLite strives to provide local data storage for
- 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
- Write-Ahead Logging - SQLite
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 Log" option (hereafter referred to as "WAL") is available
- An Introduction To The SQLite C C++ Interface
7 Configuring SQLite The default configuration for SQLite works great for most applications But sometimes developers want to tweak the setup to try to squeeze out a little more performance, or take advantage of some obscure feature The sqlite3_config () interface is used to make global, process-wide configuration changes for SQLite
- CREATE TABLE - SQLite
SQLite supports UNIQUE, NOT NULL, CHECK and FOREIGN KEY constraints Optionally, a generated column constraint Whether the table is a WITHOUT ROWID table Whether the table is subject to strict type checking Every CREATE TABLE statement must specify a name for the new table Table names that begin with "sqlite_" are reserved for internal use
|