4 ms·
DuckDb makes so much of my life easier, though I've never used it for large problems. The ability to run `select * from 'data.json'` is just lovely. The fact th
by anitil 4mo ago
DuckDb makes so much of my life easier, though I've never used it for large problems. The ability to run `select * from 'data.json'` is just lovely. The fact that it's also a powerhouse is so impressive, I'd usually expect a project to be good at small problems (like mine) xor large problems, but not both
- medvezhenok 4mo agoYup. And an extra benefit that you can treat any file like a table, so you can also do something like UPDATE my_table SET x = file1.x, y = file2.y FROM 'first_file.csv' file1 LEFT JOIN 's3://my_bucket/second_file.parquet' file2 ON file1.id = file2.id WHERE mytable.id = file1.id;