DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Window Functions vs Aggregate Functions in SQL: A Beginner-Friendly Guide
joseph_mwangi_3ae1f57a132 profile

Window Functions vs Aggregate Functions in SQL: A Beginner-Friendly Guide

#beginners #database #sql #tutorial
1
Comments
11 min read
The Postgres job-claim query that silently claims the same job twice
vishwam_1705 profile

The Postgres job-claim query that silently claims the same job twice

#postgres #backend #database #sql
Comments
9 min read
Common SQL Injection Vulnerabilities in Student Projects and How to Prevent Them
remysterling profile

Common SQL Injection Vulnerabilities in Student Projects and How to Prevent Them

#sql #database
Comments
6 min read
Meta's "Combined Reaction Volume" SQL Question, Explained Simply
rahmanfrr profile

Meta's "Combined Reaction Volume" SQL Question, Explained Simply

#sql #database #interview #tutorial
Comments
3 min read
How We Built an In-Database AI Agent in Pure T-SQL (And Fixed Its Hidden Architectural Blindspots)
rick_hoek_c401925e5aec039 profile

How We Built an In-Database AI Agent in Pure T-SQL (And Fixed Its Hidden Architectural Blindspots)

#sql #ai #architecture #database
Comments
5 min read
Understanding SQL: A Practical Guide to Categories, Data Types, Joins, and Core Concepts
abudkip profile

Understanding SQL: A Practical Guide to Categories, Data Types, Joins, and Core Concepts

#sql #database #programming #beginners
1
Comments
4 min read
A CSV Can Be Valid and Still Corrupt Your Import
silvio_greco profile

A CSV Can Be Valid and Still Corrupt Your Import

#dataengineering #sql #database #csv
Comments
2 min read
What if your Python database code didn't care which database you used?
joshtom profile

What if your Python database code didn't care which database you used?

#backend #database #python #sql
Comments
2 min read
SELECT * and INSERT ... SELECT Broke Production at 3am
_66d02d0cc1ece7d1137c5f profile

SELECT * and INSERT ... SELECT Broke Production at 3am

#sql #migrations #ci #postgres
Comments
3 min read
Query Fingerprints or Literal Text Diffs: A Debate for Agent SQL Regression
dataio_4921 profile

Query Fingerprints or Literal Text Diffs: A Debate for Agent SQL Regression

#sql #postgres #ai #testing
Comments
7 min read
The Same Row Twice: Four Things Keyset Pagination Needs
hidetzu profile

The Same Row Twice: Four Things Keyset Pagination Needs

#postgres #sql #api #database
Comments
6 min read
Database index on generated column to speed up selection on date (for daily stats)
cyrille37 profile

Database index on generated column to speed up selection on date (for daily stats)

#database #performance #sql
Comments
1 min read
SQL Joins Explained.
josephine_mackylah_d6b31f profile

SQL Joins Explained.

#sql #beginners #basic
2
Comments
2 min read
What is dbt and Why is it in Every Data Engineering Job Listing?
neha_christina_1ac8651819 profile

What is dbt and Why is it in Every Data Engineering Job Listing?

#dataengineering #sql #beginners #dbt
Comments
3 min read
Idempotent APIs Without Idempotency Tokens
kharesam profile

Idempotent APIs Without Idempotency Tokens

#java #database #api #sql
Comments
8 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.