Forem

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
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
Cover image for 🚀 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
Cover image for 🔄 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
Cover image for âš¡ High-Performance Warehousing: Partitioning & Clustering
de_clerke profile

âš¡ High-Performance Warehousing: Partitioning & Clustering

#partitioning #clustering #datawarehouse #database
Comments
2 min read
CP Systems Explained: The Hidden Cost of Strong Consistency
Cover image for 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.
Cover image for 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
Cover image for 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
Cover image for 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
Cover image for 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.
Cover image for 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
Cover image for 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
Cover image for 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
Cover image for 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
POWER BI- Schema and Data Modelling.
tonny-o profile

POWER BI- Schema and Data Modelling.

#analytics #database #dataengineering #microsoft
Comments
2 min read
POWER BI : MODELLING AND SCHEMAS.
Cover image for POWER BI : MODELLING AND SCHEMAS.
mg-stella profile

POWER BI : MODELLING AND SCHEMAS.

#beginners #data #database
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.