#schemadesign

Short answer: keep identity, observations, and evidence as separate records, then make semantic...

PostgreSQL 18 ships uuidv7() in core. It looks like a small convenience function, and it ends a decade-long argument about UUID primary keys. The numbers from a 200 million row table show why. The migration path is included, along with the one gotcha around the timestamp you can extract.

Short answer: use a staged retrieval architecture with explicit collections, bounded queries, and...

10-table schema with composite keys, immutable versioning, dual event pipelines, step state machines, and a full REST API delivered in 6 stacked PRs.

Part 1 of this series covered joins. Part 2 covered indexing. Part 3 covered stored procedures,...

How to Reduce MCP Token Usage: Designing Context-Efficient Tool Schemas to Cut Agent...

Originally published at norvik.tech Introduction Dive into effective data modeling,...

Design databases that don't haunt you later. Covers normalization (1NF to 3NF), indexing strategies, relationship types, and common schema design mistakes.

This article was reviewed and approved by MongoDB. When developers or administrators who had...

Introduction The document discusses sophisticated schema designs, including...

As we wrap up the Building with Patterns series, it’s a good opportunity to recap...

Welcome back to the MongoDB Schema Design Patterns series. Last time we looked ...