Sign in

Carlo Piovesan

@carlo.piovesan.io
1.1K followers 192 following 135 posts

Compiling @duckdb

PostsRepliesMedia
Carlo Piovesan @carlo.piovesan.io · 29/03/2025
New sticker! @wasm.io has been great, see you all next year!
090
Carlo Piovesan @carlo.piovesan.io · 27/03/2025
Getting started at #wasmio
041
Carlo Piovesan @carlo.piovesan.io · 31/01/2025
getting started: duckdb.org/events/2025/...
010
Carlo Piovesan @carlo.piovesan.io · 13/12/2024
This is great! Unsure on keeping a xlsx file on my computer when you can just do: `CREATE TABLE top2000_2024 AS st_read($URL);` in a persistent database file! I looked for the URL of last 4 years, then GROUP BY single acts (no '&' or 'ft.') that had the same entry each year AND no other song.
FROM (SELECT count(*) as c, array_agg(DISTINCT title_no_albumversie(titel)) as list, artiest, any_value(jaar) as j, min(positie),  max(positie) as p FROM top2000 WHERE positie <= 2000 GROUP BY  artiest) WHERE c =4 AND length(list) =1 AND NOT artiest ILIKE '% & %' AND NOT artiest ILIKE '% ft. %' ORDER BY p LIMIT 40; --- DuckDB table result of aggregation by artist to find a list of its songs to ever finish in top 2000 in the last 4 years, then filter BY same song AND order by max position
240
Carlo Piovesan @carlo.piovesan.io · 14/11/2023
DuckDB v0.9.2: github.com/duckdb/duckd... Once again, I got a PR in as last, unsure what this says about the project, or me.
Mosaic of a duck bathing in the Nile river
000
Carlo Piovesan @carlo.piovesan.io · 29/10/2023
Meanwhile in Museumplein
020