3 ms·
The first rule of data modelling is that you should model only what you care about. A good model allows you to store and retrieve what you need to meet your re
by wrwatson 5y ago
The first rule of data modelling is that you should model only what you care about. A good model allows you to store and retrieve what you need to meet your requirements.
Maybe you care about all the events that have ever happened on your incredible journey to reach a list of the customers you have today.
Or maybe it would be sufficient to have been mutating a customers table all along. If that is sufficient, then it would be faster and more straightforward to have done so.
- mistahenry 5y agoThis is why I always like to have a `status_history` or `audit` table. You don't have to have event sourcing to still want a trail of who changed what in the system when.