KSQL

Our monthly PHP meetup. A virtual shindig courtesy of Zoom. Check back here for the details around 6:15 pm

Dear Illinois Prairie PUG members, Thank you to everyone who attended PG DATA 2026! The conference is over, but our meetups are back, and more Postgres content is coming! Those of you who attended our May meetup are already familiar with our new (hopefully permanent) location. For others, please note that we will meet at **Chicago Innovations, 1 W. Monroe**. This time, we are trying a two-talk format. \- Zach Paden will present the talk **Declarative schema management with pgschema.** \- Anna Bailliekove will present the talk **PostGIS Quick Start** More details on talks and speakers coming soon! *Agenda* 5:20 - doors open 5:30 - pizza arrives 6:00 - 6:10 - Hettie D. Opening remarks 6:10- 6:40 - Zach. Declarative schema management with pgschema. 6:45 - 7:10 Anna: PostGIS Quick Start 7:10 - 7:50 - Open discussion and networking 7:50 - 8:00 - Cleanup time and closing **Speaker**: Zach Paden Zach Paden is a tech lead at Symetra with experience ranging from scrappy startups, consulting, to large regulated enterprises. His work spans data platform, analytics and application development where he’s seen more than his fair share of projects get bogged down or catch on fire due to their schema management practices. **Talk Title:** *Declarative schema management with pgschema* **Talk description** Lots of app devs struggle to understand the concept of versioning database migrations, and managing the history of these migrations can become difficult even with existing tools. Using pgschema you can write pure-sql decoratively and let pgschema derive a series of valid online migrations. **Speaker:** Anna Bailliekova Anna Bailliekova has been moving data around professionally for 15 years. Currently a staff engineer XeoMatrix, she focuses on helping organizations mature their data engineering practice, optimization problems, and geospatial data applications. **Talk title:** PostGIS Quick Start **Talk description** PostgreSQL provides rich support for geospatial computing; using transportation examples, we will take a brief tour of these features for those who want to but have been scared to try. *Notes 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](https://www.postgresql.org/about/policies/coc/). \- We do not want to waste food\, so please indicate your dietary preferences\. \- We will not close RSVPs on the morning of the meetup\, but please do your best to RSVP in advance so we can order the appropriate amount of food and drinks\. \- We want to start offering **on-site daycare**. If you indicate on your RSVP that you are planning to use daycare, we will contact you closer to the event with more information. This meetup 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 Organizer

WQC has weekly Thursday night social nights at the Westerville Java Central. Come and grab a coffee and connect with the community: low stakes, chill environment, and tasty drinks. No registration is required; come as you are.

**Improving Office in Franklinton** Physical location: Improving Office 330 Rush Alley Suite #150 Columbus, OH 43215 Schedule: 6:00 p.m.: Socialize, eat, and drink. Improving will be providing pizza and beverages. 6:30 to 8:00 pm. Main meeting and presentation(s). Topic: This month Chris Pazsint will be talking about Agentic Coding. How does one use CLI Based Agents, and Agentic IDEs such as Cursor, Kiro, Antigravity? How to include agentic coding plugins for IDEs you already love such as Visual Studio Code. We meet on the last Monday of each Month. Presentations are given by members and friends of this group. If you would like to do a presentation (small or large) on a python topic, please contact Central OH Python at centralohpython@gmail.com

Join us as we get together to get together to help those in need at this CMG Gives Back event! We have a great little community of Movie Group friends so rather than see a movie this time, we’ll help “Create a better world” by helping serve those in need. NOTE: We’re switching it up this time and going with a DINNER shift on Mon, 7/6. Here are complete details and our plan for this event: FAITH MISSION – GRANT KITCHEN: The Faith Mission kitchen and dining room serves residents 3 meals a day, every day of the year. For this event, our group will help prepare food, serve meals, assist residents in the dining room, wash dishes, and clean surfaces. PLAN: We will be preparing / serving / cleaning for DINNER from 4:30 to 6:30pm and have space for a total of 7 volunteers. Please arrive at 4:20pm and wear closed-toe shoes and long pants. LOCATION: Faith Mission – Grant Kitchen is located at 245 N. Grant Ave. Enter the kitchen at Dock 1 (in the back of the building), indicated in the attached map. On-site parking in the adjacent lot and street parking are available in the surrounding area. Below are some links / attachments with additional info/details: IMPORTANT REMINDER: Our group will be providing all of the volunteers on this day so a firm RSVP count is essential. Please only sign up if you are certain you’ll be able to attend. If something unavoidable comes up, please try to update your RSVP no later than one week prior to the event. With few exceptions, no shows or cancelations within 1 week of the event will not be eligible for future CMG Gives Back events. I appreciate your understanding as we try to ensure the agencies have the volunteers needed to provide the essential services they provide to the vulnerable population they serve. Our Partner Agency for this event is Lutheran Social Services! A huge THANK YOU to those volunteering at this (or any of our previous or future) CMG Gives Back events! Look forward to seeing you there, Dan