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.
DuckDB 1.5.2, PostgreSQL Internal Stats, and SQLite Virtual Table xUpdate Deep Dive

DuckDB 1.5.2, PostgreSQL Internal Stats, and SQLite Virtual Table xUpdate Deep Dive

Comments
3 min read
PostgreSQL Said No to Query Hints for 20 Years. Postgres 19 Ships Them.

PostgreSQL Said No to Query Hints for 20 Years. Postgres 19 Ships Them.

15
Comments 3
7 min read
ERD-First Database Design: One 60-Entity Schema, Sketch to Production

ERD-First Database Design: One 60-Entity Schema, Sketch to Production

Comments
7 min read
Session 4 summary

Session 4 summary

Comments
2 min read
Product Analytics with SQL: Tracking What Actually Matters

Product Analytics with SQL: Tracking What Actually Matters

Comments
6 min read
Natural-language SQL needs metric contract tests, not just valid SQL

Natural-language SQL needs metric contract tests, not just valid SQL

4
Comments 1
2 min read
From 8s to 1s: Truly Understanding Rails N+1 by Opening Up ActiveRecord

From 8s to 1s: Truly Understanding Rails N+1 by Opening Up ActiveRecord

2
Comments
10 min read
Modelling, Joins, Relationships and different Schemas

Modelling, Joins, Relationships and different Schemas

Comments
2 min read
Database Indexing and Query Optimization for Python Developers

Database Indexing and Query Optimization for Python Developers

Comments
7 min read
DBMS & SQL Cheat Sheet You Need for Tech Interviews in 2026

DBMS & SQL Cheat Sheet You Need for Tech Interviews in 2026

Comments
4 min read
Database Indexing and Query Optimization for Java Developers

Database Indexing and Query Optimization for Java Developers

Comments
7 min read
You don't need a backend to store form submissions. You need a place to ask "how many."

You don't need a backend to store form submissions. You need a place to ask "how many."

1
Comments 1
2 min read
B-tree block split: what's the impact?

B-tree block split: what's the impact?

2
Comments
12 min read
How to Comment SQL So It Teaches

How to Comment SQL So It Teaches

Comments
12 min read
Implementing Feature Flags Across Stack

Implementing Feature Flags Across Stack

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