» Tag
postgresql
46 postsPGSimCity: an explorable 3D city that visualizes PostgreSQL internals
PGSimCity visualizes PostgreSQL internals as an explorable 3D city, covering WAL, checkpoints, autovacuum, buffers and replication in real time.
Idempotency Fundamentals: Engineering API Guarantees at Scale
A practical breakdown of idempotency in distributed systems: request flow, failure boundaries, key state machines, and storage trade-offs.
pgColumnar 1.0-alpha2 Ships Read-Only Iceberg and S3 Object Storage
pgColumnar 1.0-alpha2 adds read-only Apache Iceberg support, S3-compatible object storage, a maintenance daemon, and six security fixes.
CommitBrief — AI code reviews, right in your terminal
A provider-agnostic, local-first CLI that reviews your staged changes, a historic range, or a whole GitHub pull request. Zero telemetry, no server. Free and open source.
commitbrief.comPostgreSQL and the Linux OOM Killer: A Safer Default
How strict Linux memory overcommit (vm.overcommit_memory=2) prevents OOM-killer-driven crashes in PostgreSQL, backed by a direct benchmark comparison.
Benchmarking How High Availability Affects Managed Postgres Speed
PostgresBench benchmarks the real throughput and latency cost of high availability across managed Postgres providers.
Synapsor Runner Lets AI Agents Propose Changes, Not Execute SQL
Synapsor Runner is an open-source MCP runtime giving AI agents reviewed semantic tools instead of raw SQL, keeping database write authority outside the model loop.
apitap: Rust-Based ELT Engine Moves 10M Rows in 9.9s
Open-source Rust engine apitap moves 10M database rows in 9.9 seconds via a single function call, benchmarked against dlt and ingestr.
Supabase's silent defaults: four incidents, one shared root cause
Four Supabase incidents in one week trace back to one cause: silent vendor defaults. Three rules for documenting, linting, and monitoring them.
PostgreSQL JSONB vs MongoDB BSON: The Real Architectural Tradeoffs
BSON and JSONB reveal deep architectural differences between MongoDB and PostgreSQL, shaping indexing, update cost, and read performance trade-offs.
Supabase Queues in Production: DLQs and Retries with pgmq
How to add dead-letter queues, retry limits, and poison message handling to Supabase Queues (pgmq) in production, with working SQL.