⚡ OLTP Systems

Transaction Processing, ACID Properties, Concurrency Control, Row Stores

No Cap, This Memory Slaps: Breaking Through the OLTP Memory Wall
danglingpointers.substack.com·4d·
Discuss: Substack
🔧Database Internals
Flag this post
Training: Postgres Performance and Maintenance
postgresconf.org·43m·
Discuss: Hacker News
📊Columnar Databases
Flag this post
Beyond Start and End: PostgreSQL Range Types
boringsql.com·19h·
Discuss: Hacker News
🔧Database Internals
Flag this post
SQLite concurrency and why you should care about it
jellyfin.org·2d·
Discuss: Hacker News
🔧Database Internals
Flag this post
Absurd Workflows: Durable Execution With Just Postgres
lucumr.pocoo.org·17h·
Discuss: Lobsters, Hacker News
🔧Database Internals
Flag this post
Building blobd: single-machine object store with sub-millisecond reads and 15 GB/s uploads
blog.wilsonl.in·17h·
Discuss: Hacker News
🔧Database Internals
Flag this post
Dive into Systems
diveintosystems.org·30m·
Discuss: Hacker News
🔧Database Internals
Flag this post
"You Don't Need Kafka, Just Use Postgres" Considered Harmful
morling.dev·21m·
Discuss: Hacker News
📊Columnar Databases
Flag this post
pg_stat_plans: Track per-plan call counts, execution times and EXPLAIN texts
github.com·17h·
Discuss: Hacker News
⚡Query Optimization
Flag this post
Challenging the Fastest OSS Workflow Engine
obeli.sk·3d·
Discuss: Lobsters, Hacker News
🔧Database Internals
Flag this post
Building Yantra: A Visual Workflow Automation Engine
patali.dev·14h·
Discuss: Hacker News
🔄ETL Pipelines
Flag this post
Parsing with zippers improves parsing with derivatives
dl.acm.org·1d·
Discuss: Hacker News
📐Column Encoding
Flag this post
I Built a One File Edge Probe to Tell Me When Time Is Lying
physical-ai.ghost.io·3h·
Discuss: Hacker News
📊Columnar Databases
Flag this post
Using the expand and contract pattern for schema changes
prisma.io·2d·
Discuss: Hacker News
🏠Lakehouse
Flag this post
rqlite 9.2 — the Distributed SQLite Database — Fast Restarts with GB Datasets
philipotoole.com·1h·
Discuss: Hacker News
💾SQLite
Flag this post
Moving tables across PostgreSQL instances
ananthakumaran.in·1d·
Discuss: Lobsters, Hacker News
🔧Database Internals
Flag this post
Show HN: A pragmatic SQLite schema for application-level caching
gist.github.com·2h·
Discuss: Hacker News
💾SQLite
Flag this post
Bedrock, a modular, WAN-replicated database based on SQLite
bedrockdb.com·1d·
Discuss: Hacker News
💾SQLite
Flag this post
The Case Against PGVector
alex-jacobs.com·4h·
Discuss: Hacker News
📊Columnar Databases
Flag this post
Cons Should Not Cons Its Arguments, Part II: Cheney on the MTA
web.archive.org·11h·
Discuss: Hacker News
🔧Database Internals
Flag this post