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.