What we're about

Meet others in your local area interested in PostgreSQL: The World's Most Advanced Open Source Database. Discuss this open source database and share the tips and tricks you've learned using it.

We have regular meetups throughout the greater Bay Area, including San Francisco, the East Bay, and Silicon Valley.

Upcoming events (1)

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

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.

12:00 PM Announcements, speaker introduction, presentation, Q&A.
1:15 PM Closing announcements, wrap up.
1:30 PM Event ends.

Link for the GoToMeeting room will be posted and sent by the evening before the event.

Past events (173)

PostgreSQL 14: What's New! with Christophe Pettus

Online event

Photos (38)

Find us also at

Related topics