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

Pipeline Whiteboard

Oct 30

CDC Deletes, Tombstones and the Idempotent MERGE

#dataengineering #kafka #snowflake #sql

7 min read

Dataspryva

Oct 30

Your match results can put a club in the wrong relegation spot

#datascience #python #analytics #sql

6 min read

Bonree-Js

Oct 30

Tracing AI Agents with OpenTelemetry: A Design for LLM and Agentic AI Observability

#discuss #ai #devops #sql

7 min read

Jitendra Suryavanshi

Oct 30

SQL Pattern Matching Without the Pain: LIKE, Wildcards, and the Gotchas Nobody Warns You About

#sql #database #beginners #webdev

4 min read

Oct 30

How to Learn SQL Joins (and Stop Mixing Up LEFT and INNER)

#sql #database #beginners #learning

5 min read

Usman Khan

Oct 29

Foreign Key Cascade Deletes: Un-Indexed FKs, Slow Cascades, and Lock Contention in PostgreSQL

#postgres #database #performance #sql

6 min read

Son Tran

Oct 29

MySQL to PostgreSQL Schema Conversion: What Each Column Type Should Become, and What Silently Changes

#mysql #postgres #database #sql

12 min read

Oct 29

SARGable Queries in SQL Server: Why Functions in WHERE Slow You Down

#sql #sqlserver #database #performance

3 min read

Nov 3

MySQL LIMIT and OFFSET Explained with Simple Examples

#mysql #sql #database #php

6 min read

Oct 29

Teaching yourself SQL when your job is ops

#sql #career #beginners #productivity

2 min read

Chris Rodriguez

Oct 29

Use INSERT WITH CHECK and UPDATE USING to allow owner-on-create but block owner transfers

#sql #security #postgres #database

4 min read

Gina Bise

Oct 29

Filtering Data in SQL: A Beginner’s Guide to WHERE, AND, LIKE and Friends

#beginners #datascience #postgres #sql

3 min read

iMonitor Software

Oct 29

Modelling a shared inbox: why the message is the primary key, not the conversation

#sql #systemdesign #architecture #database

2 min read

Oct 29

5 Common SQL Mistakes: WHERE, ORDER BY, AND/OR, and Top 3 Queries

#sql #database #tutorial #sqlserver

3 min read

Oct 29

VIDRAFT NL2SQL Engine Scores 83.80 on BIRD Mini-Dev, Above the Current #1, and Opens a Public Demo

#ai #sql #database #llm

3 min read

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