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
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
7 PostgreSQL extensions that will supercharge your database in 2026

7 PostgreSQL extensions that will supercharge your database in 2026

Comments
9 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
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
1.2.1 From SQL Text to Raw Parse Tree

1.2.1 From SQL Text to Raw Parse Tree

Comments 1
9 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
Data modelling in Power BI: Joins, Relationships, and Schemas Explained.

Data modelling in Power BI: Joins, Relationships, and Schemas Explained.

Comments
2 min read
(5)When Your Data Warehouse Breaks Down, It’s Probably a Naming Problem

(5)When Your Data Warehouse Breaks Down, It’s Probably a Naming Problem

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