Forem

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
I Built a Scalable Financial Transaction System That Stays Correct Under Load

I Built a Scalable Financial Transaction System That Stays Correct Under Load

1
Comments
4 min read
AWS Databases!
Cover image for AWS Databases!

AWS Databases!

Comments
2 min read
TailwindSQL: The Weirdest, and Maybe Nicest, Developer Trend You’ll See Today
Cover image for TailwindSQL: The Weirdest, and Maybe Nicest, Developer Trend You’ll See Today

TailwindSQL: The Weirdest, and Maybe Nicest, Developer Trend You’ll See Today

5
Comments 1
4 min read
🔐 How I Recovered My MySQL Root Password on Windows (MySQL 8.0) — Step by Step
Cover image for 🔐 How I Recovered My MySQL Root Password on Windows (MySQL 8.0) — Step by Step

🔐 How I Recovered My MySQL Root Password on Windows (MySQL 8.0) — Step by Step

1
Comments
2 min read
Part 5: Building a ZIP Code Dimension Table
Cover image for Part 5: Building a ZIP Code Dimension Table

Part 5: Building a ZIP Code Dimension Table

Comments
2 min read
EP 7: The "Join" Tax vs. The "Storage" Tax

EP 7: The "Join" Tax vs. The "Storage" Tax

Comments
4 min read
EP 6.4: What is SHARDING?

EP 6.4: What is SHARDING?

Comments
3 min read
PostgreSQL backup and restore — Complete guide to backing up and restoring databases
Cover image for PostgreSQL backup and restore — Complete guide to backing up and restoring databases

PostgreSQL backup and restore — Complete guide to backing up and restoring databases

Comments
8 min read
The Ultimate Guide to Data Engineering on Google Cloud (2026)
Cover image for The Ultimate Guide to Data Engineering on Google Cloud (2026)

The Ultimate Guide to Data Engineering on Google Cloud (2026)

5
Comments
3 min read
Using Bitmasks for Role-Based Permissions: Stop Querying Your Database

Using Bitmasks for Role-Based Permissions: Stop Querying Your Database

Comments
11 min read
🍯 Announcing HoneyDrunk.Data: A Multi-Tenant Persistence Layer for Distributed .NET Applications
Cover image for 🍯 Announcing HoneyDrunk.Data: A Multi-Tenant Persistence Layer for Distributed .NET Applications

🍯 Announcing HoneyDrunk.Data: A Multi-Tenant Persistence Layer for Distributed .NET Applications

Comments
4 min read
Headless Raspberry Pi Homelab – Part 3: SSH & MariaDB (MySQL Compatible) Installation

Headless Raspberry Pi Homelab – Part 3: SSH & MariaDB (MySQL Compatible) Installation

Comments
2 min read
EP 6.3: Master-Slave Architecture

EP 6.3: Master-Slave Architecture

Comments
3 min read
An Algebraic View of Databases
Cover image for An Algebraic View of Databases

An Algebraic View of Databases

5
Comments
3 min read
SQL*Plus: Guia Completo para Gerenciamento de Banco de Dados Oracle
Cover image for SQL*Plus: Guia Completo para Gerenciamento de Banco de Dados Oracle

SQL*Plus: Guia Completo para Gerenciamento de Banco de Dados Oracle

1
Comments
4 min read
Understanding How Applications Talk to SQLite Internally
Cover image for Understanding How Applications Talk to SQLite Internally

Understanding How Applications Talk to SQLite Internally

10
Comments
4 min read
Unveiling the Power of Databases in the Realm of Big Data

Unveiling the Power of Databases in the Realm of Big Data

Comments
2 min read
How to Build an AI Agent that Builds Full-Stack Apps
Cover image for How to Build an AI Agent that Builds Full-Stack Apps

How to Build an AI Agent that Builds Full-Stack Apps

Comments
6 min read
Solving the 1MiB ConfigMap Limit in Kubernetes

Solving the 1MiB ConfigMap Limit in Kubernetes

Comments
8 min read
Preventing Data Inconsistency in High-Frequency Transaction Systems

Preventing Data Inconsistency in High-Frequency Transaction Systems

Comments
4 min read
Direct SQL Execution and Concurrency in SQLite
Cover image for Direct SQL Execution and Concurrency in SQLite

Direct SQL Execution and Concurrency in SQLite

21
Comments
5 min read
PostgreSQL WAL archiving explained — Understanding Write-Ahead Logs for backup and recovery
Cover image for PostgreSQL WAL archiving explained — Understanding Write-Ahead Logs for backup and recovery

PostgreSQL WAL archiving explained — Understanding Write-Ahead Logs for backup and recovery

2
Comments
8 min read
Linked Server vs OPENQUERY vs OPENROWSET vs OPENDATASOURCE
Cover image for Linked Server vs OPENQUERY vs OPENROWSET vs OPENDATASOURCE

Linked Server vs OPENQUERY vs OPENROWSET vs OPENDATASOURCE

1
Comments
4 min read
SQL Aggregations Finally Made Sense: GROUP BY, HAVING, MIN, MAX, AVG

SQL Aggregations Finally Made Sense: GROUP BY, HAVING, MIN, MAX, AVG

15
Comments 2
3 min read
Building a B-tree in Go: The gap between theory and implementation

Building a B-tree in Go: The gap between theory and implementation

Comments
5 min read
loading...