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.
Why Your Health Data Belongs on Your Device (Not the Cloud): A Local-First Manifesto

Why Your Health Data Belongs on Your Device (Not the Cloud): A Local-First Manifesto

1
Comments 2
4 min read
Rethinking Stream-Batch Unification: Real-Time Processing with Incremental Materialized Views in Apache Cloudberry

Rethinking Stream-Batch Unification: Real-Time Processing with Incremental Materialized Views in Apache Cloudberry

Comments
5 min read
Lessons Learned: Choosing a Flink Distribution for Kubernetes (Bitnami vs Official)

Lessons Learned: Choosing a Flink Distribution for Kubernetes (Bitnami vs Official)

Comments
4 min read
Top 5 Backup Formats and When to Use Them for PostgreSQL

Top 5 Backup Formats and When to Use Them for PostgreSQL

Comments
6 min read
Concurrency Control and Database Recovery in SQLite

Concurrency Control and Database Recovery in SQLite

11
Comments 1
4 min read
MLOps: Data Science Lifecycle with DataSets examples, Workflows and Pipelines.

MLOps: Data Science Lifecycle with DataSets examples, Workflows and Pipelines.

Comments
4 min read
The Myth of ‘Just Connect Lambda to RDS’

The Myth of ‘Just Connect Lambda to RDS’

6
Comments
8 min read
State Management Patterns for Long-Running AI Agents: Redis vs StatefulSets vs External Databases

State Management Patterns for Long-Running AI Agents: Redis vs StatefulSets vs External Databases

Comments
3 min read
JOIN FETCH can be slower than N+1: a reproducible Doctrine benchmark (+ 1-row-per-entity JSON aggregation)

JOIN FETCH can be slower than N+1: a reproducible Doctrine benchmark (+ 1-row-per-entity JSON aggregation)

1
Comments 2
2 min read
Craft and Control Resource Pools on MSSQL

Craft and Control Resource Pools on MSSQL

Comments
3 min read
Managing Mini-Page Memory: The Buffer Pool Behind Bf-Tree

Managing Mini-Page Memory: The Buffer Pool Behind Bf-Tree

15
Comments
4 min read
DB-Toolkit - Database Management Made Simple

DB-Toolkit - Database Management Made Simple

Comments
1 min read
Data Granularity: The Hidden Factor Behind AI Testing Quality

Data Granularity: The Hidden Factor Behind AI Testing Quality

Comments
8 min read
Why Your Fast PostgreSQL Query Suddenly Became Slow: A Deep Dive into MVCC and Index Bloat

Why Your Fast PostgreSQL Query Suddenly Became Slow: A Deep Dive into MVCC and Index Bloat

2
Comments 1
5 min read
TOON vs JSON for LLM Prompts: Can We Reduce Token Usage Without Losing Response Quality?

TOON vs JSON for LLM Prompts: Can We Reduce Token Usage Without Losing Response Quality?

4
Comments
10 min read
3 Steps to Optimize Your Queries for Speed

3 Steps to Optimize Your Queries for Speed

2
Comments
8 min read
Azure Cosmos DB vNext Emulator: Query and Observability Enhancements

Azure Cosmos DB vNext Emulator: Query and Observability Enhancements

Comments
10 min read
Scaling the Data Layer in Distributed Systems

Scaling the Data Layer in Distributed Systems

1
Comments
4 min read
Understanding Database Indexes: How They Work and When They Hurt Performance

Understanding Database Indexes: How They Work and When They Hurt Performance

Comments
6 min read
5 Surprising Truths About Your SQL SELECT Query (And Why They Matter)

5 Surprising Truths About Your SQL SELECT Query (And Why They Matter)

1
Comments
4 min read
Navigating Database Trends: NoSQL, PostgreSQL, & Beyond for Modern Data

Navigating Database Trends: NoSQL, PostgreSQL, & Beyond for Modern Data

Comments
4 min read
A Critical Analysis of Kysera: Why This Project Exists

A Critical Analysis of Kysera: Why This Project Exists

Comments
7 min read
How I Built a "Story-to-Data" Engine in Python (Because Faker Wasn't Enough)

How I Built a "Story-to-Data" Engine in Python (Because Faker Wasn't Enough)

1
Comments
3 min read
Databases Made Easy: Understanding How Data Powers Modern Software

Databases Made Easy: Understanding How Data Powers Modern Software

Comments 1
2 min read
What's the solution to CAP theorem in Read Replicas?

What's the solution to CAP theorem in Read Replicas?

2
Comments
3 min read
loading...