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.
The Data Dictionary Should Live in the ERD, Not in a Spreadsheet
tbson87 profile

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

#database #documentation #sql #markdown
Comments
5 min read
ERD Tool Free-Tier Limits: 15-Table and 60-Object Caps Distort Models
tbson87 profile

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

#database #sql #productivity #tooling
Comments
6 min read
Schemity vs ChartDB: The Offline Desktop Alternative
tbson87 profile

Schemity vs ChartDB: The Offline Desktop Alternative

#database #sql #ai #tooling
Comments
11 min read
Entity Templates: How to Stop Schema Naming and Field-Order Drift
tbson87 profile

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

#database #sql #bestpractices #programming
Comments
5 min read
You Cannot Judge Coupling and Cohesion From the Same View
tbson87 profile

You Cannot Judge Coupling and Cohesion From the Same View

#database #architecture #softwareengineering #sql
Comments
5 min read
Database Context Views Should Show the Relationships They Hide
tbson87 profile

Database Context Views Should Show the Relationships They Hide

#database #architecture #documentation #sql
Comments
5 min read
Stop Hand-Translating Between SQL and Your ERD
tbson87 profile

Stop Hand-Translating Between SQL and Your ERD

#database #sql #productivity #programming
Comments
4 min read
ERD Check Constraints: Show Business Rules in Your Diagram
tbson87 profile

ERD Check Constraints: Show Business Rules in Your Diagram

#database #sql #ddd #architecture
Comments
4 min read
A Lightweight Desktop ERD Tool With Custom Waypoints and Color-Coded Relationships
tbson87 profile

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

#database #sql #productivity #design
Comments
6 min read
Keyboard-First ERD Design: Build a Schema Without Touching the Mouse
tbson87 profile

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

#database #sql #productivity #vim
Comments
6 min read
Five schema-design habits that look harmless in a migration file — unbounded VAR
philip_mcclarence_2ef9475 profile

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

#architecture #database #performance #sql
Comments
2 min read
SQL Server: Microsoft's Relational Database for Structured Application Data
rhuturaj_takle profile

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

#sqlserver #sql #programming #learning
Comments
16 min read
AWS retired its free database migration assessment tool. The reason should change how you build developer tools.
sajjasudhakararao profile

AWS retired its free database migration assessment tool. The reason should change how you build developer tools.

#database #python #sql #opensource
2
Comments 5
10 min read
SQL for Real Projects: What Tutorials Don't Teach You
praveen_kumargummala_80c profile

SQL for Real Projects: What Tutorials Don't Teach You

#sql #webdevolpment #database #dataanalytics
Comments
4 min read
Postgres vs SQLite
odalov profile

Postgres vs SQLite

#architecture #database #postgres #sql
2
Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.