Jonathan Katz is a Principal Product Manager Technical at AWS for Amazon RDS. Prior to this, he was the VP of Platform Engineering at Crunchy Data, focused 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 Mathematics.

Presentations

21x

Vectors are the new JSON

Vectors are a well-studied mathematical concept, yet pose challenges around efficient storage and retrieval in database systems. The increased ease-of-use of AI/ML has lead to a surge of storing vector data alongside application data, leading to some unique challenges. PostgreSQL has seen this story before with JSON, when JSON became the lingua franca of the web.

In this session, we'll review what vectors are, how they are used, and what users are looking for in vector storage and search systems and best practices for searching vector data in PostgreSQL with pgvector.

See Presentation
21x

PostgreSQL Ask Me Anything

Ask anything about the PostgreSQL Community. Technical, social or otherwise! A number of folks involved in the PostgreSQL community regularly attend SCaLE and make themselves available for questions.

See Presentation
20x

PostgreSQL Ask Me Anything

Ask anything about the PostgreSQL Community. A number of folks involved in the PostgreSQL community regularly attend SCaLE and make themselves available for questions.

See Presentation
19x

Get Your Insecure PostgreSQL Passwords to SCRAM!

Passwords: they just seem to work. You connect to your PostgreSQL database and you are prompted for your password. But what if I told you there was a better way to authenticate with passwords in PostgreSQL?

Let's learn how SCRAM (Salted Challenge Response Authentication Mechanism) in PostgreSQL securely authenticates passwords. At the end of this talk, you will understand how SCRAM works, how to ensure your PostgreSQL drivers supports it, how to upgrade your passwords to using SCRAM-SHA-256, and why you want to tell other PostgreSQL password mechanisms to SCRAM!

See Presentation
19x

PostgreSQL Ask Me Anything

A panel of PostgreSQL community members is here to answer any questions about any aspect of the project.

See Presentation
18x

Get Your Insecure PostgreSQL Passwords to SCRAM!

Passwords: they just work. You connect to your PostgreSQL database, type in the correct characters, and presto! you're in, safe and sound.But what if I told you that all was not as it seemed, and there was a better way to authenticate with passwords in PostgreSQL? In this talk, we will look at the history of password storage and authentication in PostgreSQL, How SCRAM works with a step-by-step deep dive into the algorithm, How to safely set and modify your passwords, and how to upgrade to SCRAM-SHA-256and more!

See Presentation
17x

Operating PostgreSQL with Kubernetes at Scale

The maturation of containerization platforms has changed how applications are developed and deployed. These technologies have made its way into the PostgreSQL ecosystem, with platforms like Kubernetes enable teams to run their own "database-as-a-service!" In this talk, you will learn how to get PostgreSQL up and running in a containerized environment with advanced sidecars in only a few steps! You will also see how it extends to large production environments with Kubernetes, and the future of PostgreSQL in a containerized world.

See Presentation