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.
Best Databricks Data Modeling Tools (2026): SQLDBM, dbt, erwin & ER/Studio Compared

Best Databricks Data Modeling Tools (2026): SQLDBM, dbt, erwin & ER/Studio Compared

Comments
10 min read
Estrategias de respaldo y recuperaciĂłn de PostgreSQL con Docker, Render y GitHub Actions

Estrategias de respaldo y recuperaciĂłn de PostgreSQL con Docker, Render y GitHub Actions

Comments
12 min read
My AI Agent Kept Missing Deadlines and Double-Posting — Here's How I Fixed It with JSON Interfaces and Idempotency Checks

My AI Agent Kept Missing Deadlines and Double-Posting — Here's How I Fixed It with JSON Interfaces and Idempotency Checks

Comments 1
4 min read
What getting into thirteen database projects' docs actually took

What getting into thirteen database projects' docs actually took

2
Comments
2 min read
Day 05/90: Duplicate Records in RAG — When Different Names Refer to the Same Entity

Day 05/90: Duplicate Records in RAG — When Different Names Refer to the Same Entity

3
Comments
6 min read
Database Engines 101: How They Work, the Main Types, and How to Swap Them in PostgreSQL

Database Engines 101: How They Work, the Main Types, and How to Swap Them in PostgreSQL

1
Comments 2
10 min read
Async LINQ: Why ToListAsync Exists (And Why WhereAsync Doesn't)

Async LINQ: Why ToListAsync Exists (And Why WhereAsync Doesn't)

Comments 1
3 min read
Storing Scraped Data: CSV, JSONL, or SQLite Before Your Pipeline Bends

Storing Scraped Data: CSV, JSONL, or SQLite Before Your Pipeline Bends

Comments 2
3 min read
Our Dashboard Looked Fine. The Database Was Out of Connections.

Our Dashboard Looked Fine. The Database Was Out of Connections.

Comments
4 min read
RecallOps: Building Persistent Memory for Engineering Incident Response

RecallOps: Building Persistent Memory for Engineering Incident Response

Comments 1
5 min read
Changing one field in a 100KB document, in Postgres and in MongoDB

Changing one field in a 100KB document, in Postgres and in MongoDB

9
Comments
6 min read
What Building an LLM-Offloaded Query Layer Taught Me

What Building an LLM-Offloaded Query Layer Taught Me

1
Comments 1
16 min read
Window Functions, Joins, CTEs and Subqueries in SQL: A Hospital Dataset Walkthrough.

Window Functions, Joins, CTEs and Subqueries in SQL: A Hospital Dataset Walkthrough.

Comments
9 min read
PostgreSQL vs MongoDB di Era AI: Masihkah Document Store Menjadi Pilihan Utama?

PostgreSQL vs MongoDB di Era AI: Masihkah Document Store Menjadi Pilihan Utama?

Comments 2
2 min read
How to Give Claude & Cursor Safe Database Access Without Crashing Production (Zero-Trust MCP Guard in Python)

How to Give Claude & Cursor Safe Database Access Without Crashing Production (Zero-Trust MCP Guard in Python)

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