I am looking to store small time series data (only 100 points), but millions of them. I currently use sqlite. Any other suggestions that I could use?
I am looking to store small time series data (only 100 points), but millions of them. I currently use sqlite. Any other suggestions that I could use?
When you're doing a basic process, reliability >> efficiency.
And sometimes more pieces in your stack just decrease reliability of the entire system. (Admittedly! Rolling your own version of an already well-implemented stack component is not without its peril as well)
What's the transactional activity with that time series you're storing? (i.e. are you writing these individually each millisecond or are you writing in batches every hour)
Go should be faster and more efficient than python/ruby so I'd expect even less RAM/better performance.
SQLite3 these days is good for embedded devices but that's about it IMHO.