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.
Stop Letting AI Write Your Database Migrations

Stop Letting AI Write Your Database Migrations

Comments 1
5 min read
PostgreSQL Restore Failures: It Wasn’t pgBackRest, It Was My Recovery Logic

PostgreSQL Restore Failures: It Wasn’t pgBackRest, It Was My Recovery Logic

5
Comments 1
6 min read
The Agent Data Layer: A Missing Layer in AI Architecture

The Agent Data Layer: A Missing Layer in AI Architecture

1
Comments
2 min read
Performance and Apache Iceberg's Metadata

Performance and Apache Iceberg's Metadata

Comments
7 min read
What happens when every developer on your team can query production (safely)

What happens when every developer on your team can query production (safely)

Comments
2 min read
How Databases Store Data: B+ Tree Explained Simply for Beginners (With Real-World Examples)

How Databases Store Data: B+ Tree Explained Simply for Beginners (With Real-World Examples)

5
Comments
25 min read
Replacing Elasticsearch with ClickHouse : A 90% Cost-Reduction Migration

Replacing Elasticsearch with ClickHouse : A 90% Cost-Reduction Migration

4
Comments
33 min read
Stop Using Subqueries: 3 Advanced SQL CTE Patterns That Saved My Production Database

Stop Using Subqueries: 3 Advanced SQL CTE Patterns That Saved My Production Database

Comments 1
3 min read
Why I Switched from ChromaDB to ElasticSearch (and What I Miss)

Why I Switched from ChromaDB to ElasticSearch (and What I Miss)

Comments
6 min read
Build a Searchable Catalog with Filters, Facets, and Semantic Search

Build a Searchable Catalog with Filters, Facets, and Semantic Search

Comments
6 min read
MySQL InnoDB Locking: The Silent Killer Behind Database Crashes

MySQL InnoDB Locking: The Silent Killer Behind Database Crashes

Comments 1
24 min read
Video Search with MongoDB

Video Search with MongoDB

3
Comments
4 min read
How to backup MySQL in Docker — 5 strategies that actually work

How to backup MySQL in Docker — 5 strategies that actually work

Comments
6 min read
SQL String Functions: Clean, Transform, and Tame Messy Data Like a Pro

SQL String Functions: Clean, Transform, and Tame Messy Data Like a Pro

Comments
6 min read
1.2.1 From SQL Text to Raw Parse Tree

1.2.1 From SQL Text to Raw Parse Tree

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