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

Amaresh Pelleti

Sep 30

PostgreSQL 19: What's Actually Shipping, What Got Cut

#postgres #database #sql #devops

5 min read

Nida Sahar

Sep 30

A stored procedure can compile and still change its meaning

#sql #database

2 min read

Sep 30

Zero-Downtime Database Migrations: A Practical Guide

#database #postgres #devops #sql

6 min read

Sep 29

DocumentDB 0.109: $match $sort $limit $project covered by index scan

#postgres #sql #database #mongodb

5 min read

Hemlig

Sep 30

QueryAST Lens

#showdev #database #opensource #sql

1 min read

Cristian Carlos dos Santos

Sep 29

What I added to omni-sql after v0.2.5: local analytics, S3, and more

#sql #opensource #database #duckdb

2 min read

Oct 12

5 SQL window-function traps that show up in data engineering interviews (with runnable DuckDB examples)

#sql #dataengineering #duckdb #interview

4 min read

晖莫

Sep 30

ORDER BY Without a Tiebreaker Is a Flaky Test Generator

#sql #postgres #testing #ci

3 min read

Sep 29

SQL Indexes

#dotnet #sql #programming #learning

17 min read

Patrick Omondi Masese

Sep 29

# SQL Joins: How to Combine Tables the Right Way

#backend #database #sql #tutorial

3 min read

Patrick Omondi Masese

Sep 29

# Subqueries & CTEs: Two Ways to Query Inside a Query

#sql #datascience #cte #subquery

3 min read

Sep 29

PostgreSQL vs MySQL: 7 syntax differences that break migrations

#postgres #mysql #database #sql

4 min read

Patrick Omondi Masese

Sep 29

# DDL, DML, DCL & TCL: SQL's Building Blocks in Plain English

#sql #ddl #dml #dcl

4 min read

Sep 29

The NOT IN trap: why your SQL query returns zero rows

#sql #database #postgres #mysql

3 min read

Sep 29

ROW_NUMBER vs RANK vs DENSE_RANK: one of them silently duplicates your Top-N

#sql #database #postgres #mysql

4 min read

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