select * from SQL Page 47 - DEV Community

Skip to content

DEV Community

Allowed

Posts about learning SQL
Posts about tips, tricks, problems, and answers
Posts about news or commentary of the field
Posts about specific tooling or frameworks

Think what would someone wanting to learn more about SQL want to see.

Not Allowed

Articles that mention SQL in passing
Articles that break the terms of use

SQL is the language of data, has been for nearly 50 years now!

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

May 16

💡 MySQL INNER JOIN vs LEFT JOIN — which one should you actually use?

#mysql #database #sql

7 min read

kernz

May 2

I built a 57-line asyncpg wrapper because SQLAlchemy was driving me insane

#sql #python #sqlalchemy #postgres

2 min read

Jun 5

SQL vs NoSQL — How to Choose the Right Database for Your System

#sql #nosql #postgres #systemdesign

2 min read

soy

May 1

DuckDB 1.5.1, MacBook Benchmarks, & Browser-based Postgres Workspace

#database #sql #sqlite

3 min read

Jun 4

REDB inside, part 1 — the 13 tables the whole engine runs on (with the actual SQL, and why it's not EAV)

#dotnet #postgres #sql #opensource

15 min read

Mike Burgh

May 6

Four Ways to Use AI With Your Database in VS Code

#vscode #database #ai #sql

2 min read

Philip McClarence

May 1

PostgreSQL WHERE Clause Optimization

#database #performance #postgres #sql

9 min read

Aviral Srivastava

May 1

Database Indexing Strategies (Clustered vs Non-clustered)

#database #performance #sql #tutorial

10 min read

Gouranga Das Samrat

May 24

Turning PostgreSQL Into an Integration Engine

#postgres #sql #database

3 min read

erdiagram

Jun 4

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

#webdev #svelte #sql #sideprojects

5 min read

Akhilesh

May 1

Subqueries and CTEs: SQL Gets Readable

#sql #database #ai #beginners

6 min read

OPEYEMI OLUWAGBEMIGA

May 2

Why Standard Indexes Fail: The Architecture of the Covering Index

#architecture #database #sql #postgres

4 min read

Akhilesh

May 1

Joins: Combining Tables Without Losing Your Mind

#sql #ai #beginners #python

8 min read

Finn

Jun 4

Best Database Clients in 2026: Top SQL GUI Tools Compared

#ai #sql #database #dataengineering

11 min read

soy

Apr 30

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

#database #sql #sqlite

3 min read

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