🐘 PostgreSQL

Performance Tuning, Query Optimization, Extensions, Replication

Build durable workflows with Postgres
dbos.dev·23h·
Discuss: Hacker News
🏛️software architecture
Indexing Blockchain Events with Rust and Alloy
blog.bilinearlabs.io·4d·
Discuss: Hacker News
💿SQLite
Postgres Replication Slots: Confirmed Flush LSN vs. Restart LSN
morling.dev·4d·
Discuss: Lobsters, Hacker News, r/programming
💾SQL
Testing PowerSync with Jepsen for Causal Consistency and More
github.com·2d·
Discuss: Hacker News
💿SQLite
N+1 query problem : what it is, why it hurts performance, and how to fix it
namitjain.com·6d·
Discuss: Hacker News, r/programming
💾SQL
Spanner columnar engine: Powering next-generation analytics on operational data
cloud.google.com·3d·
Discuss: Hacker News
💿SQLite
Spatio-temporal indexing the Bluesky firehose
joelgustafson.com·1d·
Discuss: Hacker News
💿SQLite
Pigsty 3.6, the meta-distribution for PostgreSQL
postgresql.org·5d·
Discuss: Hacker News
💾SQL
Quacking Performance: DuckDB
mackle.io·1d·
Discuss: Hacker News
💿SQLite
Ask HN: How do/did you use PostgreSQL's LISTEN/NOTIFY in production?
news.ycombinator.com·2d·
Discuss: Hacker News
🔄distributed
Distributed Systems 101
mrinalxdev.github.io·1d·
Discuss: Hacker News
🔄distributed
TimescaleDB 2.21 – 42× Faster DELETEs
tigerdata.com·2d·
Discuss: Hacker News
💿SQLite
Consistency over Availability: How rqlite Handles the CAP theorem
philipotoole.com·3d·
Discuss: Hacker News
🏛️software architecture
Exploring Traces: Agent trajectory walkthroughs from interesting examples
theori.io·7h·
Discuss: Hacker News
🏛️software architecture
Building Paperboy: A Personal Reading Recommendation Engine
joshbeckman.org·4d·
Discuss: Hacker News
🏛️software architecture
Virtual 6NF
minimalmodeling.substack.com·1d·
Discuss: Substack
💿SQLite
Why You Shouldn’t Treat Your Database as an Integration Platform
medium.com·6d·
Discuss: Hacker News, Hacker News, r/programming
💿SQLite
A Deeper Dive into Apache Iceberg V3
opensource.googleblog.com·22h·
Discuss: Hacker News
💿SQLite
Prisma ORM Without Rust: Latest Performance Benchmarks
prisma.io·5d·
Discuss: Hacker News
🐹golang
HorizonDB, a geocoding engine in Rust that replaces Elasticsearch
radar.com·1d·
Discuss: Hacker News
🐹golang