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.
Atomic Commit In SQLite
An important feature of transactional databases like SQLite is "atomic commit". Atomic commit means that either all database changes within a single transaction occur or none of them occur. With atomic commit, it is as if many different writes to different sections of the database file occur instantaneously and simultaneously. Real hardware serializes writes to mass storage, and writing a single sector takes a finite amount of time. So it is impossible to truly write many different sectors of a database file simultaneously and/or instantaneously. But the atomic commit logic within SQLite makes it appear as if the changes for a transaction are all written instantaneously and simultaneously.
SQLite: How it works, by Richard Hipp
Honker
Durable queues, streams, pub/sub, and time-trigger scheduling on SQLite. One file, zero servers.
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 is built into all mobile phones and most computers and comes bundled inside countless other applications that people use every day. More Information...
Deep dive into Turso, the "SQLite rewrite in Rust"
I love Rust and I love SQLite, so you can guess. Iwas pretty excited when I lerned that "SQLite was rewritten in Rust" What is SQLite, actually? 2 things: a
Command Line Shell For SQLite
The SQLite project provides a simple command-line program named sqlite3 (or sqlite3.exe on Windows) that allows the user to manually enter and execute SQL statements against an SQLite database or against a ZIP archive. This document provides a brief introduction on how to use the sqlite3 program.
What would SQLite look like if written in Rust? — Part 1
Writing a SQLite clone from scratch in Rust
Litestream
Litestream is an open-source, real-time streaming replication tool that lets you safely run SQLite applications on a single node.
PowerSync: Backend DB - SQLite sync engine | For Postgres, MongoDB, MySQL, SQL Server
Automatically sync your backend database with in-app SQLite and avoid the complexities of using APIs to move app state over the network.
SQLite for Everything | JoeCode
Code with distinct characteristics traceable to its author.
SQLSync
SQLSync is a collaborative offline-first wrapper around SQLite. It is designed to synchronize web application state between users, devices, and the edge.
GitHub - zombiezen/go-sqlite: Low-level Go interface to SQLite 3
Low-level Go interface to SQLite 3. Contribute to zombiezen/go-sqlite development by creating an account on GitHub.