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.
Isolation Levels

Isolation Levels

Comments
19 min read
16 Parquet files in a bucket we do not own, and the only client is DuckDB

16 Parquet files in a bucket we do not own, and the only client is DuckDB

Comments
5 min read
Stop Picking a Side: How to Use Spring Data JPA and jOOQ Together in One Spring Boot App

Stop Picking a Side: How to Use Spring Data JPA and jOOQ Together in One Spring Boot App

1
Comments
7 min read
Pause became a question with three answers, so we wrote the rules twice and only one copy has tests

Pause became a question with three answers, so we wrote the rules twice and only one copy has tests

Comments
7 min read
De "se cayó la VM" a "estamos de vuelta"

De "se cayó la VM" a "estamos de vuelta"

Comments
4 min read
Analytics Engineer: The Job That Didn't Exist 5 Years Ago (and Why It Does Now)

Analytics Engineer: The Job That Didn't Exist 5 Years Ago (and Why It Does Now)

14
Comments
7 min read
Hiding the table is not enough. Your LLM can still see the salary column.

Hiding the table is not enough. Your LLM can still see the salary column.

Comments
2 min read
Database Indexes, Explained Like a Book Index

Database Indexes, Explained Like a Book Index

1
Comments
3 min read
MAX()+1: The Invoice Number That Showed Up Twice

MAX()+1: The Invoice Number That Showed Up Twice

Comments
4 min read
The free plan searches exactly like the paid one and hides the results, and the blurred rows are fake on purpose

The free plan searches exactly like the paid one and hides the results, and the blurred rows are fake on purpose

Comments
6 min read
Deadlocks (SQL Server)

Deadlocks (SQL Server)

Comments
18 min read
Who stabbed Samuel Ratchett 12 times?🔪

Who stabbed Samuel Ratchett 12 times?🔪

Comments
1 min read
One missing index turned a 40ms query into a 12-second one

One missing index turned a 40ms query into a 12-second one

Comments
3 min read
Turn Database Docs into Agent-Ready Knowledge (OKF Series, Part 3)

Turn Database Docs into Agent-Ready Knowledge (OKF Series, Part 3)

Comments
22 min read
Build a Knowledge Layer for SQL Agents with OKF (Part 2)

Build a Knowledge Layer for SQL Agents with OKF (Part 2)

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