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

Sep 22

Our product search only returns rows the scanner can actually answer for

#postgres #sql #database #webdev

5 min read

Ephantus Macharia

Sep 22

Star, Snowflake, or Galaxy? A Practical Guide to Data Warehouse Modeling

#database #sql #ai #data

10 min read

Thiago Longo Moraes

Sep 21

Grading a wrong answer by how wrong it is: ICD-10 proximity scoring in Postgres

#postgres #sql #healthcare #supabase

4 min read

David Mwandairo

Sep 21

Subqueries and CTEs: Asking a Question Inside a Question

#sql #database #tutorial #ctes

8 min read

David Mwandairo

Sep 21

SQL Joins Explained: A Beekeeping Co-op in Six Queries

#sql #tutorial #database

7 min read

Sep 21

Understanding SQL Window Functions

#datascience #sql #analytics

5 min read

Sep 21

A New Take on Raw SQL in Python

#python #sql #opensource

3 min read

Morgan Li

Sep 21

Cost Estimates or Timed Canaries: A Debate for Promoting Agent SQL

#sql #postgres #testing #ai

9 min read

Rahman

Sep 21

SQL Interview Question: Find App Store Power Purchasers with Two-Level GROUP BY

#sql #database #interview #beginners

5 min read

Nick

Sep 21

IQueryable vs IEnumerable: The Line Between C# and SQL

#csharp #dotnet #performance #sql

2 min read

zoro ma

Sep 20

When the Dialect IS the API: Reading Army and jOOQ Side by Side, Through PostgreSQL Source

#backend #database #java #sql

26 min read

Sep 20

WINDOW FUNCTIONS VS AGGREGATE FUNCTIONS

#database #programming #sql

2 min read

Sep 20

Window Functions vs Aggregate Functions in SQL: A Beginner-Friendly Guide

#beginners #database #sql #tutorial

11 min read

Sep 20

When SQL Has Nothing to Say: Handling NULLs

#database #beginners #sql

3 min read

Vishwam

Sep 19

The Postgres job-claim query that silently claims the same job twice

#postgres #backend #database #sql

9 min read

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