What if you could turn
thousands of lines of code into
simple queries?

As a PostgreSQL Major Contributor, I sometimes get to speak at conferences. Here you will find the list of talks I’ve been doing, with the slides available as PDF.


Message à caractère informatique #46: Faire Le Tri Dans Ses Relations

Message à caractère informatique is a podcast in French from the company Clever Cloud.

In this PodCast Episode we talk about newsworthy items selected by the MACI team, and then about some of my work such as my book The Art of PostgreSQL and then in the High Availability and automated failover solution that I work on, pg_auto_failover.

Cet enregistrement est en français.


I wrote a book!


Postgres Thursday s01e04: Dimitri Fontaine. The Art of PostgreSQL; pg_auto_failover

Postgres.TV is a series of online interviews organized by Nikolay Samokhvalov and Ilya Kosmodemiansky

In this interview we dive in my book The Art of PostgreSQL and then in the High Availability and automated failover solution that I work on, pg_auto_failover.


Postgres Open

PostgresOpen is a non–profit, community–run conference series in the United States focused on business users, database professionals and developers of PostgreSQL, the world’s most advanced open source database. PostgresOpen target entrepreneurs, technologists and decision–makers on the leading edge of data management, open source database innovation and disruption of the database industry. PostgresOpen promotes the business of PostgreSQL as well as its use and development

As a developer using PostgreSQL one of the most important tasks you have to deal with is modeling the database schema for your application. In order to achieve a solid design, it’s important to understand how the schema is then going to be used as well as the trade-offs it involves.

PostgreSQL is the World’s Most Advanced Open Source Relational Database and by the end of this talk you will understand what that means for you, an application developer. What kind of problems PostgreSQL can solve for you, and how much you can rely on PostgreSQL in your daily activities, including unit-testing.


The Art of PostgreSQL

PostgreSQL Ukraine Kyiv Meetup is the Kyiv meetup for the Ukraine PostgreSQL User Group.

PostgreSQL is the World’s Most Advanced Open Source Relational Database and by the end of this talk you will understand what that means for you, an application developer. What kind of problems PostgreSQL can solve for you, and how much you can rely on PostgreSQL in your daily activities, including unit-testing.


FOSDEM 2019: Data Modeling, Normalization, and Denormalisation

FOSDEM is a free event for software developers to meet, share ideas and collaborate. Every year, thousands of developers of free and open source software from all over the world gather at the event in Brussels.

As a developer using PostgreSQL one of the most important tasks you have to deal with is modeling the database schema for your application. In order to achieve a solid design, it’s important to understand how the schema is then going to be used as well as the trade-offs it involves.

As Fred Brooks said: “Show me your flowcharts and conceal your tables, and I shall continue to be mystified. Show me your tables, and I won’t usually need your flowcharts; they’ll be obvious.”

In this talk we’re going to see practical normalisation examples and their benefits, and also review some anti-patterns and their typical PostgreSQL solutions, including Denormalization techniques thanks to advanced Data Types.

Dimitri Fontaine

PostgreSQL Major Contributor

Open Source Software Engineer

France