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.
SQL Window Functions Explained

SQL Window Functions Explained

Comments
4 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
"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
Relationships in a Relational Database: MySQL vs NebulaGraph from 1 Million to 500 Million Rows

Relationships in a Relational Database: MySQL vs NebulaGraph from 1 Million to 500 Million Rows

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

Secure AI Driven Database Access with db-mcp-gateway

Comments
3 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
Stop Giving Your AI Agent Raw SQL

Stop Giving Your AI Agent Raw SQL

Comments
6 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
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.