tgulacsi
Re:Identify a London Underground Line just by listening to it
on Tuesday April 07, 2026 @11:50AM (#47677196)
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;