Store VOD wmi data in a database directly or use CQRS?
- by JD01
I need to collect Video on demand bandwidth usage every few minutes (or maybe ever few seconds) and store this in a database so users can produce graphs on bandwidth usage over a period of time (few hours, days, weeks or even possibly months).
So the sort of data that will be stored will be the number of users watching videos, current server bandwidth (Mb/s), multicast bit rate etc.
I am wondering whether using CQRS would be a good approach with Event sourcing as I can then rebuild my objects to create different projections (I.e. different graphs/reports etc) but then again it seems like I am introducing complexity which might not be needed.
Or would it be best to just put the data directly in a database (currently using PostGres) directly and query off that?
Having thought about it, my table is a form of audit log anyway, so I don't think I need event sourcing at all. Any thoughts?