Build a Complex, Realtime Data Management App with Postgres 14! - Jonathan Katz


Details
Join us virtually on November 10, 2021 as Jonathan S. Katz presents, "Build a Complex, Realtime Data Management App with Postgres 14!"
Congratulations: you've been selected to build an application that will manage reservations for rooms!
On the surface, this sounds simple, but you are building a system for managing a high traffic reservation web page, 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 website checking to see what availability each room has.
Fortunately, PostgreSQL is prepared for this! And even better, we will be using Postgres 14 to make the problem even easier!
We will explore the following PostgreSQL features:
- Data types and their functionality, such as:
- Data/Time types
- Ranges / Multirnages
Indexes such as: - GiST
- Common Table Expressions and Recursion (though multiranges will make things easier!)
- 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 and using Kafka to demonstrate the power of logical decoding.
At the end of the presentation, we will have a working application, and you will be happy knowing that you provided a wonderful user experience for all users made possible by the innovation of PostgreSQL!
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.
Schedule:
12:00 PM Announcements, speaker introduction, presentation, Q&A.
1:15 PM Closing announcements, wrap up.
1:30 PM Event ends.
We'll be using GoToMeeting. Download the desktop or mobile app for GoToMeeting:
https://global.gotomeeting.com/install/375084917
You can also use GTM directly in Chrome. It will work in other browsers, but with limited features.
And yes, you can customize your background!
https://global.gotomeeting.com/#/settings/custom-background
We will open the meeting room around 11:55 AM. If you try to log in prior to this time, the system will give you a message that the room is not available, and to try logging in later.
You can join the meeting from your computer, tablet or smartphone, or dial in by phone.
If you've RSVPed, you should see the connection link.
The detailed instructions and dial-in numbers were sent by email on November 9, 2021. If you need that information re-sent, please send us a DM.

Build a Complex, Realtime Data Management App with Postgres 14! - Jonathan Katz