Blog

Expert guides on database design, ERD, and SQL.

UUIDPostgreSQL

bigint, UUID v4, or UUID v7? How to Choose a Primary Key (with PostgreSQL 18's uuidv7())

Compare bigint, UUID v4, and UUID v7 primary keys, see what PostgreSQL 18's built-in uuidv7() changes, and learn which key to pick for each situation.

Oct 12, 20267 min read

AIMCP

Databases Read by AI Agents: Schema Design Principles for the MCP Era

AI agents are increasingly connecting directly to databases through MCP. This post covers how to design names, comments, and constraints so agents don't misinterpret your schema, and how to split permissions safely.

Oct 12, 20268 min read

PostgreSQLPostgreSQL 19

PostgreSQL 19 Preview: Changes That Affect Schema Design and Operations (as of Beta 4)

Ahead of its official release, this post covers the PostgreSQL 19 changes that directly affect table design, migrations, and operations, based on the official release notes (Beta 4). It also looks at features reverted during beta and behavior changes to check before upgrading.

Oct 12, 20269 min read

pgvectorRAG

Designing Vector Tables for RAG with pgvector: Dimensions, Indexes, and Filtering

A guide to table structure, per-type dimension limits, HNSW indexes, and metadata filtering design when storing document embeddings with pgvector in PostgreSQL, based on pgvector 0.8.