Database Design Archives

ERD Design with dbdiagram.io: From Concept to Auto-Generated SQL

June 24, 2026

Jumping straight into SQL without a plan leads to messy schemas that are painful to refactor later. This guide walks through designing an ERD with dbdiagram.io using DBML syntax, then automatically exporting production-ready SQL — no boilerplate required.

Database

PostgreSQL Database Design Patterns: Polymorphic Association vs EAV vs JSONB for Flexible Schema

June 13, 2026

Comparing Polymorphic Association, EAV, and JSONB in PostgreSQL for flexible schema design — from a real 2 AM production incident. Includes migration guide from EAV to JSONB and practical code examples.

Database

Soft Delete Pattern in Database: Safe Record Deletion, Recovery, and Index Optimization with PostgreSQL and MySQL

May 21, 2026

Soft delete pattern lets you mark records as deleted instead of physically removing them — enabling safe recovery, audit trails, and GDPR-compliant data retention. This guide covers practical implementation in PostgreSQL and MySQL, including partial indexes, unique constraint handling, and cleanup strategies.

Database

PostgreSQL Multi-tenancy: Choosing Between Schemas and RLS for Your SaaS

April 20, 2026

How do you ensure data isolation in a SaaS app? We compare PostgreSQL Schema-based isolation and Row-Level Security (RLS) with concrete examples and performance tips.

Database

Scaling PostgreSQL to Billions of Rows: A Practical Guide to Partitioning

April 12, 2026

Scale your PostgreSQL database effectively. This guide covers range, list, and hash partitioning with practical code examples and automation strategies for billion-row tables.

Database

Database Normalization: From ‘God Tables’ to Clean Architecture (1NF to 3NF)

March 31, 2026

Transform messy 'God Tables' into efficient database schemas. Learn the practical steps to reach 1NF, 2NF, and 3NF with SQL examples and real-world trade-offs.