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.

Son Tran

Nov 11

MySQL ENUM vs CHECK Constraint: Which Value List Changes Copy the Table

#mysql #database #sql #devops

10 min read

Nov 11

Transactions & Basic Indexing in PostgreSQL: COMMIT, ROLLBACK, EXPLAIN & SQLAlchemy ⚛️

#backend #database #postgres #sql

16 min read

Gunjit Chhatwal

Nov 11

Safely Running Long-Running Index Operations in SQL Server

#database #performance #sql

11 min read

Nov 11

How to Reduce Azure SQL Costs: A Practical Checklist (2026)

#sql #sqlserver #database #azure

4 min read

hiro@

Nov 11

SQLite foreign keys do not create child indexes: inspect a parent deletion plan

#sqlite #sql #database #testing

3 min read

Nov 11

SQL Challenge: Can You Group Customers by Income Using CASE WHEN?

#database #tutorial #sql #oracle

2 min read

Vladimir Osipov for Excession Labs

Nov 11

SQL injection example: login bypass and UNION reads on a local API

#security #webdev #appsec #sql

8 min read

Nov 11

SSHole. Can this star be trusted? Or CVE-2026–123158

#programming #security #linux #sql

2 min read

Ryan Nr

Nov 11

A database client that knows which connection is production

#database #sql #opensource #productivity

3 min read

Illia Khorunzhyi

Nov 10

Our open dataset said paid streams last 11 hours. It was one customer.

#datascience #analytics #postmortem #sql

5 min read

Israa

Nov 10

Offset vs cursor pagination in SQL

#postgres #sql #interview #pagination

5 min read

Son Tran

Nov 10

MariaDB to MySQL Migration: Which Schema Features Break, and How to Find Them First

#mariadb #mysql #database #sql

12 min read

Nov 10

Ensuring type safe database queries and migrations with Node

#sql #node #tooling

6 min read

Dataspryva

Nov 10

Your priority account count is not your A-grade count

#datascience #python #analytics #sql

7 min read

Srimanta Narayan Ghosh

Nov 10

I built a MySQL practice lab on SQLite in the browser. Here is where the two disagree

#sql #sqlite #webassembly #javascript

3 min read

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