Version Controlling Your Database

This is a past event

79 people went

Location image of event venue

Details

Version Controlling your Database

In today's world of microservices, automation around every facet of the service infrastructure is an absolute necessity to be able to sustain a fast-paced IT environment. This is especially true for the service database. While NoSQL databases have gained quite a lot of popularity because of the perceived ease in development and operational complexity, relational databases continue to still play an important role - especially in environments where there is already a lot of investment made in that area. Historically, development team-centric automation around the relational database has been viewed skeptically, given the sensitive nature of the data and the volumes involved.

This talk will focus on how the process refactoring the database can be operationalized in a manner that is safe, automated and integrated into a continuous delivery pipeline - using tools like liquibase, flyway etc. During the talk we will live code database migrations and apply it to a local database and examine how the same process can be applied to remote databases as well. We will look at how to make schema changes and also how to maintain datasets for reference and test purposes. Finally, we will round off by looking at practices that work well vs. ones that don't.

Speaker Bio
Prem Chandrasekaran is a passionate technologist with over two decades of progressive software industry experience. He serves as Distinguished Engineer and Group Lead for platform services at Barclays Bank. Previously, he worked as Principal Consultant at ThoughtWorks Inc. He is passionate about the application of iterative software methods to deliver high quality software solutions. He is also a regular attendee of PhillyJUG events and a repeat presenter. In his free time he likes playing and discussing the nuances of the game of cricket.

Sponsorship
The Judge Group are kindly hosting and sponsoring the food for this event. We thank them for their continued support of the PhillyJUG.