DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Switching ERD Tools Shouldn't Mean Starting Over

Switching ERD Tools Shouldn't Mean Starting Over

Comments
6 min read
The Data Dictionary Should Live in the ERD, Not in a Spreadsheet

The Data Dictionary Should Live in the ERD, Not in a Spreadsheet

Comments
5 min read
Supabase Studio and pgAdmin Won't Keep Your Schema Diagram Layout

Supabase Studio and pgAdmin Won't Keep Your Schema Diagram Layout

Comments
5 min read
Finding a Column Shouldn't Take a SQL Query

Finding a Column Shouldn't Take a SQL Query

Comments
5 min read
You Don't Need a Diagram of All 800 Tables

You Don't Need a Diagram of All 800 Tables

Comments
5 min read
ERD Tool Free-Tier Limits: 15-Table and 60-Object Caps Distort Models

ERD Tool Free-Tier Limits: 15-Table and 60-Object Caps Distort Models

Comments
6 min read
How to Keep ERD Relationship Lines Readable: Hops, Waypoints, Colors

How to Keep ERD Relationship Lines Readable: Hops, Waypoints, Colors

Comments
6 min read
Schemity vs DbSchema: The Lightweight Alternative

Schemity vs DbSchema: The Lightweight Alternative

Comments
8 min read
Keeping Your ERD Updated Shouldn't Be a Second Job

Keeping Your ERD Updated Shouldn't Be a Second Job

Comments
4 min read
Entity Templates: How to Stop Schema Naming and Field-Order Drift

Entity Templates: How to Stop Schema Naming and Field-Order Drift

Comments
5 min read
Schemity vs ChartDB: The Offline Desktop Alternative

Schemity vs ChartDB: The Offline Desktop Alternative

Comments
11 min read
Stop Hand-Translating Between SQL and Your ERD

Stop Hand-Translating Between SQL and Your ERD

Comments
4 min read
You Cannot Judge Coupling and Cohesion From the Same View

You Cannot Judge Coupling and Cohesion From the Same View

Comments
5 min read
Database Context Views Should Show the Relationships They Hide

Database Context Views Should Show the Relationships They Hide

Comments
5 min read
ERD Check Constraints: Show Business Rules in Your Diagram

ERD Check Constraints: Show Business Rules in Your Diagram

Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.