#databases

Query Plan Rewriting in PostgreSQL via @fanf@mendeddrum.org https://lobste.rs/s/qlxpzx #databases https://theconsensus.dev/p/2026/09/13/query-plan-rewriting-in-postgresql.html

Thread Pool in Percona Server and MySQL (Part 1) https://lobste.rs/s/erlbnn #databases https://www.percona.com/blog/thread-pool-in-percona-server-and-mysql-part-1/

Dostoevsky: Better Space-Time Trade-Offs for LSM-Tree Based Key-Value Stores via Adaptive Removal of Superfluous Merging https://lobste.rs/s/oevwp5 #pdf #databases https://nivdayan.github.io/dostoevsky.pdf

We ported the original Doom to SQL https://lobste.rs/s/qf2mtz #databases #games https://cedardb.com/blog/sqldoom/

Protocol-aware recovery for consensus-based storage (2018) https://lobste.rs/s/4bzboj #pdf #databases #distributed https://www.usenix.org/system/files/conference/fast18/fast18-alagappan.pdf

We used a database as a message queue. Now we use Kafka https://lobste.rs/s/0xfpgo #databases #distributed https://www.tigrisdata.com/blog/quick-fdb-kafka/

Join Ordering, Part 1: The Shape of the Search Space https://lobste.rs/s/phvgme #databases https://deferworks.org/posts/join-ordering/

Two Kinds of SQL Query Builders via @lobsters@mastodon.social https://lobste.rs/s/zknqct #databases https://mechanicalrabbit.github.io/FunSQL.jl/stable/two-kinds-of-sql-query-builders/#Two-Kinds-of-SQL-Query-Builders

Massive Parallel Imports in Neo4j Without Deadlock and Lock Contention https://lobste.rs/s/iyouff #databases https://medium.com/neo4j/massive-parallel-imports-in-neo4j-without-deadlock-and-lock-contention-2c003a48d49a

Pick OS is a Living Fossil of Computer History https://lobste.rs/s/1skdhv #databases #historical #osdev https://csixty4.medium.com/pick-is-a-living-fossil-of-computer-history-36d74408d557

Redenormalisation: Building a search index, the other way https://lobste.rs/s/gzjcbu #databases https://slatecave.net/blog/redenormalization/

Adaptive Lossless Floating-Point Encoding in Apache Parquet https://lobste.rs/s/dtozf3 #databases https://parquet.apache.org/blog/2026/09/22/alp-adaptive-lossless-floating-point-encoding-in-apache-parquet/

Extralite 3.1.0 is Here https://lobste.rs/s/qwijru #databases #ruby https://noteflakes.com/articles/2026-09-22-extralite-3-1-0

Relation algebra is not relational algebra https://lobste.rs/s/t5fquc #databases #math https://remy.wang/blog/ra-ra.html

Persistent Databases in the Browser with DuckDB-Wasm and OPFS https://lobste.rs/s/k5shc5 #databases https://duckdb.org/2026/09/18/opfs-wasm

How We Built a Data Warehouse Using ClickHouse via @fanf@mendeddrum.org https://lobste.rs/s/attm9x #databases https://letsencrypt.org/2026/09/17/clickhouse.html

Vortex: One Format for Any Shape https://lobste.rs/s/tfsojd #databases #rust https://spiraldb.com/blog/vortex-one-format-for-any-shape

Trust, but benchmark: How we let an AI agent optimize Elasticsearch https://lobste.rs/s/iul1vv #databases #performance #testing #vibecoding https://www.elastic.co/search-labs/blog/ai-code-optimization-elasticsearch-agent-harness

Simple and Efficient Row-Level Security https://lobste.rs/s/nhdqgh #databases https://acadia.engineering/blog/simple-and-efficient-row-level-security

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