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.
🔄 ETL vs. ELT: The Evolution of Data Integration

🔄 ETL vs. ELT: The Evolution of Data Integration

Comments
2 min read
⚡ High-Performance Warehousing: Partitioning & Clustering

⚡ High-Performance Warehousing: Partitioning & Clustering

Comments
2 min read
From the Database Zoo to the Database Safari

From the Database Zoo to the Database Safari

3
Comments
1 min read
CP Systems Explained: The Hidden Cost of Strong Consistency

CP Systems Explained: The Hidden Cost of Strong Consistency

Comments
16 min read
Your Database Failover Doesn't Work. Ask Me How I Know.

Your Database Failover Doesn't Work. Ask Me How I Know.

Comments
3 min read
Why modern real-time apps require 5 different systems — and why I built one instead

Why modern real-time apps require 5 different systems — and why I built one instead

3
Comments 5
3 min read
CAP Theorem Explained: Beyond the "Pick Two" Myth

CAP Theorem Explained: Beyond the "Pick Two" Myth

Comments
8 min read
I Built a Self-Hosted Web UI for 11 Databases — Here's Why You Might Want One Too

I Built a Self-Hosted Web UI for 11 Databases — Here's Why You Might Want One Too

1
Comments
3 min read
From Zero to Cached: Building a High-Performance Housing Portal with Django, Next.js, and Redis — Part 2: The Data Layer

From Zero to Cached: Building a High-Performance Housing Portal with Django, Next.js, and Redis — Part 2: The Data Layer

Comments
21 min read
PostgreSQL automated backups — How to set up automated PostgreSQL backup schedules

PostgreSQL automated backups — How to set up automated PostgreSQL backup schedules

Comments
7 min read
I built a self-hosted database GUI because everything else annoyed me

I built a self-hosted database GUI because everything else annoyed me

2
Comments
4 min read
INSERT Performance Tuning for TimescaleDB

INSERT Performance Tuning for TimescaleDB

2
Comments
4 min read
Bancos de Dados Relacionais: A Estrutura que Sustenta Aplicações Modernas

Bancos de Dados Relacionais: A Estrutura que Sustenta Aplicações Modernas

Comments
3 min read
Connecting Power BI to an SQL Database for Data Analysis: Local & Cloud-Based Connections

Connecting Power BI to an SQL Database for Data Analysis: Local & Cloud-Based Connections

11
Comments
8 min read
How I Scoped a RAG Knowledge Base Per Tenant

How I Scoped a RAG Knowledge Base Per Tenant

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