News for hackers. Stuff that matters.

tgulacsi

5/9 - I've never been in London and never heard these sounds before :)
Re:Garage: Open-Source Distributed Object Storage on Saturday July 20, 2024 @07:52AM (#41015797)
Beside personal photo store, I use the storage part for file store at work (basically, indexing is off), with a simplifying wrapper for upload/download: github.com/tgulacsi/camproxy

With the adaptive block hashing (varying block sizes), it beats gzip for compression.

Re:PRQL, Pipelined Relational Query Language on Wednesday July 26, 2023 @01:27AM (#36873467)
This is the "set based" approach for the MAX: there does not exist a bigger element:

  SELECT article, dealer, price
    FROM   shop s1
    WHERE  NOT EXISTS (SELECT 1 FROM shop s2 
                         WHERE s2.price > s1.price AND
                               s2.article = s2.article)
    ORDER BY article;