About
Dimitri Fontaine
PostgreSQL Major Contributor. Two of the contributions — CREATE EXTENSION and Event Triggers — now ship in every PostgreSQL installation in the world.
CREATE EXTENSION
The packaging system that lets you distribute and install add-ons. Before extensions, a third-party module meant patching the source tree; since then they are first-class citizens of the ecosystem.
CREATE EVENT TRIGGER
DDL-level triggers that fire on schema changes, giving programmatic control over CREATE TABLE, DROP INDEX, and the rest of the DDL vocabulary.
PostgreSQL developer, author and open source builder, based near Paris. Most of what I have done professionally for the past twenty-plus years has orbited around PostgreSQL: writing code for the database itself, building tools on top of it, teaching it, and occasionally starting or running companies around it.
Background
I have started several companies with open source at the core, spent time as CTO and CEO, then moved back into a principal engineering role. I spent a number of years at 2ndQuadrant doing PostgreSQL consulting and development, then joined Citus Data to work on distributed PostgreSQL and build pg_auto_failover. Citus was acquired by Microsoft in 2019.
Why “YeSQL”
It was a pun on NoSQL, back when everyone was explaining that relational databases had had their day. The joke has aged; the position has not. In those years teams moved work into their application code that their database was already doing better — joins, aggregates, constraints, transactions.
It is the same idea as the book: most teams leave enormous query power on the floor, not because PostgreSQL is hard, but because nobody showed them what it can actually do.
