I have many scenarios where there are some processes orchestrating physical machinery or people.
Each process is a single application, and it’s state is persisted in a sql database.
I think that some of those would benefit a lot from an event sourced architecture, both for statistical analysis (maybe auditing would be enough) and debugging. If i design a process this way it would be just a stream of event, and since the system has been active for years i would produce something like 10 msg/s continuosly, so the speed is not the problem here.
Let’s round it to max 5x10^8 msg/year.
I still have to spike an implementation so i may talking nonsense here would be event sourcing and so event store the right tool for the job here ? Off course i’ll need to keep the working set in memory and snapshot every night, am i on the wrong path ?