Really interesting read. Anyone got any comparison between the performance of these against say pandas or R[1]? I'd be particularly interested if anyone has stored multiple timeseries in a table and the performance of looking for individual or the latest timeseries.
I don't have as much experience with pandas, but I've used window functions and psql queries in place of that sort of data munging for production web applications. We have tens of millions of rows and near real time reporting requirements.
Comments
Really interesting read. Anyone got any comparison between the performance of these against say pandas or R[1]? I'd be particularly interested if anyone has stored multiple timeseries in a table and the performance of looking for individual or the latest timeseries.
[1]: I haven't used R myself.
I don't have as much experience with pandas, but I've used window functions and psql queries in place of that sort of data munging for production web applications. We have tens of millions of rows and near real time reporting requirements.
Reach out if you want to compare notes.