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.
Write-Ahead Logging
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.
Towards Inserting One Billion Rows in SQLite Under A Minute - blag
This is a chronicle of my experiment where I set out to insert 1B rows in SQLite
SQLite: How it works, by Richard Hipp
Rust Atomics and Locks by Mara Bos
Low-level Concurrency in Practice. This practical book helps Rust programmers of all levels gain a clear understanding of low-level concurrency. You'll learn everything about atomics and …
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...
What would SQLite look like if written in Rust? — Part 1
Writing a SQLite clone from scratch in Rust
The Case for Co-Locating Workflow State with Your Data | DBOS
Keeping workflow state and application data in the same Postgres database lets one transaction update both, simplifying idempotency and atomicity.
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
Litestream
Litestream is an open-source, real-time streaming replication tool that lets you safely run SQLite applications on a single node.
Living without atomic clocks: Where CockroachDB and Spanner diverge
If someone knows even a little about Spanner, the first question they have is: "How does CockroachDB provide external consistency without atomic clocks?"
Atomic Design | Atomic Design by Brad Frost
Learn how to create and maintain digital design systems, allowing your team to roll out higher quality, more consistent UIs faster than ever before.
Making SQLite faster in Go
Make sqlite faster with a connection pool and prepared statements.
It's the memory latency, stupid · Pivot blog
When your database CPU is at 100%, what is it actually doing? Memory stalls, CPU caches, and how radix partitioning makes GROUP BY faster.