What is SNKV? SNKV is a lightweight, ACID-compliant embedded key-value store built directly on SQLite’s B-Tree storage engine — without SQL. The idea: bypass the SQL layer entirely and talk directly to SQLite’s storage engine. No SQL parser. No query … Read more
SQLite’s Use Of Tcl D. Richard Hipp24th Annual Tcl/Tk ConferenceHouston, TX2017-10-19 1.0 Introduction SQLite is a TCL extension that has escaped into the wild. The design of SQLite was inspired by the design of TCL, both in the way it … Read more
Database File Format Table Of Contents This document describes and defines the on-disk database file format used by all releases of SQLite since version 3.0.0 (2004-06-18). The complete state of an SQLite database is usually contained in a single file … Read more
One of the most important properties of a database is durability. Durability means that after a transaction commits, you can be confident that, absent catastrophic hardware failure, the changes made by the commit won’t be lost. This should remain true … Read more
SQLite’s Use Of Tcl D. Richard Hipp24th Annual Tcl/Tk ConferenceHouston, TX2017-10-19 1.0 Introduction SQLite is a TCL extension that has escaped into the wild. The design of SQLite was inspired by the design of TCL, both in the way it … Read more
If you look at SQLite’s EXPLAIN output, you sometimes may notice something unusual if you’re coming from other SQL databases like PostgreSQL or MySQL. Here’s an example: sqlite> create table foo (a); sqlite> create table bar (b, a); sqlite> explain … Read more