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.
You Cannot Tell Which of Your ERD Files Are Under Version Control

You Cannot Tell Which of Your ERD Files Are Under Version Control

Comments
5 min read
Optimizing an 18 TB Azure SQL Hyperscale Database — Part 3: The Real Cost of Indexes

Optimizing an 18 TB Azure SQL Hyperscale Database — Part 3: The Real Cost of Indexes

Comments
5 min read
You Forgot to Mention the 500 Million Rows

You Forgot to Mention the 500 Million Rows

Comments
4 min read
Why CTE vs Subquery Matters More on Redshift Than Anywhere Else

Why CTE vs Subquery Matters More on Redshift Than Anywhere Else

Comments
2 min read
SQL 里时间戳的 4 个真坑 + 用 tsforge-mcp 在 LLM 里直接算

SQL 里时间戳的 4 个真坑 + 用 tsforge-mcp 在 LLM 里直接算

Comments
1 min read
Navigating views in oracle database

Navigating views in oracle database

1
Comments
2 min read
Building SaarDB, Part 5: SQL Parsing

Building SaarDB, Part 5: SQL Parsing

1
Comments
7 min read
What Happens If a Bank Transfer Fails Halfway? Understanding ACID Properties in SQL

What Happens If a Bank Transfer Fails Halfway? Understanding ACID Properties in SQL

1
Comments
6 min read
SQL Patterns Hidden Inside Social Networks

SQL Patterns Hidden Inside Social Networks

1
Comments
4 min read
SSMS Database Diagrams: Your ERD Is Trapped Inside the Database It Documents

SSMS Database Diagrams: Your ERD Is Trapped Inside the Database It Documents

Comments
6 min read
Database Views in Your ERD: Read-Only Entities, Not Fake Tables

Database Views in Your ERD: Read-Only Entities, Not Fake Tables

Comments 1
5 min read
How Do SQL Database Engines Work?

How Do SQL Database Engines Work?

Comments
6 min read
Supabase Schema Diagram: Get an ERD You Can Keep, Not a Dashboard View

Supabase Schema Diagram: Get an ERD You Can Keep, Not a Dashboard View

Comments
6 min read
I Built a Chrome Extension - Sidekick

I Built a Chrome Extension - Sidekick

1
Comments
2 min read
Manticore Search 28.6.6: UUID document IDs, ordered GROUP_CONCAT(), and 16 fixes

Manticore Search 28.6.6: UUID document IDs, ordered GROUP_CONCAT(), and 16 fixes

Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.