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
The Ultimate Guide to MongoDB Aggregation Pipeline | Concepts, Use Cases and Real Code Examples
kmsaifullah profile

The Ultimate Guide to MongoDB Aggregation Pipeline | Concepts, Use Cases and Real Code Examples

#database #mongodb #node #tutorial
2
Comments
4 min read
Getting Started with Open Data Hub: A Developer’s Guide to Exploring Open Data
opendatahub profile

Getting Started with Open Data Hub: A Developer’s Guide to Exploring Open Data

#database #development #data #buildinpublic
2
Comments
2 min read
Guide to Connecting Power BI to SQL Databases: Local & Cloud Workflows
dennis_ogaka_2d188ab5bef7 profile

Guide to Connecting Power BI to SQL Databases: Local & Cloud Workflows

#database #microsoft #sql #tutorial
1
Comments
5 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
Dev update - [March, 2026]
yuricodesbot profile
Yuri for Supabase

Dev update - [March, 2026]

#webdev #opensource #database #devops
7
Comments
4 min read
From the Database Zoo to the Database Safari
gkoos profile

From the Database Zoo to the Database Safari

#architecture #books #database #writing
3
Comments
1 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
Why modern real-time apps require 5 different systems — and why I built one instead
slipxnot profile

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

#ai #database #backend #agents
3
Comments 5
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
I Built a Self-Hosted Web UI for 11 Databases — Here's Why You Might Want One Too
thesharque profile

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

#devops #database #qa #developer
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
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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.