I'm new to systems programming, and lack some general knowledge. Suppose I'm using C99 to build a simple, fast terminal application, it needs to handle persistent data - add new entries to a database and make calculations based on all previous ones.
The expected amount of data to be generated yearly is about 5MiB, as it's only small plaintext entries. The data is somewhat structured - date, timestamp, a few integers and a string per entry. Calculations and visualizations happen on the integers from a range selected by date.
What are the elegant, usual ways to handle this? SQL seems to bloated for this, would some key-value db like LMDB be suited better? Or perhaps some sort of simple native datastructure serialization/deserialization like what I'm used to from scripting languages, loading the entire thing into memory every time?
Again, please excuse the stupid question, the amount of options/libraries/databeses I have to solve this problem just seems infinite to me right now.