Forem

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
AI-Powered Database Design with MCP Server

AI-Powered Database Design with MCP Server

Comments
4 min read
Data Modeling for Analytics: Optimize for Queries, Not Transactions
Cover image for Data Modeling for Analytics: Optimize for Queries, Not Transactions

Data Modeling for Analytics: Optimize for Queries, Not Transactions

Comments
4 min read
Data Modeling Best Practices: 7 Mistakes to Avoid
Cover image for Data Modeling Best Practices: 7 Mistakes to Avoid

Data Modeling Best Practices: 7 Mistakes to Avoid

Comments
4 min read
How I Self-Host Metabase & Why Your Team Should Too
Cover image for How I Self-Host Metabase & Why Your Team Should Too

How I Self-Host Metabase & Why Your Team Should Too

1
Comments
4 min read
Database documentation fails when it relies on human discipline

Database documentation fails when it relies on human discipline

Comments
1 min read
How I Built a Crash-Safe Database Engine in C with Write-Ahead Logging and Snapshots
Cover image for How I Built a Crash-Safe Database Engine in C with Write-Ahead Logging and Snapshots

How I Built a Crash-Safe Database Engine in C with Write-Ahead Logging and Snapshots

Comments 1
4 min read
Data Vault Modeling: Hubs, Links, and Satellites
Cover image for Data Vault Modeling: Hubs, Links, and Satellites

Data Vault Modeling: Hubs, Links, and Satellites

Comments
4 min read
PostGres Database Replication Using Pglogical
Cover image for PostGres Database Replication Using Pglogical

PostGres Database Replication Using Pglogical

Comments
3 min read
AP Systems Explained: Stale Data Beats Dead Servers
Cover image for AP Systems Explained: Stale Data Beats Dead Servers

AP Systems Explained: Stale Data Beats Dead Servers

Comments
18 min read
Denormalization: When and Why to Flatten Your Data
Cover image for Denormalization: When and Why to Flatten Your Data

Denormalization: When and Why to Flatten Your Data

Comments
4 min read
Why I Split One LangGraph Agent into Four Running in Parallel

Why I Split One LangGraph Agent into Four Running in Parallel

1
Comments
6 min read
How Exposed Postgres view Took 8 Minutes to Retrieve data
Cover image for How Exposed Postgres view Took 8 Minutes to Retrieve data

How Exposed Postgres view Took 8 Minutes to Retrieve data

Comments
3 min read
Why Caching Plugins Don't Fix Slow WordPress Sites

Why Caching Plugins Don't Fix Slow WordPress Sites

Comments
3 min read
Portabase: A self-hosted tool for database backup & restore
Cover image for Portabase: A self-hosted tool for database backup & restore

Portabase: A self-hosted tool for database backup & restore

2
Comments 1
3 min read
Inside SQLite’s Bytecode Language
Cover image for Inside SQLite’s Bytecode Language

Inside SQLite’s Bytecode Language

15
Comments
4 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.