SQLite Tutorial - Search localsearch

sqlite.org

https://sqlite.org/

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.org

https://sqlite.org/cli.html

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 ...

sqlite.org

https://sqlite.org/features.html

Features Of SQLite

Features Of SQLite Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures. Zero-configuration - no setup or administration needed. Full-featured SQL implementation with advanced capabilities like partial indexes, indexes on expressions, JSON, common table expressions, and window functions.

sqlite.org

https://www2.sqlite.org/matrix/download.html

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.

sqlite.org

https://sqlite.org/json1.html

JSON Functions And Operators - SQLite

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 decompose a JSON string. All of the functions listed below have the SQLITE_INNOCUOUS and SQLITE_DETERMINISTIC flags.

sqlite.org

https://sqlite.org/wal.html

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.

sqlite.org

https://sqlite.org/pragma.html

Pragma statements supported by SQLite

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) data. The PRAGMA statement is issued using the same interface as other SQLite commands (e.g. SELECT, INSERT) but is different in the following important respects:

sqlite.org

https://www3.sqlite.org/docs.html

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.

sqlite.org

https://system.data.sqlite.org/home/doc/preRelease…

System.Data.SQLite: Downloads Page

Build Product Names Beginning with System.Data.SQLite version 1.0.101.0 (3.12.2), the following templates will be used for the names of the build products: sqlite-netFx-source- version.zip sqlite-netFx-source- version.tar.gz sqlite-netFx-full-source- version.zip sqlite-netFx-full-source- version.tar.gz sqlite- framework -binary- platform - year - version.zip sqlite- framework -binary-bundle ...

sqlite.org

https://sqlite.org/amalgamation.html

The SQLite Amalgamation

The makefiles for SQLite have an "sqlite3.c" target for building the amalgamation, to contain all C code for the core SQLite library and the FTS3, FTS5, RTREE, DBSTAT, JSON1, RBU and SESSION extensions. This file contains about 238K lines of code (or 145K if you omit blank lines and comments) and is over 8.4 megabytes in size (as of 2021-12-29).