IC Newsletter #1

Welcome to the inaugural IC newsletter!

We’ll be using this space to keep you updated on what’s new with everybody’s favorite/bane of their existence – royalty accounting – and the software + service making it easier, Infinite Catalog (that’s us).

Categorized as Newsletter

We Are Living in a Materialized World

Here at IC, the main technical challenge we face is adding up lots of numbers in a dynamic and performant way. The advent of streaming means that modern royalty accounting involves millions of individual transactions, and even the most optimized database queries start suffering from performance issues. We’ve spent the last couple of months building architecture to handle this issue, and I’m excited to share what we’ve come up with. It relies on two main pieces: materialized views in our PostgreSQL database, and leveraging a change data capture event stream in Kafka to trigger refreshing those materialized views.