3 ms·
It was a bad idea to focus on Flux vs SQL. It would be better compared to pig or pandas. I like the approach. I find it annoying that in SQL I need more than
by lixtra 8y ago
It was a bad idea to focus on Flux vs SQL.
It would be better compared to pig or pandas.
I like the approach. I find it annoying that in SQL I need more than select privileges to write my own function or view (Aliases and WITH is all that you can use to structure a big query). Also macros that work on all tables that have certain columns are at best difficult to write in SQL, so there is room for improvement.
OTOH in Flux you write something that looks a lot like the output of a planner, so if things change in your dB you might have to modify your scripts instead of adding an index.