Hacker News: tgulacsi

New comment by tgulacsi in "Identify a London Underground Line just by listening to it"

tgulacsi — Tue, 07 Apr 2026 15:50:48 +0000

5/9 - I've never been in London and never heard these sounds before :)

New comment by tgulacsi in "Garage: Open-Source Distributed Object Storage"

tgulacsi — Sat, 20 Jul 2024 11:52:02 +0000

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.

New comment by tgulacsi in "PRQL: Pipelined Relational Query Language"

tgulacsi — Wed, 26 Jul 2023 05:27:37 +0000

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;