I a have a business case where i need to store a lot of messages for fixed amount of time. So let's assume
- 20 messages per second, each message is quite small and has at most 10-20 columns (about 100 bytes).
- storage duration of 4 years. After that time old messages can be deleted.
- stored messages can be deleted and cannot be modified.
- i need to generate aggregate queries over ranges of the messages - like from each day, but it doesn't need to be fast.
Which DB/storage engine would be best for such scenario.