PostgreSQL Meetup


Details
Dear Chicago PUG members! Our next meetup is scheduled for October 20 at 6 PM.
For this meetup, we have a remote speaker, and based on the members' responses, we decided to make it virtual. We will be back to the hybrid mode in November!
Our speaker will be Jonathan Katz from Crunchy Data. He will present a talk "Building a Complex, Real-Time Data Management Application"
Talk description:
Congratulations: you've been selected to build an application that will
manage whether or not the rooms for your PostgreSQL conference are being
occupied by a session!
On the surface, this sounds simple, but we will be managing the rooms of
a conference, so we know that a lot of people will be accessing the
system. Therefore, we need to ensure that the system can handle all of
the eager users that will be flooding the conference website checking to
see what availability each of the conference rooms has.
To do this, we will explore the following PostgreSQL features:
- Data types and their functionality, such as:
- Data/Time types
- Ranges
- Arrays
- GiST Indexes
- Common Table Expressions and Recursion
- Set generating functions and LATERAL queries
- Functions and the PL/PGSQL
- Triggers
- Logical decoding and streaming
We will be writing our application primary with SQL, though we will
sneak in a little bit of Python to demonstrate the power of logical
decoding. This will be an interactive sessions and we will provide some
containers to ensure you have everything you need to be up and running
when the bell rings.
At the end of the session, we will have a working application, and you
will be happy knowing that you provided a wonderful user experience for
all conference attendees made possible by the innovation of PostgreSQL!
Speakers Bio:
Jonathan S. Katz is the VP of Platform Engineering at Crunchy Data, with
a focus on managing PGO, an open source Postgres Operator.
Jonathan is a member of the PostgreSQL Core Team and involved in various
governance aspects of the PostgreSQL Global Development Group. He serves
as a Secretary and Director of the nonprofit PostgreSQL Community
Association of Canada and is a Director of the nonprofit United States
PostgreSQL Association.
Jonathan enjoys building applications with PostgreSQL and revels in
showing off all of the wonderful features of PostgreSQL. Prior to
Crunchy Data, Jonathan was CTO at VenueBook, and before that, VP of
Technology at Paperless Post. At both companies Jonathan developed
robust platforms using PostgreSQL, taking advantage of its many
features, from complex data types to its ability to stream logical
changes. Jonathan graduated from Tufts University with a B.S. in
Computer Science and a B.A. in Mathematics.

Sponsors
PostgreSQL Meetup