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

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

Comments
6 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
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
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
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
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
ERD Check Constraints: Show Business Rules in Your Diagram

ERD Check Constraints: Show Business Rules in Your Diagram

Comments
4 min read
COUNT in SQL, Explained for Beginners

COUNT in SQL, Explained for Beginners

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
Add Full-Text Search to Your App Before Reaching for Elasticsearch

Add Full-Text Search to Your App Before Reaching for Elasticsearch

Comments 2
6 min read
SQL Server: Microsoft's Relational Database for Structured Application Data

SQL Server: Microsoft's Relational Database for Structured Application Data

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