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.

Vaishnav Prabhu

Oct 9

Fan-Out Joins: The Silent Cause of Inflated Metrics

#dataengineering #sql #database #analytics

2 min read

Vaishnav Prabhu

Oct 9

SCD Type-2 Without the Duplicate-Current-Row Footgun

#dataengineering #sql #database #analytics

2 min read

Oct 8

Your Postgres ID columns will run out of numbers. Here's a 10-second check (and the trap that hides it)

#postgres #sql #database #devops

4 min read

Oct 8

Excel Turned a 20% Discount Into 19.999999999999998%. That Hid $2,325.

#sql #beginners #career #excel

7 min read

Yunus Emre Dere

Oct 8

Blind SQL Injection (Oracle): Intruder ile Administrator Şifresini Karakter Karakter Çıkarmak

#cybersecurity #database #security #sql

4 min read

Andrii B.

Oct 8

Migrating a Large Table Without Locking Production

#postgres #database #sql #devops

15 min read

Mahmoud Ramadan

Oct 8

Easy Model v2.1.0: Less Eloquent Boilerplate, More Control

#php #laravel #sql #opensource

2 min read

Morgan Li

Oct 8

Session Budgets or Driver Caps: A Debate for Agent SQL Exploration

#postgres #sql #ai #database

7 min read

Oct 8

The refund arrived after the payout, so the fix was two nullable columns and no code

#database #postgres #webdev #sql

4 min read

Oct 8

SQL: Find the Top 2 Orders for Every Customer Using Window Functions

#dataengineering #database #sql #tutorial

3 min read

Clement Samuel Goodness

Oct 8

DMS Database Design

#architecture #database #sql #writing

2 min read

Goran

Oct 8

How to Easily Convert JSON and Excel Files to SQL Insert Statements

#database #json #sql #tools

1 min read

Oct 7

SQL Pagination

#dotnet #sql #programming #learning

13 min read

Judy

Oct 8

Start and End Dates of the Longest Rising Period

#algorithms #computerscience #database #sql

6 min read

Oct 7

Designing the Data Model for Tracking Brands in LLM Answers

#database #sql #githubactions #ai

6 min read

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