» Tag
postgres
23 postsPgrust: Rewriting Postgres in Rust Through AI
Explore the Pgrust project, which rewrites Postgres in Rust and its implications.
Realtime Updates Without a WebSocket Service
Discover how to achieve real-time updates using Postgres LISTEN/NOTIFY without a WebSocket service. Learn more here.
Zero Planned Downtime with Partitioned Tables: A 600M Row Postgres Case
Discover how a 600M-row Postgres table achieved zero planned downtime through partitioning. Learn about previous issues and solutions.
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.comEngineering around WAL Backpressure in Postgres
Engineering solutions for WAL archiving and backpressure management in Postgres.
The Startup's Postgres Survival Guide: Tips for Engineers
A guide compiling experiences with Postgres. Tips and best practices for developers.
Open-Source CLI Validates Your Postgres Backups: Seeking Architecture Feedback
Learn about the backupdrill CLI tool that validates Postgres backups. The developer seeks architectural feedback.
Fixing Postgres RLS Recursion with a JWT Custom Claims Hook
A single GRANT line triggered an infinite RLS recursion (42P17) in Postgres. How moving role checks out of user_roles into a signed JWT claim fixed it—and its trade-offs.
Postgres Rewritten in Rust: v0.2 Faster than Postgres and ClickHouse
pgrust v0.2, a Rust rewrite of Postgres, achieves remarkable speed improvements.
Semcast: A SQL Engine with Semantic Operators for Unstructured Data
Semcast enhances SQL with semantic operators to query unstructured data effectively.
Enhancing Postgres Performance with Row-Level Security
Tips for resolving performance issues in Postgres using Row-Level Security (RLS).