Illinois Prairie PUG Meetup - zoom version!

Dear Prairie PUG Members! This is a Zoom version of our September 10 meetup. You can find in-person event details here. A friendly reminder: if you want to attend in person, I need both your first and last name!

On September 10, Doğaç Eldenk will present the talk Start with a Clean Slate: Setting Up Integration Tests with PostgreSQL

Did you have fun at PG Day Chicago in April? I did! But do you know what I regret most? That I didn't have time to listen to all the talks I wanted to listen to! On September 10, we will have the opportunity to listen to one of the talks presented at PG Day Chicago (and the one I really wanted to listen to!)

Talk Description:

Efficiently managing a clean PostgreSQL database between integration tests is essential for ensuring accurate and reliable test outcomes. In this talk, we explore strategies to clean and reset a PostgreSQL database state between test runs without sacrificing performance. We will discuss the drawbacks of common approaches like in-code cleanups, truncating tables or dropping schemas. Finally, we will introduce a language-agnostic solution that uses PL/pgSQL functions, triggers, procedures and the information schema to automatically clean database tables between tests. By leveraging this solution, developers can achieve faster, more consistent integration tests, ultimately improving the reliability of their test suites and enhancing overall development productivity without needing major refactoring in their codebase.

About the speaker:

Doğaç has been working at Carbon Health since December 2020. This fall, he is starting the M.S. Computer Science program at Northwestern University.

Please RSVP here only if you are going to attend virtually.

For the in-person event, please RSVP here.

Hettie Dombrovskaya
Illinois Prairie PostgreSQL User Group Organizer