Prairie Postgres is returning to its regular meetup schedule with a two-talk format featuring Zach Paden and Anna Bailliekova. Zach Paden will present Declarative Schema Management with pgschema, a talk focused on simplifying database schema changes. Many application teams struggle with versioning database migrations and maintaining long migration histories. Zach will introduce pgschema, a tool that allows developers to write pure SQL declaratively while automatically deriving valid online migrations. Anna Bailliekova will present PostGIS Quick Start, a beginner-friendly introduction to PostgreSQL’s geospatial capabilities. Using transportation examples, Anna will walk through practical PostGIS features for anyone who has wanted to explore…

Prairie Postgres NFP is excited to announce an upcoming community meetup featuring Elizabeth Christensen from Snowflake. In this session, “pg_lake: Unifying transactional and analytical data with Postgres,” we’ll explore how PostgreSQL is evolving beyond traditional transactional workloads into a unified platform for analytics and modern data lake architectures. Elizabeth will introduce the newly released pg_lake extension series, which connects PostgreSQL to object storage and open table formats including Parquet and Iceberg. Through live demos and practical examples, attendees will see how to build streamlined data pipelines with little to no ETL while leveraging the power of open source technologies like…

The Illinois Prairie PostgreSQL User Group (PUG) is pleased to announce the Second Developers’ Summit, scheduled for April 14 during our regular meetup time. Following the success of last year’s event, this summit will bring together application developers, PostgreSQL DBAs, database architects, and database developers for an interactive discussion. The goal is to better understand the challenges of using PostgreSQL as an application backend and to collaboratively explore ways to improve this interaction. If you are a software engineer who use Postgres, and if you are frustrated with bloated tables, “autovacuum blocking your processes,” partitioned tables being slow, indexes not…