DuckDB: it's not quack science https://lobste.rs/s/stbnxi #video #databases
https://www.youtube.com/watch?v=q6S0Vv4u3iM
databases
Handling graphs with SQL/PGQ in PostgreSQL https://lobste.rs/s/wkv3r2 #databases
https://www.cybertec-postgresql.com/en/handling-graphs-with-sql-pgq-in-postgresql/
Pierre Zemb from Clever Cloud on FoundationDB https://lobste.rs/s/hh1fzr #databases #person
https://theconsensus.dev/p/2026/06/18/pierre-zemb-from-clever-cloud.html
Structured Primary Keys https://lobste.rs/s/rerqzc #databases
https://modern-sql.com/blog/2026-06/structured-primary-keys
Announcing Silk: a silky smooth fiber runtime for ClickHouse https://lobste.rs/s/pd1ftk #c++ #databases
https://clickhouse.com/blog/silk
Introducing Flink's Native S3 FileSystem: Built for Performance, Designed for Production https://lobste.rs/s/hx12in #databases
https://flink.apache.org/2026/06/26/announcing-native-s3-fs/
pg_plan_advice — help the planner get the right plan https://lobste.rs/s/b0tn2i #databases #performance
https://www.postgresql.org/docs/19/pgplanadvice.html
Multigres v0.1 Alpha: an operating system for Postgres https://lobste.rs/s/l2d9cb #databases
https://supabase.com/blog/multigres-v0-1-alpha
pg_durable: PostgreSQL in-database durable execution https://lobste.rs/s/k9wvkn #databases
https://github.com/microsoft/pg_durable
Graph database-ball! Exploring the Game with the graph capabilities of LadybugDB, DuckDB and PostgreSQL https://lobste.rs/s/dxgzly #databases
https://theconsensus.dev/p/2026/05/29/ladybug-duckdb-and-postgresql.html
Waiting for SQL:202y: Stockholm (BMA) meeting report via @kngl https://lobste.rs/s/sk7fsc #databases
http://peter.eisentraut.org/blog/2026/06/30/waiting-for-sql-202y-stockholm-meeting-report
How VictoriaLogs Stores Your Logs in a Columnar Layout https://lobste.rs/s/2m10ql #databases
https://victoriametrics.com/blog/victorialogs-internals-columnar-storage-on-disk/
The perils of UUID primary keys in SQLite https://lobste.rs/s/76plqm #clojure #databases
https://andersmurphy.com/2026/06/05/the-perils-of-uuid-primary-keys-in-sqlite.html
Evaluation order and nontermination in query languages https://lobste.rs/s/0p04p0 #databases #plt
https://www.rntz.net/post/2026-06-11-datalog-nontermination.html
Looking Forward to Postgres 19: Query Hints https://lobste.rs/s/dvcyyz #databases
https://www.pgedge.com/blog/looking-forward-to-postgres-19-query-hints
An ode to self-optimizing query plans https://lobste.rs/s/e4qyi9 #databases
https://jpountz.github.io/2026/06/04/an-ode-to-self-optimizing-query-plans.html
rayforce: SIMD-accelerated columnar database for analytics — pure C, zero dependencies https://lobste.rs/s/vbhkt9 #databases #programming
https://github.com/RayforceDB/rayforce
The FastLanes Unified Transport Layout https://lobste.rs/s/1ubzuf #databases #performance
https://blog.dave.tf/post/fastlanes-utl/
kernel asynchronous reads in PostgreSQL 19 (io_uring) https://lobste.rs/s/omfy64 #databases #linux
https://dev.to/franckpachot/iouring-buffered-reads-in-postgresql-19-iouring-mcn
How ScyllaDB's Trie-Based Index Delivers Up to 3X More Throughput https://lobste.rs/s/yw6zvi #databases
https://www.scylladb.com/2026/06/30/trie-index-3x-more-throughput/
Software Is Made Between Commits via @dayanruben https://lobste.rs/s/zrntog #databases
https://zed.dev/blog/introducing-deltadb
Looking Forward to Postgres 19: It's About Time https://lobste.rs/s/ivzqxi #databases
https://www.pgedge.com/blog/looking-forward-to-postgres-19-its-about-time
Scuba: Diving into Data at Facebook https://lobste.rs/s/jjhe1c #pdf #databases #distributed #visualization
https://vldb.org/pvldb/vol6/p1057-wiener.pdf
Write-heavy sysbench tests, a large server, modern Postgres and MySQL https://lobste.rs/s/zkj0qs #databases #performance
http://smalldatum.blogspot.com/2026/06/write-heavy-sysbench-tests-large-server.html