How steganography solved the eternal UUID performance vs privacy dilemma in PostgreSQL
TL;DR
Built a PostgreSQL extension that creates UUIDs looking like random v4 but containing hidden timestamps. Result: 50% smaller indexes with perfect privacy protection.
Available now on PGXN: pgxn install pg_uuid_v8
The Problem Every Backend Dev Faces 🤔
You know this pain:
UUID v7 vs v4 in PostgreSQL: why random UUIDs fragment B-tree indexes, how UUID v7 fixes it, benchmarks at 5M rows, and Drizzle…
Migrating MedicoSync: UUIDv4 → UUIDv7 (Why I'm doing it, and why it's cheap to...
Si vous utilisez PostgreSQL, vous avez probablement déjà dû choisir entre une clé primaire BIGSERIAL...
1 Minute PostgreSQL Tip: Indexing JSONB for Faster Lookups 🚀 Ever struggled with slow...
The Problem with Auto-Incrementing IDs When building a B2B SaaS platform at Smart Tech Devs, using...
SQLite Internals, PostgreSQL Performance & Multi-Tenancy Patterns Today's...
