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.
Normalization vs. Denormalization: Choosing the Right Database Design for Performance

Normalization vs. Denormalization: Choosing the Right Database Design for Performance

Comments
3 min read
Bitmap Heap Scan in Postgres: When It’s Smart and When It’s a Symptom

Bitmap Heap Scan in Postgres: When It’s Smart and When It’s a Symptom

Comments 1
7 min read
ORA-00060 Deadlock: Find It, Fix It, Prevent It

ORA-00060 Deadlock: Find It, Fix It, Prevent It

Comments
10 min read
SQL: Data Constraints

SQL: Data Constraints

1
Comments 2
4 min read
How to Use AI to Write SQL Queries from Plain English

How to Use AI to Write SQL Queries from Plain English

Comments
3 min read
Database Agnostic Queries: Easing the Pain of Engine Migration

Database Agnostic Queries: Easing the Pain of Engine Migration

Comments
3 min read
Your LLM fused the two columns you asked for — and the eval marked it wrong

Your LLM fused the two columns you asked for — and the eval marked it wrong

Comments
3 min read
Dory Has Received the SourceForge Rising Star Award

Dory Has Received the SourceForge Rising Star Award

Comments
1 min read
Day 2: Understanding MySQL Client-Server Communication, Protocols, and Pages

Day 2: Understanding MySQL Client-Server Communication, Protocols, and Pages

Comments
3 min read
AI-Assisted SQL Development with Claude Code — Rules, Skills and Agents That Enforce Conventions

AI-Assisted SQL Development with Claude Code — Rules, Skills and Agents That Enforce Conventions

Comments
7 min read
As 12 Regras de Codd: o que torna um banco de dados realmente relacional?

As 12 Regras de Codd: o que torna um banco de dados realmente relacional?

Comments
7 min read
Snowflake SQL Interview Questions – Quick Notes

Snowflake SQL Interview Questions – Quick Notes

Comments
2 min read
Normalization vs. Denormalization: The Great Database Debate

Normalization vs. Denormalization: The Great Database Debate

Comments
2 min read
Database Deep Dive Series

Database Deep Dive Series

1
Comments
1 min read
CĂłmo hablar con tu base de datos usando IA y construir un extractor SQL seguro con Streamlit

CĂłmo hablar con tu base de datos usando IA y construir un extractor SQL seguro con Streamlit

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