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.
Design a notification system: the system design interview walkthrough

Design a notification system: the system design interview walkthrough

Comments 1
15 min read
Your Postgres ID columns will run out of numbers. Here's a 10-second check (and the trap that hides it)

Your Postgres ID columns will run out of numbers. Here's a 10-second check (and the trap that hides it)

Comments
4 min read
Blind SQL Injection (Oracle): Intruder ile Administrator Şifresini Karakter Karakter Çıkarmak

Blind SQL Injection (Oracle): Intruder ile Administrator Şifresini Karakter Karakter Çıkarmak

Comments
4 min read
The SQL NOT IN Trap: When NULL Quietly Breaks Your Query

The SQL NOT IN Trap: When NULL Quietly Breaks Your Query

4
Comments 8
4 min read
Easy Model v2.1.0: Less Eloquent Boilerplate, More Control

Easy Model v2.1.0: Less Eloquent Boilerplate, More Control

Comments
2 min read
Session Budgets or Driver Caps: A Debate for Agent SQL Exploration

Session Budgets or Driver Caps: A Debate for Agent SQL Exploration

Comments
7 min read
Design a Rate Limiter: the system design interview walkthrough

Design a Rate Limiter: the system design interview walkthrough

Comments 1
14 min read
The refund arrived after the payout, so the fix was two nullable columns and no code

The refund arrived after the payout, so the fix was two nullable columns and no code

Comments
4 min read
DMS Database Design

DMS Database Design

Comments
2 min read
SQL: Find the Top 2 Orders for Every Customer Using Window Functions

SQL: Find the Top 2 Orders for Every Customer Using Window Functions

Comments
3 min read
I changed the rows. PostgreSQL's statistics still remembered them.

I changed the rows. PostgreSQL's statistics still remembered them.

2
Comments 5
4 min read
How to Easily Convert JSON and Excel Files to SQL Insert Statements

How to Easily Convert JSON and Excel Files to SQL Insert Statements

Comments
1 min read
SQL Pagination

SQL Pagination

Comments
13 min read
dbForge 2026.2 Makes Its AI SQL Assistant Free: Here’s What Developers Get

dbForge 2026.2 Makes Its AI SQL Assistant Free: Here’s What Developers Get

3
Comments
4 min read
Designing the Data Model for Tracking Brands in LLM Answers

Designing the Data Model for Tracking Brands in LLM Answers

Comments
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.