80 | Knowledge Hub

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.

Jul 20

NOT IN returned zero rows. It wasn't your data — it was one NULL.

#sql #postgres #database

2 min read

umzzil nng

Jun 16

Oracle ORA-00909 Error: Causes and Solutions Complete Guide

#oracle #database #dba #sql

3 min read

umzzil nng

Jun 16

PostgreSQL 2200S Error: Causes and Solutions Complete Guide

#postgres #database #dba #sql

3 min read

scubaDEV

Jun 15

SELECT MAX()+1 Is a Race Condition Waiting to Happen

#postgres #sql #dotnet #concurrency

3 min read

Jun 15

How to Choose the Right SQL Database for Your Project

#sql #database #beginners #webdev

5 min read

Ali Duyar

Jun 20

SQL - Order By, Limit and Offset

#sql #database #orderby #beginners

1 min read

scubaDEV

Jun 15

Dynamic Column Updates in EF Core Without Hand-Rolling SQL Injection

#dotnet #sql #api #database

3 min read

scubaDEV

Jun 15

Postgres or ClickHouse? Row vs Column Storage, and When Each Wins

#postgres #clickhouse #database #sql

3 min read

W3SHY

Jul 19

SQL Basics Explained: DDL, DML, Filtering, and CASE WHEN

#beginners #database #sql

4 min read

Jul 19

Dynamic SOQL Without Getting Burned

#backend #database #security #sql

7 min read

umzzil nng

Jun 15

PostgreSQL 2200N Error: Causes and Solutions Complete Guide

#postgres #database #dba #sql

3 min read

Jun 15

SQLAlchemy Essentials: A Beginner’s Roadmap

#python #sql #softwaredevelopment #programming

6 min read

umzzil nng

Jun 15

PostgreSQL 2200M Error: Causes and Solutions Complete Guide

#postgres #database #dba #sql

3 min read

Jun 14

Three PostgreSQL Master/Replica Discovery Problems — and How to Solve Them

#postgres #sql #python #programming

17 min read

Mahmoud EL-kariouny

Jun 14

Why SQL Still Rules the Data World: Surprising Truths from the Relational Revolution

#sql #database #datascience #beginners

5 min read

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