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.
MongoDB vs SQL: Which Database Should You Choose?
synfinity-dynamics-pvt-ltd profile

MongoDB vs SQL: Which Database Should You Choose?

#mongodb #database #sql #programming
5
Comments
7 min read
PostgreSQL: The Open-Source Database Known for Advanced Features and Reliability
rhuturaj_takle profile

PostgreSQL: The Open-Source Database Known for Advanced Features and Reliability

#postgressql #sql #programming #learning
Comments
16 min read
PostgreSQL'de Yavaş Sorguları EXPLAIN ANALYZE ile Çözmek
oktayhaktan0 profile

PostgreSQL'de Yavaş Sorguları EXPLAIN ANALYZE ile Çözmek

#postgres #database #performance #sql
Comments
3 min read
Building and Querying a Database: A Practical SQL Guide
scarbyte profile

Building and Querying a Database: A Practical SQL Guide

#sql #database #postgres #learning
Comments
5 min read
Supabase Studio and pgAdmin Won't Keep Your Schema Diagram Layout
tbson87 profile

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

#database #postgres #supabase #sql
Comments
5 min read
You Don't Need a Diagram of All 800 Tables
tbson87 profile

You Don't Need a Diagram of All 800 Tables

#database #sql #documentation #architecture
Comments
5 min read
How to Keep ERD Relationship Lines Readable: Hops, Waypoints, Colors
tbson87 profile

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

#database #sql #design #programming
Comments
6 min read
Schemity vs DbSchema: The Lightweight Alternative
tbson87 profile

Schemity vs DbSchema: The Lightweight Alternative

#database #sql #tooling #programming
Comments
8 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
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
Keeping Your ERD Updated Shouldn't Be a Second Job
tbson87 profile

Keeping Your ERD Updated Shouldn't Be a Second Job

#database #documentation #devops #sql
Comments
4 min read
Finding a Column Shouldn't Take a SQL Query
tbson87 profile

Finding a Column Shouldn't Take a SQL Query

#database #sql #postgres #productivity
Comments
5 min read
Switching ERD Tools Shouldn't Mean Starting Over
tbson87 profile

Switching ERD Tools Shouldn't Mean Starting Over

#database #sql #dbml #programming
Comments
6 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
Schemity vs ChartDB: The Offline Desktop Alternative
tbson87 profile

Schemity vs ChartDB: The Offline Desktop Alternative

#database #sql #ai #tooling
Comments
11 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.