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

Oct 15

The SQL Behind an AI Visibility Dashboard: Five Metrics and Their Traps

#sql #analytics #dataviz #ai

5 min read

Oct 15

MySQL GROUP_CONCAT with ORDER BY, SEPARATOR and DISTINCT (Tested on 8.4)

#mysql #sql #database #beginners

9 min read

Oct 15

Optimistic Locking vs. Pessimistic Locking — Handling Concurrent Updates in SQL Databases

#architecture #database #sql

2 min read

Gowtham Potureddi

Oct 15

Design a recommendation system: the ML system design interview walkthrough

#designsystem #interview #dataengineering #sql

17 min read

Gowtham Potureddi

Oct 15

Design object storage (Amazon S3): the system design interview walkthrough

#designsystem #interview #dataengineering #sql

17 min read

Gowtham Potureddi

Oct 15

Design a distributed job scheduler: the system design interview walkthrough

#designsystem #sql #interview #dataengineering

17 min read

Uptime Architect

Oct 14

You Deleted 99% of the Rows. The Full Scan Didn't Get Any Faster.

#oracle #database #performance #sql

9 min read

Oct 15

PCAD-31-02 in Code: Validation Checks and Safe sqlite3 Queries Behind 30 of the 48 Items

#python #sql #datascience #tutorial

9 min read

Ravindu Thaksara

Oct 15

How to Set Up SQL Server Management Studio (SSMS) on a Windows PC

#sql #database #mysql #devchallenge

4 min read

Oct 14

There Is Already an Object Named 'X' in the Database: What EF Core Is Really Telling You

#dotnet #csharp #database #sql

9 min read

Null

Oct 14

A patched SQL Server cluster stops syncing. The failure is identity, not the patch.

#sql #database #sqlserver #devops

3 min read

Oct 14

Database Indexes and Idempotency: What They Fix, and How to Get Them Wrong

#database #sql #dotnet #backend

7 min read

Oct 14

Subquery vs CTE in SQL: When and How to Use Each

#sql #postgres #database #beginners

3 min read

Oct 14

Primary Key vs Foreign Key in SQL: How Tables Connect

#sql #postgres #database #beginners

3 min read

Oct 14

Our free plan hides creators with a window function, and the locked count is the same predicate with a "not" in front

#postgres #sql #typescript #saas

5 min read

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