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.


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.


I wrote a book!


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.


Architectures PostgreSQL

Brown Bag Lunch Orness: Orness s’inspire du concept du Brown Bag Lunch et vous invite à déjeuner autour d’un sujet technique.

Le domaine des bases de données se transforme depuis quelques années, avec en particulier de nouvelles offres autour des notions de NoSQL… Au point que l’on peut se demander si les bases de données relationnelles ont encore leur place dans nos infrastructures de production.

Ce BBL a pour objectif de rappeler quels problèmes PostgreSQL sait résoudre pour vos applications et montre ainsi qu’il est toujours pertinent de l’utiliser en 2018. Nous détaillerons des points d’architecture de production, de haute disponibilité, de durabilité et bien évidement nous adresserons également le traitement des données en SQL.


PostgreSQL Conference Europe, 2018

PGConf.EU is a unique chance for European PostgreSQL users and developers to catch up, learn, build relationships, get to know each other and consolidate a real network of professionals that use and work with PostgreSQL.

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