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.
No signup, just boxes and arrows: building a free ER diagram editor

No signup, just boxes and arrows: building a free ER diagram editor

1
Comments
5 min read
Turning PostgreSQL Into an Integration Engine

Turning PostgreSQL Into an Integration Engine

1
Comments
3 min read
Subqueries and CTEs: SQL Gets Readable

Subqueries and CTEs: SQL Gets Readable

Comments
6 min read
Why Standard Indexes Fail: The Architecture of the Covering Index

Why Standard Indexes Fail: The Architecture of the Covering Index

Comments
4 min read
Joins: Combining Tables Without Losing Your Mind

Joins: Combining Tables Without Losing Your Mind

Comments
8 min read
Best Database Clients in 2026: Top SQL GUI Tools Compared

Best Database Clients in 2026: Top SQL GUI Tools Compared

1
Comments
11 min read
The database is where AI agents in production get weird

The database is where AI agents in production get weird

Comments
2 min read
SQLite Formal Verification, Postgres FTS with ParadeDB, & Multi-DB Schema Diff

SQLite Formal Verification, Postgres FTS with ParadeDB, & Multi-DB Schema Diff

Comments
3 min read
I Learned SQL in College - But Nobody Told Me Where to Actually Use It

I Learned SQL in College - But Nobody Told Me Where to Actually Use It

6
Comments 2
3 min read
Acacia DB for VS Code: Map your database usage in source code (1.0.0 1.2.0)

Acacia DB for VS Code: Map your database usage in source code (1.0.0 1.2.0)

Comments
5 min read
PostgreSQL Aggregate and Window Function Tuning

PostgreSQL Aggregate and Window Function Tuning

Comments
9 min read
Subqueries vs CTEs in SQL: Master Nested Queries and Write Cleaner, Smarter Code

Subqueries vs CTEs in SQL: Master Nested Queries and Write Cleaner, Smarter Code

Comments
3 min read
Salesforce Data Engineering Interview Questions

Salesforce Data Engineering Interview Questions

Comments
41 min read
SQL Interview Problems for Data Engineers: 30 Patterns That Actually Get Asked

SQL Interview Problems for Data Engineers: 30 Patterns That Actually Get Asked

3
Comments
15 min read
DuckDB 1.5.2, PostgreSQL Linux 7.0 Regression, & SQLite Formal Verification

DuckDB 1.5.2, PostgreSQL Linux 7.0 Regression, & SQLite Formal Verification

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