What we’re about
We are a community that seeks to deepen their understanding of PostgreSQL, The World's Most Advanced Open Source Database.
We explore ways to extend Postgres, build applications atop it, interface it to other databases, and tune it for maximum value. Please join us and discuss your Postgres experiences, share the tips and tricks you've learned using it, and learn from your peers.
Our group has adopted the PostgreSQL Code of Conduct (https://www.postgresql.org/about/policies/coc/)
Upcoming events (2)
See all- Illinois Prairie PUG MeetupDRW, Chicago, IL
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 RSVP here.Hope to see you there!
Hettie Dombrovskaya
Illinois Prairie PostgreSQL User Group Organizer - Illinois Prairie PUG Meetup - zoom version!Link visible for attendees
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
