Where Records Rest

A database keeps records so they can be found again, changed safely, and trusted by more than one reader. Relational databases arrange data in tables joined by keys; an index trades storage for faster lookup; a transaction makes a group of changes land together or not at all. In the browser, IndexedDB and local-first sync let a page keep a person's work even without a connection.

#>databases_essentials

Databases Essentials

A database in one file

SQLite is the most widely deployed database, and its documentation teaches the relational model plainly.

sqlite: docs

All or nothing

Atomicity, consistency, isolation, durability: what a transaction promises.

wiki: ACID

Storage in the browser

IndexedDB keeps structured records on the visitor's own device.

mdn: IndexedDB

Merging without a server

Local-first documents that sync by merging, not by asking permission.

automerge: concepts