Kansas City Data Professionals: Unifying transactional and analytical data with Postgres

​Kansas City Data Professionals Presents
pg_lake: Unifying transactional and analytical data with Postgres
Speaker: Elizabeth Christensen from KC Postgres User Group

​This is a special event. KC Data Professionals and KC Postgres User Groups are joining forces!

​Event Overview
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:30 - 5:45 - Arrival & Open Networking

• ​​5:45 - 6:25 - Presentation

• ​​6:25 - 7:00 - Open Networking

​​Hosts

• ​Elizabeth Christensen - PGKC

• ​David Traynham - KCDP

• ​Melanie Traynham, MSN, RN - KCDP

• ​Matthew Copple - KCDP

• ​Julie Heckman - KCDP

• ​Britt Huffman - KCDP