PostgreSQL

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, 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, Snowflake *Talk 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 closing *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 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 Organizer

Customer identity resolution becomes increasingly complex as organizations scale across multiple systems, regions, and data formats. Traditional rule-based approaches often fail to keep up with data variability, require constant manual tuning, and struggle with real-time processing needs. This session presents a practical approach to building a scalable identity resolution pipeline using AWS services and modern AI techniques. The architecture combines data ingestion through Amazon S3 and AWS Glue, transformation pipelines using Spark on EMR, and machine learning models deployed via SageMaker for entity matching and standardization. Graph-based relationship modeling is implemented using Amazon Neptune to improve resolution accuracy by incorporating household and shared attribute context. We will walk through how machine learning models can be used for name and address normalization, how intelligent blocking strategies improve matching efficiency, and how feedback loops can be introduced to continuously improve accuracy. The session also highlights how serverless components such as AWS Lambda can be used for orchestration and real-time processing. **SPEAKER BIO** Mosaic Syed is a Senior Data Engineering and Cloud Solutions Architect with over 20 years of experience designing and delivering scalable, secure, and high-performance data solutions across global enterprise environments. https://www.linkedin.com/in/mosaic-basha-syed-92300856 **CALL FOR SPEAKERS** Learn more: [https://www.awscolumbus.com/get-involved/](https://www.awscolumbus.com/get-involved/) **THANK YOU** *VEEAM* for hosting our meetup! To learn more about *Veeam*, please visit their website: [https://www.veeam.com/](https://www.veeam.com/) **DIRECTIONS** 8800 Lyra Dr #450 · Columbus, OH go to 4th floor. **Want to sponsor the pizza and/or bar tab?** Please contact me if you would like to sponsor this meetup's pizza and/or bar tab: angelo@mandato.com

Jimmy V's Grill & Pub in Grandview Heights. You are responsible for your own meal/drinks. We usually don't have any agenda other than eat, drink and talk. :) If the weather is nice we will be on the back patio, otherwise we are in the cigar room. This group has been meeting every Tuesday evening for over a decade. Many attendees do not RSVP on meetup. Please don't let the small number here discourage you. Anyone/everyone is welcome to come. We'd love to have you join us. COTA bus #5 comes to W. 5th and Wyandotte Rd. And it's a minute walk to the restaurant. *** Did you know that there are atheists everywhere?!?! You may not know it, but we are! We're in your schools, diners, police force, military, government, and some are even still in your churches! So come and join us and meet other local atheists, along with agnostics, heathens, humanists, skeptics, and anyone else who's 'hell bound'! Vision: a Central Ohio that accepts atheism as a viable alternative in all areas of public and private life. Mission: grow, support, and provide community for atheists in Central Ohio. Social meetings held most Tuesdays at a local pub/restaurant at 7:00 PM (and often into the wee hours). Attendees call themselves agnostics, skeptics, humanists, non-theists, deists or even theists. All attendees are welcome but should support our vision. Atheists of Columbus (AoC) is part of Omnipresent Atheists (OA). AoC members are invited to join this OA meetup and/or OA Facebook group ( https://www.facebook.com/groups/omnipresentatheists/ ) but are free to continue conversations on the AoC Facebook group ( https://www.facebook.com/groups/columbusatheists/ ). AoC was founded in 2012 as a networking, social group for Central Ohio area humanists, skeptics, atheists, agnostics, nonbelievers, freethinkers, and the curious. It was a member of Columbus CoR and held weekly meetings, mostly on Fridays, for several years but then operated as an online only group for some time. In November 2018, Omnipresent Atheists (OA), a group that routinely meets on Tuesdays, invited AoC to merge. Omnipresent Atheists is a member of the Columbus Coalition of Reason (ColumbusCoR.org). Omnipresent Atheists is a member of the Columbus Coalition of Reason ( http://www.ColumbusCoR.org ). Omnipresent Atheists endorses the mission of the Secular Coalition for America ( http://secular.org ).

Practical AI for Power BI Developers A year ago, “agentic AI” was mostly hype for Power BI teams. Today, it deserves your undivided attention. For Power BI pros, there is now a real opportunity to reduce repetitive development work, accelerate delivery, and help developers do more, but only when strong DataOps practices are in place to make AI workflows effective. This session is a no-nonsense introduction to effective AI patterns for Power BI and Fabric development. Along the way, we will make sense of the growing pile of terminology, including skills, plugins, hooks, and MCP. You will see examples of how modern AI tooling can help with development tasks across Power BI and Fabric, along with the prerequisites, guardrails, and DataOps principles needed to use it responsibly. Whether you're burned out on AI hype or already using Copilot CLI daily, this session will show you the foundations that are finally making AI-assisted development genuinely useful.

Jimmy V's Grill & Pub in Grandview Heights. You are responsible for your own meal/drinks. We usually don't have any agenda other than eat, drink and talk. :) If the weather is nice we will be on the back patio, otherwise we are in the cigar room. This group has been meeting every Tuesday evening for over a decade. Many attendees do not RSVP on meetup. Please don't let the small number here discourage you. Anyone/everyone is welcome to come. We'd love to have you join us. COTA bus #5 comes to W. 5th and Wyandotte Rd. And it's a minute walk to the restaurant. Did you know that there are atheists everywhere?!?! You may not know it, but we are! We're in your schools, diners, police force, military, government, and some are even still in your churches! So come and join us and meet other local atheists, along with agnostics, heathens, humanists, skeptics, and anyone else who's 'hell bound'! Vision: a Central Ohio that accepts atheism as a viable alternative in all areas of public and private life. Mission: grow, support, and provide community for atheists in Central Ohio. Social meetings held most Tuesdays at a local pub/restaurant at 7:00 PM (and often into the wee hours). Attendees call themselves agnostics, skeptics, humanists, non-theists, deists or even theists. All attendees are welcome but should support our vision. Atheists of Columbus (AoC) is part of Omnipresent Atheists (OA). AoC members are invited to join this OA meetup and/or OA Facebook group ( https://www.facebook.com/groups/omnipresentatheists/ ) but are free to continue conversations on the AoC Facebook group ( https://www.facebook.com/groups/columbusatheists/ ). AoC was founded in 2012 as a networking, social group for Central Ohio area humanists, skeptics, atheists, agnostics, nonbelievers, freethinkers, and the curious. It was a member of Columbus CoR and held weekly meetings, mostly on Fridays, for several years but then operated as an online only group for some time. In November 2018, Omnipresent Atheists (OA), a group that routinely meets on Tuesdays, invited AoC to merge. Omnipresent Atheists is a member of the Columbus Coalition of Reason (ColumbusCoR.org). Omnipresent Atheists is a member of the Columbus Coalition of Reason ( http://www.ColumbusCoR.org ). Omnipresent Atheists endorses the mission of the Secular Coalition for America ( http://secular.org ). This group has been meeting every Tuesday evening for over a decade. Many attendees do not RSVP on meetup. Please don't let the small number here discourage you. Anyone/everyone is welcome to come. We'd love to have you join us.

**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 John Lairson will share a notebook describing the Alpaca (Paper) Trading API and discuss different algorithms for evaluating stock trades. 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