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.
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
I built a native DuckDB IDE in Rust, and the client is DuckDB too

I built a native DuckDB IDE in Rust, and the client is DuckDB too

Comments
3 min read
TeaQL Was 2,000x Faster Than the Obvious SQLx Query—Here’s What Actually Happened

TeaQL Was 2,000x Faster Than the Obvious SQLx Query—Here’s What Actually Happened

Comments
6 min read
Stop Giving Your AI Agent Raw SQL

Stop Giving Your AI Agent Raw SQL

Comments
6 min read
When LINQ Isn't Enough: Raw SQL in Entity Framework Core

When LINQ Isn't Enough: Raw SQL in Entity Framework Core

Comments
4 min read
Estrategias de respaldo de bases de datos con PostgreSQL, Django y despliegue automatizado en la nube

Estrategias de respaldo de bases de datos con PostgreSQL, Django y despliegue automatizado en la nube

Comments
9 min read
Preventing Double-Booking in a Real-Time Appointment System

Preventing Double-Booking in a Real-Time Appointment System

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