Talk
PostgreSQL is more than just a database - it’s a programmable platform. With PL/Python, you can execute Python code directly inside the database engine, opening the door to powerful patterns that blur the line between application and data layer.
In this talk, we’ll explore what happens when that power is pushed to its limits. Through live examples and real-world-inspired scenarios, we’ll look at “wrong,” surprising, and sometimes borderline “illegal” uses of PL/Python: performing complex data transformations in-database, reaching outside the database to interact with the system, and embedding logic that traditionally belongs in application code.
But this isn’t just about shock value. We’ll break down what’s actually happening under the hood, discuss performance and security implications, and examine why some of these patterns are discouraged-or even dangerous - in production systems. You’ll learn where PL/Python shines, where it becomes a liability, and how to make informed decisions about using it.
About the Speaker
I am a full stack software engineer at VXSoft with over 16 years of professional experience, mostly working with Python. Over the years, I’ve built everything from backend systems to data-heavy applications-and occasionally found myself exploring ideas that probably shouldn’t work, but somehow do.
I enjoy digging into the edges of technologies, especially where application logic and databases start to blur. This curiosity often leads to unconventional experiments and creative (sometimes questionable) solutions.
From time to time, I also teach programming, which helps me share knowledge and stay grounded in fundamentals.
In addition to my industry work, I have an academic background with several scientific publications and a coauthored manuscript, reflecting a long-standing interest in research and problem solving.