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.
🏦 OLTP vs. OLAP: Why One Database Isn't Enough
de_clerke profile

🏦 OLTP vs. OLAP: Why One Database Isn't Enough

#datawarehouse #oltp #olap #database
Comments
2 min read
Real-World ETL Pipeline from a Public Google Sheet
john_analytics profile

Real-World ETL Pipeline from a Public Google Sheet

#database #dataengineering #python #tutorial
1
Comments
3 min read
🚀 UUIDv4 vs UUIDv7 in PostgreSQL
fazal_mansuri_ profile

🚀 UUIDv4 vs UUIDv7 in PostgreSQL

#database #performance #postgres #systemdesign
3
Comments
3 min read
🔄 ETL vs. ELT: The Evolution of Data Integration
de_clerke profile

🔄 ETL vs. ELT: The Evolution of Data Integration

#dataengineering #database #etl #elt
Comments
2 min read
⚡ High-Performance Warehousing: Partitioning & Clustering
de_clerke profile

⚡ High-Performance Warehousing: Partitioning & Clustering

#partitioning #clustering #datawarehouse #database
Comments
2 min read
Step by Step Guide to Elasticsearch
md_monowarulamin200042 profile

Step by Step Guide to Elasticsearch

#backend #beginners #database #tutorial
1
Comments
17 min read
CP Systems Explained: The Hidden Cost of Strong Consistency
amalik18 profile

CP Systems Explained: The Hidden Cost of Strong Consistency

#distributedsystems #database #postgres #backend
Comments
16 min read
Your Database Failover Doesn't Work. Ask Me How I Know.
sathvikcheela profile

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

#node #database #mongodb #redis
Comments
3 min read
CAP Theorem Explained: Beyond the "Pick Two" Myth
amalik18 profile

CAP Theorem Explained: Beyond the "Pick Two" Myth

#distributedsystems #systemdesign #database #backend
Comments
8 min read
From Zero to Cached: Building a High-Performance Housing Portal with Django, Next.js, and Redis — Part 2: The Data Layer
ajitkumar profile

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

#postgres #schema #database #django
Comments
21 min read
PostgreSQL automated backups — How to set up automated PostgreSQL backup schedules
piteradyson profile

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

#database #postgres
Comments
7 min read
Your Data Lakehouse Is Passive. Here’s How to Make It Agentic.
alexmercedcoder profile

Your Data Lakehouse Is Passive. Here’s How to Make It Agentic.

#agents #ai #database #dataengineering
Comments
5 min read
Bancos de Dados Relacionais: A Estrutura que Sustenta Aplicações Modernas
maurilosantos profile

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

#architecture #backend #database #sql
Comments
3 min read
The Tree Interface: Where Pages Become Structure in SQLite
lovestaco profile

The Tree Interface: Where Pages Become Structure in SQLite

#webdev #programming #database #architecture
15
Comments
4 min read
Data Migration Between Servers Using BTEQ Scripts in Informatica Cloud
hira_12345 profile
Hira

Data Migration Between Servers Using BTEQ Scripts in Informatica Cloud

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