databases

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

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/

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

Solving the 1+N query problem https://lobste.rs/s/k5feqe #databases
https://acadia.engineering/blog/solving-the-1-plus-N-query-problem

Another look at SQLite's WAL-Reset bug https://lobste.rs/s/b15udy #databases
https://theconsensus.dev/p/2026/08/23/another-look-at-sqlite-wal-reset.html

DuckLabs to Join AWS, Projects to Remain Open Source https://lobste.rs/s/p86r57 #databases
https://ducklabs.com/news/2026/08/26/ducklabs-to-join-aws

BtrLog: Low-Latency Logging for Cloud Database Systems https://lobste.rs/s/mudgnw #databases #performance
https://arxiv.org/abs/2606.27051

A Better SQL in 11 Lines of Code https://lobste.rs/s/xnljk9 #databases
https://prela-lang.org/tutorial/

Read your own writes, off the primary via @caius https://lobste.rs/s/vq68cd #databases
https://boringsql.com/posts/read-your-own-writes/