This month’s invitation is from Mala Mahadevan (b) asking us how we manage the database code. Since this is my passion project, I have a few basic tips to share.
I have yet to see a perfect implementation but even a partial one benefits you. My experience is mostly with enterprise-scaled environments – large servers, minimal downtime, brownfield development and also mostly single-tenant.
But these concepts and building blocks should be generic enough.
Read on for Tom’s thoughts, as well as some pros and cons of the state-based versus migration-based approaches for database changes.