Back To Schedule
Thursday, June 25 • 12:30pm - 12:50pm
Schema Updates and How to Make Them Zero Downtime

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
Your fantastic application is online and it started attracting users. Suddenly, you realise you need to change the schema of the data. How to do it properly for both the running system and possible future deployments? How to do it without crashing the running application?

If we imagine a database powering our application, each schema change comes in two forms: one is the actual ALTER TABLE, the other one is the updated CREATE TABLE that will be used in future deployments. Blindly applying the former might break the application for users that are using it at the moment of the change. If your application is more complex, it might have several components with their own schemas. How can we change the user without breaking the whole application? Perl will be used in the examples, but the findings are valid in general.

Slides: https://e-choroba.eu/20-updates

avatar for E. Choroba

E. Choroba

Senior SW Developer, GoodData
Perl enthusiast from Prague. Using Perl for both work and personal projects.

Thursday June 25, 2020 12:30pm - 12:50pm EDT
Zoom Channel 2