PostgreSQL Meetup

Dear Chicago PUG members,

My apologies for the delay! Here are the details for out March meeting:
It will take place on March 25 from 5-30 PM to 8 PM.

We will meet at our usual location: DRW Training Center, 540 W. Madison, 25th floor.

A reminder about our venue:

- This is a high-security building, which means the names of all participants should be communicated no later than 7:30 AM on the day of the event, and all participants must present a government-issued ID to be admitted. If your meetup profile does not list your full name, please send a DM with the required information to Hettie. Registration for all in-person events will be closed by 7-30 AM the day of the event.
- The food order will be placed a day before the event, so I strongly encourage everybody planning to attend to RSVP by March 23.
- If you plan to attend virtually, please RSVP here.

Please RSVP to this event only if you are attending in person.

Event Details:

Ryan Booz, Advocate from Redgate, will present his talk:

Intro to database migrations with Flyway

Talk Abstract:

Flyway is a popular open-source tool for managing schema migrations throughout your database and application lifecycle. While getting started with Flyway can be challenging—especially with an existing database and when managed migrations are a new concept—this talk will help you succeed.

In this meeting, I’ll introduce the free Flyway Desktop client, Database DevOps concepts, including using CI/CD pipelines for database deployments, and integrating Flyway into your development workflow. You'll learn about branching strategies, handling out-of-order migrations, using the community portal to track pipeline and database drift, and more.(Edited)
About the Speaker:

Ryan is an Advocate at Redgate focusing on PostgreSQL. Ryan has been working as a PostgreSQL advocate, developer, DBA and product manager for more than 20 years, primarily working with time-series data on PostgreSQL and the Microsoft Data Platform.

Ryan is a long-time DBA, starting with MySQL and Postgres in the late 90s. He spent more than 15 years working with SQL Server before returning to PostgreSQL full-time in 2018. He’s at the top of his game when he's learning something new about the data platform or teaching others about the technology he loves.

Agenda:

5:20 - Doors open, pizza arrives
6:00 - 6:15 - Hettie D: PG Day Chicago updates, Students Training Day and more
6:15 - 7:15 - Ryan Booz: Intro to database migrations with Flyway

7:15 - 8:10 - QA and networking

The last reminder: Please be on time! You might not be able to get in on the 25th floor after 6!

As usual, I hope to see as many of you as possible in person!

Hettie Dombrovskaya,
Chicago PUG Local Organizer