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.
Keeping Your ERD Updated Shouldn't Be a Second Job

Keeping Your ERD Updated Shouldn't Be a Second Job

Comments
4 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
How to Keep ERD Relationship Lines Readable: Hops, Waypoints, Colors

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

Comments
6 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
Schemity vs DbSchema: The Lightweight Alternative

Schemity vs DbSchema: The Lightweight Alternative

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

Schemity vs ChartDB: The Offline Desktop Alternative

Comments
11 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
Database Context Views Should Show the Relationships They Hide

Database Context Views Should Show the Relationships They Hide

Comments
5 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
Stop Hand-Translating Between SQL and Your ERD

Stop Hand-Translating Between SQL and Your ERD

Comments
4 min read
Keyboard-First ERD Design: Build a Schema Without Touching the Mouse

Keyboard-First ERD Design: Build a Schema Without Touching the Mouse

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

ERD Check Constraints: Show Business Rules in Your Diagram

Comments
4 min read
A Lightweight Desktop ERD Tool With Custom Waypoints and Color-Coded Relationships

A Lightweight Desktop ERD Tool With Custom Waypoints and Color-Coded Relationships

Comments
6 min read
One Histogram, Four Engines: Fixing the Statistics Silo Problem

One Histogram, Four Engines: Fixing the Statistics Silo Problem

1
Comments
5 min read
Five schema-design habits that look harmless in a migration file — unbounded VAR

Five schema-design habits that look harmless in a migration file — unbounded VAR

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