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
PostgreSQL
Archive for this tag.
Posts
-
-
Post · May 27, 2023
Real-World ORM Case Studies: Refactors, Bottlenecks, and Project Ideas You Can Ship
Explore real-life ORM case studies, from slow endpoints to migration mishaps and schema redesigns. Get actionable solutions plus project ideas-multi-tenant SaaS, audit logs, and reporting pipelines-to build ORM skills.
Read → -
Post · March 02, 2023
How to Design High-Performance Pagination Algorithms for APIs and Databases
Master pagination algorithms for APIs and databases-offset, keyset, cursor-based-with performance optimization, scalability patterns, and real-world implementation examples.
Read → -
Post · February 08, 2023
PostgreSQL on AWS RDS: What Changes When Postgres Becomes a Managed Service
A practical guide to PostgreSQL on AWS RDS: parameter groups, extensions, Multi-AZ, replication, upgrades, and the pitfalls specific to managed Postgres.
Read → -
Post · January 20, 2023
PostgreSQL Fundamentals: A Practical Guide to How It Actually Works
A practical PostgreSQL fundamentals guide covering MVCC, indexing, transactions, and real-world pitfalls for professional developers.
Read → -
Post · December 30, 2019
Database Migrations in SQL: Fundamentals, Practices, and the Domain Language Every Team Needs
A practical guide to SQL database migrations: core concepts, versioning strategies, expand-contract patterns, and the shared vocabulary teams need to ship schema changes safely.
- #back-end development
- #database administration
- #expand-contract pattern
- #postgresql
- #schema versioning
-
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 →