✕ Clear all filters
23 articles
▶ Videos →

📰 Dev.to · Son Tran

23 articles · Updated every 3 hours · View all reads

All Articles 174,232Blog Posts 163,914Tech Tutorials 46,438Research Papers 34,131News 21,989 ⚡ AI Lessons
ON DELETE CASCADE Is Invisible in Your ERD and in Your Database Logs
Dev.to · Son Tran 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
ON DELETE CASCADE Is Invisible in Your ERD and in Your Database Logs
Referential actions decide which rows a single DELETE destroys, yet most ERD tools never store them and MySQL never logs them. Schemity draws every ON...
Comparing Staging and Production Database Schemas Side by Side
Dev.to · Son Tran 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Comparing Staging and Production Database Schemas Side by Side
Staging and production schemas drift apart, and a text diff of two SQL dumps won't show you where. Schemity opens both environments as diagrams in one...
Many-to-Many in an ERD Shouldn't Mean Hand-Building the Junction Table
Dev.to · Son Tran 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Many-to-Many in an ERD Shouldn't Mean Hand-Building the Junction Table
Most ERD tools make every many-to-many relationship a six-step manual build. Schemity auto-creates the junction table - foreign keys, composite primary...
Why ERD Tools Draw Your 1:1 Relationship as 1:N
Dev.to · Son Tran 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Why ERD Tools Draw Your 1:1 Relationship as 1:N
ERD tools misdraw 1:1 relationships as 1:N because they ignore unique constraints. Schemity derives crow's foot cardinality from the foreign key's...
The Data Dictionary Should Live in the ERD, Not in a Spreadsheet
Dev.to · Son Tran 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
The Data Dictionary Should Live in the ERD, Not in a Spreadsheet
Schemity attaches markdown descriptions to entities, legends, and context views, so what your tables mean lives inside the diagram - not in a spreadsheet...
Schemity vs DbSchema: The Lightweight Alternative
Dev.to · Son Tran 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Schemity vs DbSchema: The Lightweight Alternative
Looking for a DbSchema alternative? Schemity is a lightweight desktop ERD tool at less than half the price - plain JSON files in Git, BYOK AI included,...
You Don't Need a Diagram of All 800 Tables
Dev.to · Son Tran 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
You Don't Need a Diagram of All 800 Tables
Inherited a huge undocumented database? A full-schema poster is unreadable by design. Reverse engineer it into a desktop ERD tool, then carve it into...
Keeping Your ERD Updated Shouldn't Be a Second Job
Dev.to · Son Tran 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Keeping Your ERD Updated Shouldn't Be a Second Job
ERDs go stale the moment the schema moves on, and re-importing destroys your layout. Schemity re-syncs the diagram from the live database every time you...
Switching ERD Tools Shouldn't Mean Starting Over
Dev.to · Son Tran 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Switching ERD Tools Shouldn't Mean Starting Over
Most diagram tools only let your schema out as a picture or bare DDL, so years of work stay trapped. A desktop ERD tool with DBML and SQL import/export,...
ERD Tool Free-Tier Limits: 15-Table and 60-Object Caps Distort Models
Dev.to · Son Tran 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
ERD Tool Free-Tier Limits: 15-Table and 60-Object Caps Distort Models
Free-tier ERD tools cap you at 15 tables or 60 objects and paywall private diagrams, so the pricing page ends up shaping your data model. A one-time...
Supabase Studio and pgAdmin Won't Keep Your Schema Diagram Layout
Dev.to · Son Tran 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Supabase Studio and pgAdmin Won't Keep Your Schema Diagram Layout
Supabase Studio and pgAdmin will draw your schema, then throw your layout away. A desktop ERD tool that stores the diagram as local JSON turns a...
Finding a Column Shouldn't Take a SQL Query
Dev.to · Son Tran 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Finding a Column Shouldn't Take a SQL Query
Millions of developers query information_schema just to find which table holds a column. A desktop ERD tool with fuzzy search across entity and field...
Schemity vs ChartDB: The Offline Desktop Alternative
Dev.to · Son Tran 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Schemity vs ChartDB: The Offline Desktop Alternative
Looking for a ChartDB alternative that works offline? Schemity is a desktop ERD tool with BYOK AI, plain JSON storage in Git, and a one-time purchase - a...
Entity Templates: How to Stop Schema Naming and Field-Order Drift
Dev.to · Son Tran 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Entity Templates: How to Stop Schema Naming and Field-Order Drift
Schema drift starts at the blank entity. How entity templates and convention-aware field placement in a desktop ERD tool keep every table consistent - ERD...
Stop Hand-Translating Between SQL and Your ERD
Dev.to · Son Tran 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Stop Hand-Translating Between SQL and Your ERD
Generate an ERD from a SQL dump, import CREATE TABLE statements in one paste, and turn diagram edits into a reviewed migration SQL diff - all inside an...
Database Context Views Should Show the Relationships They Hide
Dev.to · Son Tran 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Database Context Views Should Show the Relationships They Hide
Database context views and ERD perspectives give focus by removing noise - but they also take. Here is what a sub-diagram in your ERD tool owes back when...
A Lightweight Desktop ERD Tool With Custom Waypoints and Color-Coded Relationships
Dev.to · Son Tran 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
A Lightweight Desktop ERD Tool With Custom Waypoints and Color-Coded Relationships
Most database design tools treat schema work as a chore. What if a lightweight desktop ERD tool got out of the way - with ERD custom waypoints,...
ERD Check Constraints: Show Business Rules in Your Diagram
Dev.to · Son Tran 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
ERD Check Constraints: Show Business Rules in Your Diagram
ERD check constraints support turns your schema into living documentation. See how domain-driven design database schema patterns surface value objects,...
Keyboard-First ERD Design: Build a Schema Without Touching the Mouse
Dev.to · Son Tran 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Keyboard-First ERD Design: Build a Schema Without Touching the Mouse
The best ideas happen fast. Most ERD tools make you slow down. A lightweight desktop ERD tool built for the speed of thought - keyboard-first,...