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 venu**e:

\- 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

Illinois Prairie PostgreSQL User Group

Henrietta Dombrovskaya

Jerry S

Paul Whalen

Mike E.

Carlos Aranibar

Ravi

Dogac Eldenk

Illinois Prairie PUG Meetup

Midwest PostgreSQL

Search {networkName}

Groups

{PRO_NETWORK_NAME} is on Meetup Pro with more than {PRO_MEMBER_COUNT} members across {PRO_GROUP_COUNT} Meetups worldwide. Meetup Pro is the professional tool for organizing and communicating a network of users, partners, contributors and members.

Prairie Postgres

Midwest PostgreSQL

Midwest PostgreSQL

Who we are

Search Midwest PostgreSQL

Upcoming events

Groups