Sep 13, 2024
Amsterdam, Netherlands
In-Person
We are excited to share that EDB will be a Partner sponsor at the PGDay Lowlands 2024, happening in Amsterdam on September 13th. PGDay Lowlands is a premier annual event dedicated to PostgreSQL, bringing together enthusiasts and professionals from the database community. The conference spans two days and features a variety of technical sessions, workshops, and networking opportunities. Attendees include PostgreSQL users, developers, IT professionals, and decision-makers, all eager to learn about the latest advancements, best practices, and innovations in PostgreSQL and open-source databases.
EDB is proud to have two of our Postgres experts giving talks at PGDay Lowlands this year. Here is a preview of what Practice Leader Lætitia Avrot and VP, Chief Engineer Peter Eisentraut will be sharing at this year's event:
The Sad Truth - Why Postgres Makes You Miserable - Lætitia AVROT
We all know Postgres is the coolest open source database out there. It's wicked smart, powerful, and has more features than a Swiss Army katana. But if we're being fully honest with ourselves, working with Postgres can sometimes feel like torture in the cruelest of circles in Dante's Inferno.
This talk will rip off the rose-colored glasses and expose all the nightmarish aspects of Postgres that make you question your career choices. The unhelping error messages that make you feel like bad Janet took over Postgres? We're airing those dirty laundry. The 50-line queries needed to accomplish simple tasks? Oh we're going there. You'll wince as we relive trauma from dealing with the vacuum catastrophes, replication lag from hell, and lock timeouts that seem to plague even the grandest of installations. And we'll explore the masochism required to wrangle this beast across major upgrades.
The goal here isn't to bash Postgres into oblivion, but to build acceptance around its flaws and share cognitive coping strategies. Because while Postgres may hurt you, it also loves you - in its own way. You'll laugh, you'll cry, you'll walk away with zero illusions but unable to quit this relationship.
Column encryption solutions and ideas - Peter Eisentraut
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.