DEV Community

Discussion on: Database design where state is a function of mutations.

Collapse
 
rhymes profile image
rhymes

You're describing something similar to event sourcing I guess. A system (a DB in your case) in which the state is the result of a series of events applied to the initial state.

If you want to go deeper into event sourcing you might want to take a look at these two posts:

Regarding existing DB designed specifically for that kind of pattern, I only know of EventStore. Note that you can do ES on top of relational DBs as well.

I'm sure there are third party solutions too.

Collapse
 
itsarnavb profile image
Arnav Bansal

Thanks! Event sourcing is exactly what I was looking for!

It's amazing how easy it is to find relevant reading once you've got the right vocabulary.