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.
When the Dialect IS the API: Reading Army and jOOQ Side by Side, Through PostgreSQL Source
zoro7 profile

When the Dialect IS the API: Reading Army and jOOQ Side by Side, Through PostgreSQL Source

#backend #database #java #sql
Comments
26 min read
WINDOW FUNCTIONS VS AGGREGATE FUNCTIONS
emkoki profile

WINDOW FUNCTIONS VS AGGREGATE FUNCTIONS

#database #programming #sql
Comments
2 min read
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
Online enabling checksums in PG ̶1̶9̶ 20 (was 19 beta but reverted)
franckpachot profile

Online enabling checksums in PG ̶1̶9̶ 20 (was 19 beta but reverted)

#postgres #sql #database #online
Comments
4 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
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
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
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
Grant Matrices or Query Rewrites: A Debate for Agent SQL Least Privilege
dataio_4921 profile

Grant Matrices or Query Rewrites: A Debate for Agent SQL Least Privilege

#postgres #sql #database #ai
Comments 1
8 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
Why "Check Then Write" Booking Logic Breaks Under Real Traffic (And How to Fix It in PostgreSQL)
qasimlak profile

Why "Check Then Write" Booking Logic Breaks Under Real Traffic (And How to Fix It in PostgreSQL)

#architecture #backend #database #sql
Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.