I’m thrilled to announce that I’ll be speaking at the inaugural PyCon Greece 2025! On Friday, August 29 in Athens.

I’ll present a talk titled: Developing Database Extensions with Python: Real-World Examples in SQLite, DuckDB, and PostgreSQL.

What’s the Talk About?

Databases are at the heart of every data-driven application. But what if your database could do more — like running Python code inside SQL queries? This talk dives into how Python can extend and supercharge databases, without having to write a single line of C.

I’ll explore three popular database systems, each with a different way to integrate Python:

  • SQLite and DuckDB let you register Python functions directly into SQL via Python’s built-in sqlite3.create_function. This makes it easy to inject custom business logic or data transformations on the fly.
  • PostgreSQL takes things further with PL/Python, a fully featured procedural language that lets you write SQL functions in Python. I’ll also discuss advanced scenarios like embedding the Python interpreter directly inside a PostgreSQL extension for even deeper integration.

Why Attend?

By the end of the session, you’ll get a clear understanding of:

  • How to add Python-powered functions inside SQL queries for more flexible and powerful data workflows.
  • The differences, strengths, and limitations of Python integration across SQLite, DuckDB, and PostgreSQL.
  • Practical, real-world examples to help you decide which approach suits your projects—whether you’re building ETL pipelines, prototyping analytics, or hacking on your own database features.

Who Is This For?

If you’re a Python developer interested in data engineering, analytics, or database internals, this talk will give you new ideas and tools to extend your databases with Python.

If you’re attending, feel free to reach out beforehand — I’d love to chat about Python, databases, or anything else tech-related.