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.
A per-order margin ledger: reconciling what you quoted against what the carrier billed

A per-order margin ledger: reconciling what you quoted against what the carrier billed

Comments
4 min read
Spend an Hour Looking at the Real Data

Spend an Hour Looking at the Real Data

Comments
2 min read
Database MCP Server: Should an AI Agent Run SQL or Only Read the Schema?

Database MCP Server: Should an AI Agent Run SQL or Only Read the Schema?

Comments
7 min read
ON DELETE SET NULL vs CASCADE vs RESTRICT in PostgreSQL: Which to Use

ON DELETE SET NULL vs CASCADE vs RESTRICT in PostgreSQL: Which to Use

Comments
8 min read
A PostgreSQL Role That Reads the Schema but Not the Data: What to Grant

A PostgreSQL Role That Reads the Schema but Not the Data: What to Grant

Comments
8 min read
Adding a NOT NULL Column to a Large PostgreSQL Table: Constant Default, Backfill or NOT VALID

Adding a NOT NULL Column to a Large PostgreSQL Table: Constant Default, Backfill or NOT VALID

Comments
10 min read
I Tried to Make Natural Language a SQL Predicate. The Numbers Said No.

I Tried to Make Natural Language a SQL Predicate. The Numbers Said No.

Comments
7 min read
SQL Window Functions Explained

SQL Window Functions Explained

Comments
4 min read
"A second operation was started on this context" — the EF Core bug that only shows up under load

"A second operation was started on this context" — the EF Core bug that only shows up under load

Comments 1
3 min read
5 Lessons I Learned Building API-Driven Fintech Products

5 Lessons I Learned Building API-Driven Fintech Products

Comments
2 min read
The three-object CRM data model that ends your data silos

The three-object CRM data model that ends your data silos

Comments
4 min read
IEnumerable vs IQueryable: Where Does Your Query Actually Run?

IEnumerable vs IQueryable: Where Does Your Query Actually Run?

Comments
2 min read
Secure AI Driven Database Access with db-mcp-gateway

Secure AI Driven Database Access with db-mcp-gateway

Comments
3 min read
3 Redis Design Failures You Should Avoid Before They Become Production Incidents

3 Redis Design Failures You Should Avoid Before They Become Production Incidents

Comments
6 min read
SQL vs NoSQL: An Honest Decision Guide

SQL vs NoSQL: An Honest Decision Guide

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