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.
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
How B-Tree Indexes Work in SQL Databases: An Intuitive Guide

How B-Tree Indexes Work in SQL Databases: An Intuitive Guide

Comments 1
5 min read
Transaction Management: Where the Pager Becomes the Database in SQLite

Transaction Management: Where the Pager Becomes the Database in SQLite

10
Comments
5 min read
TimescaleDB Compression: From 150GB to 15GB (90% Reduction, Real Production Data)

TimescaleDB Compression: From 150GB to 15GB (90% Reduction, Real Production Data)

7
Comments
12 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
CAP Theorem Explained: Beyond the "Pick Two" Myth

CAP Theorem Explained: Beyond the "Pick Two" Myth

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

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
Your Data Lakehouse Is Passive. Here’s How to Make It Agentic.

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

Comments
5 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
How Growing Apps Break Under Scale: Lessons From Real Systems

How Growing Apps Break Under Scale: Lessons From Real Systems

Comments
6 min read
Agentic Apps with GitHub Copilot SDK

Agentic Apps with GitHub Copilot SDK

4
Comments
1 min read
Data Migration Between Servers Using BTEQ Scripts in Informatica Cloud

Data Migration Between Servers Using BTEQ Scripts in Informatica Cloud

Comments
3 min read
POWER BI- Schema and Data Modelling.

POWER BI- Schema and Data Modelling.

Comments
2 min read
Understanding Vector Databases: A Comprehensive Guide

Understanding Vector Databases: A Comprehensive Guide

2
Comments
5 min read
POWER BI : MODELLING AND SCHEMAS.

POWER BI : MODELLING AND SCHEMAS.

Comments
3 min read
Data Modelling in Power Bi: Star Schema, snowflake schema, fact and dimension tables

Data Modelling in Power Bi: Star Schema, snowflake schema, fact and dimension tables

Comments
3 min read
Killing the N+1 Problem in Laravel: From 120 Queries to 8 in 20 Minutes

Killing the N+1 Problem in Laravel: From 120 Queries to 8 in 20 Minutes

Comments
3 min read
Understanding Schemas and Data Modelling in Power BI

Understanding Schemas and Data Modelling in Power BI

Comments
3 min read
Getting started with Data Modeling in Power BI

Getting started with Data Modeling in Power BI

Comments
4 min read
Master and Slave Databases — the unsung heroes behind smooth apps

Master and Slave Databases — the unsung heroes behind smooth apps

Comments
1 min read
Neuromorphic KV store in Zig

Neuromorphic KV store in Zig

Comments
2 min read
Uncovering and Optimizing Slow Database Queries Through QA Testing Without Documentation

Uncovering and Optimizing Slow Database Queries Through QA Testing Without Documentation

Comments
2 min read
I Eliminated SQLite Race Conditions in a Multi-Threaded Python App 🚀

I Eliminated SQLite Race Conditions in a Multi-Threaded Python App 🚀

Comments
3 min read
Cut Your AWS RDS Bill by 70%: The Complete Cost Optimization Playbook 💰

Cut Your AWS RDS Bill by 70%: The Complete Cost Optimization Playbook 💰

Comments
6 min read
loading...