ERD Generator from SQL https://lobste.rs/s/7bujlv #databases
https://sqltoerdiagram.com/
databases
The only scalable delete in Postgres is DROP TABLE https://lobste.rs/s/zieeza #databases #performance
https://planetscale.com/blog/the-only-scalable-delete
Postgres LISTEN/NOTIFY Actually Scales https://lobste.rs/s/ighdht #databases
https://www.dbos.dev/blog/postgres-listen-notify-scalability
How MVCC and Transactions Work in RocksDB https://lobste.rs/s/6kkxbx #c++ #databases
https://artem.krylysov.com/blog/2026/07/23/how-mvcc-and-transactions-work-in-rocksdb/
Version-controlled databases using Prolly trees via @vbernat https://lobste.rs/s/st8bqf #databases #vcs
https://lwn.net/Articles/1068864/
PREEMPT_NONE Is Dead; Your Postgres Probably Doesn’t Care via @kngl https://lobste.rs/s/snysfl #databases #linux #performance
https://thebuild.com/blog/preempt_none-is-dead-your-postgres-probably-doesnt-care/
Orasort - Common prefix skipping, adaptive sort https://lobste.rs/s/tlqexc #databases
http://smalldatum.blogspot.com/2026/01/common-prefix-skipping-adaptive-sort.html
On keys, essences and performance https://lobste.rs/s/kry4v6 #databases #performance
https://ebellani.github.io/blog/2026/on-keys-essences-and-performance/
Things I want in a modern relational query language https://lobste.rs/s/p5lkok #databases #plt
https://sporks.space/2026/08/19/things-i-want-in-a-modern-relational-query-language/
@clickhouse/rowbinary: when your library is also a parser compiler https://lobste.rs/s/fxtvgm #databases #javascript #performance #vibecoding
https://clickhouse.com/blog/clickhouse-rowbinary-library-parser-compiler
The Order of Data: defaults, performance, determinism & paging https://lobste.rs/s/8rjl7o #databases
https://binaryigor.com/the-order-of-data.html
How Multigres Supports LISTEN/NOTIFY Across Pooled Connections https://lobste.rs/s/rb3bii #databases
https://multigres.com
Postgres 19 Compression: from pglz to LZ4 https://lobste.rs/s/piabis #databases
https://www.crunchydata.com/blog/postgres-19-compression-from-pglz-to-lz4
Who needs a real-time database? https://lobste.rs/s/advkuj #apl #databases
https://dataintellect.com/blog/who-needs-an-rdb/
How to Achieve Pruning When Querying by Non-Partitioned Columns in PostgreSQL https://lobste.rs/s/1wd2lx #databases #performance
https://hakibenita.com/postgresql-partition-pruning
SQLite should have (Rust-style) editions https://lobste.rs/s/2nry82 #databases
https://mort.coffee/home/sqlite-editions/
Detecting Full Table Scans With SQLite https://lobste.rs/s/eilycs #databases #ruby
https://tenderlovemaking.com/2026/07/15/detecting-full-table-scans-with-sqlite/
Postgres rewritten in Rust, now passing 100% of the Postgres regression tests https://lobste.rs/s/le3iri #databases #vibecoding
https://github.com/malisper/pgrust
We're building Postgres in Rust. Using the LLVM of databases https://lobste.rs/s/1clqwe #databases
https://turso.tech/blog/a-new-modern-version-of-postgres-in-rust
Learning a few things about running SQLite https://lobste.rs/s/ryksor #databases
https://jvns.ca/blog/2026/07/17/learning-about-running-sqlite/
Aurora DSQL: Scalable, Multi-Region OLTP https://lobste.rs/s/pygp0p #pdf #databases #distributed
https://arxiv.org/abs/2607.13276
The secret life of data in Valkey https://lobste.rs/s/2vuexn #databases
https://valkey.io/blog/secret-life-of-data/
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/
Modeling State Transitions in Postgres https://lobste.rs/s/ogrb7f #databases
https://thoughtbot.com/blog/modeling-state-transitions-in-postgres