I will preface this with the fact that I am entirely new to development. I've thrown together a Google Addon within a couple months, but that's about it. (Just to show you my limited experience.)
I'm in the process of converting my "database" into an actual database. Currently, I'm using Google Sheets to store data on a rolling time frame. By rolling I mean data will save for X amount of time, and then old data will be deleted to make room for the new data. I'd prefer to have a legit database setup to avoid this because certain calculations I am making would work much better with more/older data over time to show a more evident trend.
I am currently using this method for a Google addon that deals with cryptocurrency. Specifically, I capture data from the exchanges (open,low,high,close etc) show the "real time" (quotes because there are several min delays between each call because of G sheet trigger/timer limits), show that data in a nice format to the user, and then also save that data on the "back end" in hourly/4 hour time frames to make calculations on it. (Many daisy chained sheets here)
I will say, even with the cell/data capping being an issue, and the fact that I have had to daisy chain so many sheets together for this to work, the fact that I can make calculations right there in a formula has been great.
So in one instance, Google Sheets has been very helpful in doing things I want to happen. But the data storage issue is starting to become a real problem.
I'm looking for recommendations on a simple database that I can use to get this thing setup. I've done some research, and I'm still unsure what kind of DB would be in my best interest for this project. (Relational/non-relational?) I'm assuming some kind of time series DB because it deals with continuous "financial" data. Part of that data I basically just want to regurgitate back out from the exchanges (OHLC data) but just in a nice format. Other parts I need to capture, save, and then do calculations as time goes by (Avgs, Means, etc). I came across timescaleDB and was intrigued. But I thought it would be best to ask people who are more experienced in this area before I go down a rabbit hole.
So to sum up what I am currently doing and looking for:
Saving OHLC exchange data from (currently) 5 different exchanges. (This will most likely just be turned right around within the "app" I'm trying to build for real time data, but also needs to be saved for calculations as data is saved over time.) (Ps. Does this need to be relational? Is that better in this instance for querying data?)
I need to some how be able to make calculations on this data. These will be more than just simple Avg/Mean calculations, but those will be used also. (Nothing like super crazy, but still some power to it. I've read that it's best to have server side calculations?)
I'll need to be able to query the data by different scenarios to actually make those calculations. IE: Query all of BTC-ADA from Bittrex and get the OHLC candle data from dates X to X.
(Not sure if this is relevant or not) Setup webhooks/end points so users can query certain data for outside uses.
This is a long post, but I wanted to be detailed because I've been researching for quite a bit. I'm just lost. Thanks for any suggestions/help.