Illinois Prairie PUG Meetup

Dear Illinois Prairie PUG members,

Our next meetup will take place 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.

Event 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 me (Hettie). Please make sure to do so not later than the day before the meetup. 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 at least a day before.

Please RSVP to this event only if you are attending in person.
If you are planning to attend virtually, please wait for a separate event announcement.

Hope to see you there!

Hettie Dombrovskaya
Illinois Prairie PostgreSQL User Group Organizer