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
1
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 Organizer6 attendees
Past events
20
