List of videos

Now that you've stored your data into the database... you're done with it right? No. Typically storing data into your database is only the beginning of its journey through your company's systems. There's often a need to act on the data: from providing the service the customer actually wanted to sending emails to to doing complex data analytics on the data. PostgreSQL's logical replication features have made it much easier to do change data capture than ever before. Change Data Capture allows you to easily act on the data that you store in your database. In this talk we'll go through the latest developments in the CDC landscape from a PostgreSQL point of view.

With a community of over 40 million members, BlaBlaCar has to scale and automate its platform continuously to keep it fast and reliable. Two years ago year, the foundations team at BlaBlaCar has decided to optimize the core infrastructure by going all-in on containers. Now we have been running all our production services with rkt and CoreOS for several months. This talk is about how BlaBlaCar changed the PostgreSQL default topology to make a node expendable in a containerized environment. Subjects: Service Discovery - Containers (rkt) - Multi Master Logical Replication (BDR) - Monitoring and alerting with Prometheus - Backup and Recovery

PostgreSQL 11 is not done yet. In fact, most people have not upgraded to 10 yet! But many of the things that will be in the next version, targeted for release later in 2018, are already done. This talk will outline some of the bigger and more interesting features to look forward to!

A look back at pgDay Paris 2019.

An introduction to the tools, sites, and concepts available to aid in working with people from a variety of backgrounds. This talk will include some sociology and some global statistics. While not Postgres specific, this talk addresses the impact of having homogeneous work teams, and of having people flee the workspace due to discomfort. https://www.postgresql.eu/events/pgdayparis2019/schedule/session/2401-so-youll-be-working-with-delwomen-or-other-under-represented-groupsdel-other-people/

Most of the time we see finished SQL queries, either in code repositories, blog posts of talk slides. This talk focus on the process of how to write an SQL query, from a problem statement expressed in English to code review and long term maintenance of SQL code. https://www.postgresql.eu/events/pgdayparis2019/schedule/session/2306-how-to-write-an-sql-query/