· 2 days ago· Dev.to
Analysis temporarily unavailable. Please try again in a moment.
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 You know this pain: UUID v4: Random, secure, but terrible for DB indexing (fragme
#cloud-computing#postgresql#uuid#database-optimization