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 quick review of SQL Joins

A quick review of SQL Joins

Comments
1 min read
The Open Lakehouse Explained, Then Built on Your Laptop with Dremio and MinIO

The Open Lakehouse Explained, Then Built on Your Laptop with Dremio and MinIO

Comments 1
23 min read
Idempotency Part 2: The Backend Contract - Why ON CONFLICT Is Not Enough

Idempotency Part 2: The Backend Contract - Why ON CONFLICT Is Not Enough

Comments 1
6 min read
Managing Distributed Transactions in Microservices: 2PC, Saga, Kafka

Managing Distributed Transactions in Microservices: 2PC, Saga, Kafka

Comments
5 min read
SQL Joins: Combining Data Across Tables

SQL Joins: Combining Data Across Tables

1
Comments
2 min read
Connecting Power BI to SQL Databases.

Connecting Power BI to SQL Databases.

Comments
2 min read
How to Roll Back a Single MongoDB Migration (Without Nuking the Rest)

How to Roll Back a Single MongoDB Migration (Without Nuking the Rest)

Comments 1
5 min read
Army: A Deep Dive into Java's Most Dialect-Aware Type-Safe SQL DSL

Army: A Deep Dive into Java's Most Dialect-Aware Type-Safe SQL DSL

Comments 1
12 min read
The Query That Got Slower Every Week: A Pagination Post-Mortem

The Query That Got Slower Every Week: A Pagination Post-Mortem

2
Comments 2
8 min read
Valkey 9.1's hash field TTL triples memory use for the pattern its own docs show

Valkey 9.1's hash field TTL triples memory use for the pattern its own docs show

10
Comments 3
8 min read
I built a query language in Rust that talks to PostgreSQL, MongoDB, MySQL and Redis, here's why

I built a query language in Rust that talks to PostgreSQL, MongoDB, MySQL and Redis, here's why

1
Comments 2
2 min read
Subqueries & CTEs: Breaking Complex Queries into Steps

Subqueries & CTEs: Breaking Complex Queries into Steps

1
Comments
2 min read
Database-per-Service is a Trap: Try Logical Schemas

Database-per-Service is a Trap: Try Logical Schemas

2
Comments
3 min read
NuvexaDB 1.0.7: One Embedded .nvx File for .NET, MAUI, and Every Other Host

NuvexaDB 1.0.7: One Embedded .nvx File for .NET, MAUI, and Every Other Host

Comments
7 min read
LocalStore 1.1.0: Room-Style CRUD for .NET MAUI, on the Engine You Pick

LocalStore 1.1.0: Room-Style CRUD for .NET MAUI, on the Engine You Pick

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