Release History This page provides a high-level summary of changes to SQLite. For more detail, see the Fossil checkin logs at https://www.sqlite.org/src/timeline and https://www.sqlite.org/src/timeline?t=release. See the chronology a succinct listing of releases. 2024-01-15 (3.45.0) Added the SQLITE_RESULT_SUBTYPE property for application-defined … Read more
Activating/Deactivating Wal2 Mode “Wal2” mode is very similar to “wal” mode. To change a database to wal2 mode, use the command: PRAGMA journal_mode = wal2; It is not possible to change a database directly from “wal” mode to “wal2” mode. … Read more
SQLite Release 3.43.0 On 2023-08-24 Small. Fast. Reliable.Choose any three. SQLite Release 3.43.0 On 2023-08-24 Add support for Contentless-Delete FTS5 Indexes. This is a variety of FTS5 full-text search index that omits storing the content that is being indexed while … Read more
JSON Functions And Operators By default, SQLite supports sixteen functions and two operators for dealing with JSON values. There are also two table-valued functions that can be used to decompose a JSON string. There are 15 scalar functions and operators: … Read more
Overview Usually, SQLite allows at most one writer to proceed concurrently. The BEGIN CONCURRENT enhancement allows multiple writers to process write transactions simultanously if the database is in “wal” or “wal2” mode, although the system still serializes COMMIT commands. When … Read more
Why SQLite Does Not Use Git SQLite does not use the Git version control system. SQLite uses Fossil instead, which is a version control system that was specifically designed and written to support SQLite. People often wonder why SQLite does … Read more
{{ message }} This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository. You can’t perform that action at this time.
/* ** 2001 September 16 ** ** The author disclaims copyright to this source code. In place of ** a legal notice, here is a blessing: ** ** May you do good and not evil. ** May you find forgiveness … Read more
The Wasm Labs team worked with the SQLite team to upstream WASI support. Starting with SQLite 3.41.0 you can build libsqlite3.a for WASI by running: ./configure –with-wasi-sdk=$WASI_SDK_PATH –enable-allmake -j We are excited about the official support as these changes make … Read more
SQLite Release 3.42.0 On 2023-05-16 Small. Fast. Reliable.Choose any three. SQLite Release 3.42.0 On 2023-05-16 Add the FTS5 secure-delete command. This option causes all forensic traces to be removed from the FTS5 inverted index when content is deleted. Enhance the … Read more