News for hackers. Stuff that matters.
Re:Why We’re Building Flux, a New Data Scripting and Query L... by georgewfraser on Thursday July 19, 2018 @11:35PM (#17572235)
SQL definitely has weaknesses, but I wish people wouldn't use "straw man" examples to crap all over it. The flux example from his blog post would look something like this:

    select 
        lag(value, 0) over recent * 1 + 
        lag(value, 1) over recent * 0.5 + 
        lag(value, 2) over recent * 0.25 + 
        ... as exp_moving_avg
    from telegraph
    where time > datetime_sub(current_datetime(), interval 1 hour)
    and measurement = 'foo'
    window recent as (order by time rows 10 preceding)
Here, the main difference between flux is that flux has a built-in exponential moving average function, whereas in SQL we have to actually write out the formula.
Re:Why We’re Building Flux, a New Data Scripting and Query L... by techno_modus on Friday July 20, 2018 @05:15AM (#17573548)
> Here, the main difference between flux is that flux has a built-in exponential moving average function, whereas in SQL we have to actually write out the formula.

The possibility to provide arbitrary data processing functions is one of the core features of contemporary query languages. In SQL it has always been a huge problem (and your example is a good demonstration). In the example provided by they also rely on a built-in (exponential smoothing) function and therefore it is not clear whether I can really perform arbitrary ad-hoc computations within the query itself (without built-in or externally defined functions).

Re:Why We’re Building Flux, a New Data Scripting and Query L... by Twisell on Friday July 20, 2018 @06:13AM (#17573780)
> The possibility to provide arbitrary data processing functions is one of the core features of contemporary query languages.

Yes and this is actually a big selling point of PostgreSQL based solutions. It's important that peoples don't confuse Modern SQL solutions with the ones they may have encountered decades earlier or comparison with NoSQL will indeed be unfair.

Re:Why We’re Building Flux, a New Data Scripting and Query L... by jamra on Friday July 20, 2018 @12:20AM (#17572428)
Are you referring to windowing functions?