Post · August 12, 2025
Using PostgreSQL to Replace DynamoDB: A Practical Migration Guide
A practical, engineering-focused guide to replacing DynamoDB with PostgreSQL: schema design, indexing, transactions, and where the tradeoffs really bite.
Read →Tag Archive
Database Engineering
Archive for this tag.
Posts
-
-
Post · August 12, 2024
From JSON Documents to SQL Tables: Patterns, Practices, and Pitfalls of Relational Migration
A practical engineering guide to migrating JSON document databases into relational SQL schemas - covering normalization patterns, anti-patterns, migration tooling, and hard-won lessons.
- #backend development
- #data modeling
- #database engineering
- #database migration
- #database normalization
-
Post · November 22, 2019
SQL Patterns, Anti-Patterns, and Pitfalls: A Practical Guide for Engineers
A practical guide to SQL design patterns, common anti-patterns, and performance pitfalls, with concrete examples for engineers who work with relational databases daily.
- #back-end development
- #database engineering
- #database indexing
- #database normalization
- #n+1 query problem
-
Post · November 19, 2019
Relational Databases Explained: Fundamentals Every Engineer Should Master
A practical guide to relational database fundamentals: the relational model, ACID, normalization, indexing, and trade-offs, with real code for engineers.
Read → -
Post · November 17, 2019
SQL Fundamentals: A Hands-On Guide to the Basics Every Developer Needs
Learn SQL fundamentals through practical examples: queries, joins, indexes, transactions, and normalization - a hands-on guide built for developers who want real understanding.
- #back-end development
- #database engineering
- #database transactions
- #query optimization
- #relational databases