#131 - Data Essentials in Software Architecture - Pramod Sadalage

<p><em>“The notion of transaction, consistency, and ACID compliance are many times tech imposed. It should be the business that makes the decision. We as technologists should not make that decision.&quot;</em></p> <p>Pramod Sadalage is a Director at ThoughtWorks and the co-author of the Jolt Award winning “Refactoring Databases”. In this episode, we discussed data essentials in software architecture. Pramod started by explaining why dealing with data is hard in software architecture and some data related concerns we should think about when making architecture decisions. He then shared the thought process of how we can choose the right database for our purpose and shared insights on data modeling differences between SQL and NoSQL. Pramod also touched on the important considerations in managing transactions and the trade-offs between ACID and eventual consistency. Towards the end, Pramod shared practical advice on the step-by-step how we can split a monolithic database through database refactoring.  </p> <p>Listen out for:</p> <ul> <li>Career Journey - [00:04:23]</li> <li>Data is Hard - [00:15:57]</li> <li>Data Related Architecture Concerns - [00:18:36]</li> <li>Choosing the Right Database - [00:24:19]</li> <li>Data Modeling in SQL vs NoSQL - [00:30:28]</li> <li>Managing Transactions - [00:37:31]</li> <li>Tradeoff Between ACID &amp; Eventual Consistency - [00:44:06]</li> <li>Refactoring Database - [00:46:58]</li> <li>3 Tech Lead Wisdom - [00:54:58]</li> </ul> <p>_____</p> <p><em>Pramod Sadalage’s Bio</em><br>Pramod Sadalage is Director at ThoughtWorks where he enjoys the rare role of bridging the divide between database professionals and application developers. In the early 00’s he developed techniques to allow relational databases to be designed in an evolutionary manner based on version-controlled schema migrations. He is co-author of Software Architecture: The Hard Parts: Modern Trade-Off Analyses for Distributed Architectures, co-author for Building Evolutionary Architectures - Automated Softwar