Upcoming Online Meetup: A Change-Data-Capture use-case: Designing an Evergreen Cache

Wix Engineering
Wix Engineering
Published in
1 min readJul 2, 2020

Your app is slow? Just cache your SQL database queries, right? Even if you have inherent database design flaws or query structure issues, caching will most likely solve your problem. Pat yourself on the shoulder and go grab a cookie.

But wait, what if your app is not the only thing that writes to the DB? Okay, well, we can always do polling, execute DB triggers, etc… Let’s face it though — it all works until it doesn’t.

Enter Change-Data-Capture. With it, a DB can send change events (SELECT, DELETE and UPDATE) which you can then register to. Think of it as an opposite to Event Sourcing that aggregates events to produce state — CDC is about getting events out of states. Once CDC is implemented, you can subscribe to events and update cache accordingly!

Intrigued? Join us for a meetup with Nicolas Fränkel. Nicolas will describe an easy-to-setup architecture that leverages CDC to create an evergreen cache:

https://www.meetup.com/at-wix/events/271641848/

--

--

Wix Engineering
Wix Engineering

Wix Engineering. We develop innovative cloud-based web applications that influence our Wix.com 150M+ users worldwide