Schedule - pgDay Paris 2020

From a legacy relational DB to an event queue

Date: 2020-03-26
Time: 16:45–17:30
Room: Auditorium

Change data capture is an efficient way of sharing and propagating data in a company when it reaches a certain scale. There are many patterns when designing a database to ensure all writes are effectively propagated. However it is not easy to retrofit those in an existing schema.

Since PostgresSQL 9.5 it is possible to use logical replication in PostgresSQL to generate a specific WAL(write ahead log) which can be used as a source of events for the rest of the company. In this talk I’ll show you how we used these at leboncoin to generate a transactional event log of all that happens to ads in our main database.


Fabrice Vaillant