About us
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
The Mythical Data Warehouse: The World Is Hybrid
·HybridChicago Innovations, 1 W. Monroe, Chicago, IL, USDear Illinois Prairie PUG members,
Our next meetup will take place in a new location. Please read the whole announcement carefully to note all the changes.
Our new meeting place is Chicago Innovations at 1 W. Monroe.
Talk Title: pg_lake: Unifying transactional and analytical data with Postgres
Speaker: Elizabeth Christensen, SnowflakeTalk Description
The data world used to be defined by “transactional" (OLTP) and “analytical” (OLAP) workloads, but we’ve asked ourselves, “Why not both?” A new series of extensions called pg_lake has just been released to connect Postgres to object storage and open table formats - like csv, Parquet, and Iceberg. pg_lake bridges the two worlds of transactional and analytical data for a vendor neutral, open source, unified data stack.
This talk will explore the pg_lake extension, including how to build it, and demos of using it with modern data workloads in object storage like Amazon S3. We’ll create simple data pipelines with no ETL and high performance analytics.
pg_lake is more than just an extension. It is the foundation to a fully unified data path with 100% open source tools backed by PostgreSQL, DuckDB, Iceberg, and Polaris.
Agenda
5:20 - doors open
5:30 - pizza arrives
6:00 - 6:10 - Hettie D. Opening remarks
6:10- 6:20 - Hettie D. Data warehouse history overview
6:20 - 6:50 Elizabeth C. pg_lake: Unifying transactional and analytical data with Postgres
6:50 - 7:00 Q&A
7:00 - 7:50 - Open discussion and networking
7:50 - 8:00 - Cleanup time and closingNotes about our new venue.
I am delighted to have an independent venue for the first time since I am hosting the meetups. I hope that this will be our permanent home. And as you all know, with more freedom comes more responsibilities.
You will notice the change in the RSVP form.
We are thankful to our hosts and promise to be responsible.
We comply with the PostgreSQL Code of Conduct.
We do not want to waste food, so please indicate your dietary preferences.
We will not close the RSVP in the morning of the meetup, but please do your best to RSVP in advance so that we can order the appropriate amount of food and drinks.Also, all meetups will be hybrid - please don't forget to indicate whether you are attending in-person or virtually.
Thank you, and I look forward to seeing you all at our new location!
Hettie Dombrovskaya
Illinois Prarier PUG Organizer28 attendees
PG DATA 2026
Loyola University Water Tower Campus, 111 East Pearson Street, Chicago, IL, USHello Everyone, that's a reminder that Prairie Postres is hosting the PG DATA 2026 conference on June 4-5 at Loyola Watertower Campus.
PG DATA 2026 brings two days of PostgreSQL programming to the Midwest DBA and software developer communities. We aim to offer an accessible and affordable in-person event where attendees can connect with peers, get hands-on training from industry-leading experts, and learn about everything Postgres, from deep dives into database internals to case studies, analyses of the latest features, and more.
Check out our schedule here: https://2026.pg-data.org/schedule/Please note that RSVP at the meetup page does not provide you with a conference ticket.
To register for the conference, follow that link: https://www.eventzilla.net/e/pg-data-2026-2138653735
Full price for this two-day event, including complimentary half-day training of your choice, is $50; $20 for full-time students.You can use CHIMAY15 discount code to get 15% off if you register before May 15.
To volunteer,Apply for DEI-focused Midwest grant here:
https://forms.gle/2yLHN8i8jvuC6N558
2 attendees
Past events
20
