select * from SQL Page 33 - 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.

Philip McClarence

May 4

PostgreSQL Query Rewriting Techniques

#database #performance #postgres #sql

9 min read

samkaruri

May 3

Subqueries vs. CTEs in SQL: What They Are and When to Use Each.

#subqueries #ctes #database #sql

7 min read

May 3

The bug your Typescript compiler and SQL migration both miss

#typescript #sql #database #webdev

1 min read

Jun 3

Query Markdown as a Database with mq-db: SQL, mq, and Interval Indexes

#markdown #database #sql #rust

4 min read

Jun 5

Getting Started with pg_durable: Workflows Inside PostgreSQL

#postgres #sql #database #workflow

11 min read

Adebayo Olaonipekun

Jun 5

Stop Wiring Up Database Drivers Manually — A Simpler Python Database API

#python #database #sql #webdev

5 min read

May 25

The N+1 Query That Killed Our Database, And How I Fixed It

#database #python #django #sql

4 min read

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

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

soy

May 1

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

#database #sql #sqlite

3 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

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