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.
From Joins to Graph Edges: SQL/PGQ in PG ̶1̶9̶ 20 (was 19 beta but reverted)

From Joins to Graph Edges: SQL/PGQ in PG ̶1̶9̶ 20 (was 19 beta but reverted)

1
Comments 1
6 min read
SQL-First Paradigm: Rethinking Persistence Layer Design from First Principles

SQL-First Paradigm: Rethinking Persistence Layer Design from First Principles

1
Comments 1
9 min read
Where Should the Foreign Key Go?

Where Should the Foreign Key Go?

2
Comments
6 min read
DuckDB 1.4.5 LTS, pgEdge ColdFront Beta, and SQLite's FCNTL_PDB Internals

DuckDB 1.4.5 LTS, pgEdge ColdFront Beta, and SQLite's FCNTL_PDB Internals

Comments
3 min read
I built a free tool that turns SQL schemas into ER diagrams (no signup needed).

I built a free tool that turns SQL schemas into ER diagrams (no signup needed).

3
Comments
1 min read
Designing SaaS Database Architecture: Users, Organizations, Subscriptions, and Billing

Designing SaaS Database Architecture: Users, Organizations, Subscriptions, and Billing

1
Comments
5 min read
Why Knowing SQL Isn't Enough to Understand Databases

Why Knowing SQL Isn't Enough to Understand Databases

1
Comments 1
3 min read
Catch the dangerous Postgres migration at the CI step

Catch the dangerous Postgres migration at the CI step

2
Comments 2
3 min read
I Built a SQL Diagnostics Tool for Developers Who Don't Have a DBA

I Built a SQL Diagnostics Tool for Developers Who Don't Have a DBA

1
Comments
5 min read
Embedding Live Charts in Your App Without a Full BI Tool

Embedding Live Charts in Your App Without a Full BI Tool

Comments
5 min read
Your Postgres Is Quietly Rotting — Here Are the Queries That Show It

Your Postgres Is Quietly Rotting — Here Are the Queries That Show It

2
Comments 2
9 min read
From 9,663 ms to 18 ms: sorting a 389k-product catalog in Postgres (no magic, three steps)

From 9,663 ms to 18 ms: sorting a 389k-product catalog in Postgres (no magic, three steps)

Comments 2
2 min read
Building SaarDB, Part 3: Compaction

Building SaarDB, Part 3: Compaction

9
Comments
10 min read
SQL Queries Every SaaS Founder Should Know

SQL Queries Every SaaS Founder Should Know

Comments
7 min read
PostgreSQL 22034 Error: Causes and Solutions Complete Guide

PostgreSQL 22034 Error: Causes and Solutions Complete Guide

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