Anyone have opinions / thoughts / experience on the best way to store database history? Like if I was storing the values of a stock ticker and wanted to generate a graph of stock price over time (not my actual use case but similar idea).
Seems like there are a lot of wrong ways to do it.
I'll be accessing the DB with an expressJS server and I haven't choosen a database stack yet