PostgreSQL
Performance, safety, and production patterns for building on Postgres — from UUIDs to extensions and strictness tooling.
What you’ll learn
- Pick the right identifiers and schema patterns
- Measure performance with real benchmarks
- Ship safer SQL with strictness tooling
Recreating PlanetScale's pg_strict in Rust: A Build Log
A detailed build log of cloning PlanetScale's pg_strict in Rust. From the pitfalls of sqlparser and executor hooks to the zero-overhead solution using Postgres' native post_parse_analyze_hook.
postgres
PostgreSQL UUIDv7: Native UUIDv7 vs Extensions and Benchmarks
Compare PostgreSQL 18 native UUIDv7 with custom UUIDv7, ULID, and TypeID implementations using real benchmark data, index locality tradeoffs, and practical primary-key recommendations.
postgres