databases

Repeatable Read vs Snapshot Isolation https://lobste.rs/s/ib6aav #databases
https://jaymcor.github.io/notes/isolation_rr_si.html

Extending MVCC to be serializable, in TLA+ (2024) https://lobste.rs/s/yodbwx #databases #formalmethods
https://surfingcomplexity.blog/2024/11/03/extending-mvcc-to-be-serializable-in-tla/

Jepsen: Orkes Conductor 5.3.2 https://lobste.rs/s/42zgmq #databases #distributed #testing
https://jepsen.io/analyses/orkes-conductor-5.3.2

Modeling State Transitions in Postgres https://lobste.rs/s/ogrb7f #databases
https://thoughtbot.com/blog/modeling-state-transitions-in-postgres

DuckDB v2.0: Your Database Deserves a Better Parser https://lobste.rs/s/wxj7uu #databases
https://duckdb.org/2026/08/20/duckdb-20-peg-parser.html

Every Millisecond Counts https://lobste.rs/s/uiyfpl #databases #performance
https://jordivillar.com/blog/every-millisecond-counts

SQLite WAL Mode Can Lock Short-Lived Readers https://lobste.rs/s/uusfyj #databases
https://hynek.me/til/sqlite-read-only-wal-locked/

How Tailscale helped find the SQLite WAL-Reset bug via @lobsters https://lobste.rs/s/e0lkmi #databases
https://tailscale.com/blog/sqlite-wal-reset-bug

PGSimCity: How PostgreSQL Works, in 3D https://lobste.rs/s/wewd0y #databases
https://nikolays.github.io/PGSimCity/

Write a SQL Optimizer using Egg (2023) https://lobste.rs/s/iarwcp #databases #performance #rust
https://rustmagazine.org/issue-2/write-a-sql-optimizer-using-egg

Does anyone run Postgres without PgBouncer? https://lobste.rs/s/xic1nn #databases
https://brandur.org/fragments/postgres-without-pgbouncer

ID design and primary keys https://lobste.rs/s/tiltfq #databases
https://anchorsandlinks.com/posts/primary-keys/

SQLite: How it works, by Richard Hipp (2024) https://lobste.rs/s/v2xrcm #video #databases
https://www.youtube.com/watch?v=ZSKLA81tBis

PostgreSQL MVCC: tradeoffs compared to other engines via @pmbauer https://lobste.rs/s/vjelns #databases
https://boringsql.com/posts/mvcc-bad-bad/

Asynchronous I/O in DuckDB: Work, Thread, Work https://lobste.rs/s/vlcych #c++ #databases #performance
https://duckdb.org/2026/07/31/asynchronous-io.html

Twenty Years of Bigtable https://lobste.rs/s/ooetqu #pdf #databases #distributed
https://dl.acm.org/doi/pdf/10.1145/3788853.3803095

Rethinking Database Programming https://lobste.rs/s/ykq7ym #databases #elm #plt
https://acadia.engineering/blog/rethinking-database-programming

Creating CSS with SQL https://lobste.rs/s/m5bp95 #css #databases #satire #web
https://dthung1602.github.io/sqss/

Your executable is a SQLite database https://lobste.rs/s/8ttu5n #databases #linux
https://fzakaria.com/2026/08/23/your-executable-is-a-sqlite-database

Postgres development activity via @fanf https://lobste.rs/s/3wmby2 #databases #practices
https://vondra.me/posts/postgres-development-activity/

A Preview of DuckDB v2.0 https://lobste.rs/s/wya4zt #databases
https://duckdb.org/2026/08/17/duckdb-20-highlights.html

SQLite for Everything via @ggpsv https://lobste.rs/s/gmherj #databases
https://joecode.com/2026-08-19-sqlite3/

capri: Type-safe, atomic Gleam bindings for Khepri, the modern distributed database for the BEAM https://lobste.rs/s/3tbpsd #show #databases #distributed #erlang #gleam
https://capri.hexdocs.pm/

DataCube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals (1997) https://lobste.rs/s/rji3qe #pdf #databases
https://arxiv.org/pdf/cs/0701155

The road to ACID transactions in Cassandra 6 https://lobste.rs/s/c9xng0 #databases #distributed #java
https://theconsensus.dev/p/2026/08/16/transactions-in-cassandra.html