List of videos

PostgreSQL is the most popular open-source database among developers. It is one of the Top 5 databases in the world, and it is fully open source and community driven. But, PostgreSQL, the “Emperor” of databases, has no clothes! For all intents and purposes, Slonik is “walking around naked” because there is no open source TDE solution to keep the elephant clothed. Transparent Data Encryption is the way that data at rest protection can be done on the database level, ensuring the data is encrypted on the disk as well as in your backups and no application changes are required. While TDE is not available in PostgreSQL we created an extension that addresses (clothes the elephant) this issue and strengthens the security of your database. Join us as we tell the story of The Elephant Has No Clothes and how Percona is solving this issue. We will go over data that span the development of the extension, the added security benefits to your database, and point to what the future holds for TDE.

[Sponsor Track] Di Qi & Umur Cubukcu - Modern PostgreSQL for AI... applications with LLM integrations and powerful search In this session, we will talk about extending PostgreSQL to support modern AI workloads. PostgreSQL extensions are a powerful part of the Postgres ecosystem. Some are relatively straightforward to run, while others bring broad sets of new functionality and enable new workloads, allowing Postgres to compete with specialized databases. Lantern.dev offers a unique way to accomplish this for AI workloads, including scalable indexing and LLM integrations with Postgres. Along the way, we will also introduce a new way of consuming PostgreSQL extensions in the cloud. Informed from our time building and running Citus first as a separate database, and later as a PostgreSQL extension and a cloud service, we will talk about ways to combine workload-specific expertise of AI applications, with the operational management of Postgres. If you're interested in AI applications with PostgreSQL in particular, or running workload-specific PostgreSQL extensions in general, this session is for you.

Many users are looking for data encryption solutions, for security and compliance reasons. In many cases, targeted solutions for column-level encryption can be appropriate and in some cases offer even better security and compliance than full-disk encryption or TDE. In this talk I will introduce solutions for column-level encryption, including application-side solutions and solutions using plugins like pgcrypto and pgsodium. I'll also cover some cryptographic details and typical security and regulatory requirements for encryption in databases and how different encryption solutions can address them. And at the end we can think about what core PostgreSQL could offer for this in the future.

[Sponsor Keynote] Peter Eisentraut - Postgres Over the Horizon: Anchor Points for the Future We Should Be Building Now (PGConf.EU 2024) Predicting the future often requires a look into the past. In this keynote, we will revisit the 2013 PGConf.EU keynote, “PostgreSQL in 5 years - Expectations from the marketplace,” to see how far we’ve come and use those insights to project what the future holds for Postgres. As we look ahead to the next five and ten years, the focus will shift beyond transactional capabilities to encompass expanded roles for AI and advanced analytics workloads. The future of Postgres lies in its ability to meet the engineering demands of an AI-driven world. Join us as we outline the key anchor points that will shape the future of Postgres, helping developers and enterprises alike build resilient systems designed for tomorrow’s data landscape.

In PostgreSQL, one of the key components is its query executor which is really in charge of running your query. This presentation will deep dive into this vital component of PostgreSQL and shed some light on the inner workings of the very heart of PostgreSQL. Let us understand how PostgreSQL really runs a query, how data is processed and which key internal algorithms and data structures are at work to make PostgreSQL tick. How does PostgreSQL handle expressions? What is an executor state and how does PostgreSQL actually execute an execution plan created by the optimizer? Where does parallelism kick in?

To meet the current demands for responsiveness and scalability in web applications and APIs, we will explore how to build a modern architecture for message handling using API Platform, Symfony Messenger and Mercure. Our goal is to establish a robust workflow that enables message processing and real time user notifications. We will demonstrate how to orchestrate these technologies to deliver a seamless and immediate user experience, while ensuring high availability and optimal performance. This talk will give you a good foundation to address some of today’s performance and responsiveness requirements. ______ More info: https://api-platform.com/con/2024/ X: https://x.com/ApiPlatform Music credits: Welcome to the Jungle, Alex MakeMusic

API Platform comes with a powerful admin generator, now based on react-admin v5. Building admin or B2B UIs for your API has never been easier, thanks to guessers, TypeScript validation, and a very large library of widgets. It’s as if HTML had been extended with new components for filters, menus, user preferences, etc. Even if you’re allergic to JS, API Platform Admin will dramatically boost your productivity. ______ More info: https://api-platform.com/con/2024/ X: https://twitter.com/ApiPlatform Music credits: Welcome to the Jungle, Alex MakeMusic

Serialization plays an essential role in any web application, particularly in the context of APIs, as it is one of the pivots of the HTTP request/response cycle. Needs are evolving, and since its creation, the Serializer has confronted new issues. Its ability to handle large volumes of data while remaining efficient and flexible has become critical. And because API Platform relies a lot on that component, Serializer’s limits are kind of API Platform’s. But new tools have appeared over the years, each enabling an independent improvement of a part of the Serializer component. What are these tools? And how can they be orchestrated and integrated to API Platform to make it amazingly fast? That’s what we’ll be talking about at this conference. _______ More info: https://api-platform.com/con/2024/ X: https://x.com/ApiPlatform Music credits: Welcome to the Jungle, Alex MakeMusic

Once upon a time, developers were the unsung heroes of our world. The stereotypical developer, with glasses perched on the nose and an innate talent for science, even inspired the alter egos of superheroes. However, today, software engineers often find themselves under scrutiny for their roles in creating data-gathering apps, facial recognition software in CCTV systems, and the constant tracking of citizens through GPS, among other issues. From being heroes to becoming modern-day Dr. Frankensteins, tech creators face an unenviable dilemma: to embrace malevolence or strive for heroism. During this talk, we will delve deep into the complex relationship between technology and ethics, and explore how developers navigate the fine line between progress and principles. This is our villain’s origin story, told with a touch of dark humor. _______ More info: https://api-platform.com/con/2024/ X: https://x.com/ApiPlatform Music credits: Welcome to the Jungle, Alex MakeMusic