Anthony Trad
Jul 21, 2023

--

Thank you for reading. Deploying SQL is much harder than normal applications. At the end, you're coupling logic with your data so your changes would need to be backward compatible at all times.

It might be quicker but that's because it is lacking features that you don't do in a normal CI/CD environment. Live feature-flags, Blue/Green deployments etc...

Having a complete and robust CI/CD pipeline with those will save you a lot on the long run. You will encounter less incidents and problems comparing to solely relying on migrations and basic tests.

Those doesn't work at scale or in an Agile environment where you're expected to deploy multiple times a day.

--

--

Anthony Trad
Anthony Trad

Written by Anthony Trad

Senior Software Engineer focused on .NET and the Cloud. Reconsidering major principles and patterns, ideas are my own.

No responses yet