I would like to observe some cryptocurrency prices and for that, I want to store a string, everey second in a database for ca. 3 days. The string will vary in length, it will be 2500 characters max. (complete orderbook), sometimes just 50 (prices). I want to analyze the prices later in Python.
Several questions arise for me: 1) Which database would you recommend? I have worked with SQLite and like it so far, but I am unsure whether it’s the most efficient solution, as file sizes get large and reading might be slow. Are there more appropriate solutions? 2) If the string has a special format, e.g. JSON, should my choice from quesiton 1) change – are there special databases which fit well with my use case?
Thank you very much in advance!