DEV Community

Database

Posts on building, using, and learning about databases.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
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
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
48-Hour Field Notes: The Dry Run That Read the Wrong Database

48-Hour Field Notes: The Dry Run That Read the Wrong Database

Comments
6 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
DMS Database Design

DMS Database Design

Comments
2 min read
I measured whether .NET Guid sorting is broken. It isn't.

I measured whether .NET Guid sorting is broken. It isn't.

Comments
2 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
System Design: Optimistic vs Pessimistic Locking

System Design: Optimistic vs Pessimistic Locking

2
Comments 1
28 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
Why We Built an Open-Source, Native macOS Database Client in Swift (And Skipped Electron)

Why We Built an Open-Source, Native macOS Database Client in Swift (And Skipped Electron)

Comments
3 min read
Nobody on Your Team Should Need Your AWS Keys Just to See a Database

Nobody on Your Team Should Need Your AWS Keys Just to See a Database

1
Comments
4 min read
When Your Background Job Retries Are Silently Stepping on Each Other

When Your Background Job Retries Are Silently Stepping on Each Other

Comments
4 min read
Why Write-Heavy Databases Use LSM-Trees: MemTables, SSTables, Bloom Filters, and Compaction Under the Hood

Why Write-Heavy Databases Use LSM-Trees: MemTables, SSTables, Bloom Filters, and Compaction Under the Hood

Comments
9 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
Do you need a vector database? Brute-force search benchmarked from 10k to 1M vectors

Do you need a vector database? Brute-force search benchmarked from 10k to 1M vectors

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