#databases

JSON Tiles: Fast Analytics on Semi-Structured Data (2021) https://lobste.rs/s/7mllxi #pdf #databases #performance https://db.cit.tum.de/~durner/papers/json-tiles-sigmod21.pdf

How shredding JSON is giving Logfire 1000x query speedups https://lobste.rs/s/6vjx1k #databases #performance https://pydantic.dev/articles/dynamic-shredding-2026-01-26

Consistency is not a localized property https://lobste.rs/s/rhy5zp #ai #databases #programming https://n-the-loop.com/blog/consistency-is-not-a-localized-property/

Deepthi Sigireddi from Supabase https://lobste.rs/s/pmzbuu #databases #person https://theconsensus.dev/p/2026/10/08/deepthi-sigireddi-from-supabase.html

B-Trees Are Back: Engineering Fast and Pageable Node Layouts via @fanf@mendeddrum.org https://lobste.rs/s/gvbqdy #pdf #databases https://www.cs.cit.tum.de/fileadmin/w00cfj/dis/papers/btrees-are-back.pdf

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