PostgreSQL May Meetup

We will be hosting our May Meetup.

Thanks to Amazon for sponsoring us. Please note that you have to show sign up with your real name and show a Photo ID to the building security before entering the building. Every visitor will have their photo taken that will be printed on their paper visitor badge. This is a requirement from the building security. If you are not ok with that, please do not sign up. You can not bring a +1, everyone needs to sign up.
Please only sign up if you plan to come, we will keep notes.

Excited to announce our talks:

pg_lake: Unifying transactional and analytical data with Postgres
by Celeste Horgan, Sr. OSS Developer Advocate at Snowflake.

The common wisdom goes: data is either transactional or analytical, and workloads are OLTP and OLAP-shaped to match. The reality of generating and using data is different, and often we need a bit of both. The pg_lake extension brings OLAP workloads to OLTP Postgres.

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.

I Didn't Know Postgres Could Do That!
by Robert Treat, Principal Database Engineer at AWS and PostgreSQL Major Contributor.

PostgreSQL is often thought of as "The Database for DBAs", but what more and more developers are finding out is that what makes Postgres "The Worlds Most Advanced Open Source Database" is its wide array of features, many of which are really geared towards engineers building applications on top of Postgres. In this talk, we'll look at some of the features in Postgres you may not have seen in other database systems, and talk about how you can make use of those features in your applications. Queries, indexing, data types, and more will all be up for discussion as we show you examples of just what Postgres can do.