@tbson87

You Have Been Reading ERD Notation Wrong

Apr 13 · 11 min read · If you have ever designed a database schema, you have probably drawn an ERD with crow's foot notation. You learned that a circle means optional, a line means mandatory, and a crow's foot means many. Y

Design Data Model for Multi-Tenant RBAC. Part 1: Identity Foundation

Apr 12 · 4 min read · Behavior Description Assume we are building a KPI management platform. Multiple companies can create accounts (tenants) and let their employees access the platform. A user can be assigned to one or s

ERD design with joy

Apr 12 · 6 min read · Most database tools treat schema design as a chore to be endured. What if the tool got out of the way - and let the thinking take center stage? There is a specific kind of friction that accumulates wh

ERD tool built for software engineers who touch a database

Apr 12 · 4 min read · If you've worked on a team with more than two services, you've felt this pain. A feature needs a new table. You write the migration, apply it, ship the code. The ERD - if one ever existed - is now wro

Your ERD is hiding your domain model

Apr 12 · 5 min read · A raw column list tells you what the database stores. It doesn't tell you what the business means. Look at a status column of type TEXT. The schema says it's a string. It says nothing about whether "p