Technology
ACID Properties: Are They Absolutely Essential for Every Project?
I examine the role of ACID in database transactions, when it can be compromised, and in which situations it is critical, based on my own experiences.
#PostgreSQL
6 posts found.
Technology
Multi-Tenant Architecture in ERP Systems: The Anatomy of Sharing
My experiences and strategic decisions while designing a multi-tenant architecture for a manufacturing ERP. Sharing models, data isolation, and performance…
Technology
PostgreSQL MVCC: Common Mistakes in Application Development
Understanding PostgreSQL's MVCC mechanism is critical for performance and data consistency. Common mistakes and their solutions when developing applications...
Technology
Distributed Lock Alternatives: My Pragmatic System Design Experiences
Lock management in distributed systems is critical for data consistency. Exploring different alternatives like Redis, PostgreSQL, and database locks, and.
Life
Product Tree Denormalization and the Anatomy of Technical Debt
I share my experience with product tree issues in a manufacturing ERP, the reasons for denormalization, and how technical debt accumulates.
Tutorials
The Hidden Trap of Legacy PostgreSQL Replication: Why You Need to…
Learn the potential pitfalls of setting up replication on older PostgreSQL versions, and how to avoid them. Stay safe and stable…