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 Performance Benchmark: Native vs Custom Implementations
Comprehensive analysis of modern time-ordered identifiers in PostgreSQL: UUIDv7, ULID, and TypeID implementations with real performance benchmarks, PostgreSQL 18 native support, and practical recommendations for choosing the right identifier for your project.
postgres