Comment by porridgeraisin
4 hours ago
I use duckdb often too, but the way it is being hyped in these comments makes me feel like I'm missing out on some insane usecase.
I basically use it to load csv, jsonl, parquet etc etc formats and do arbitrary transformations. Are people doing something else with it?
loading data and doing arbitrary transformations turns out to be a huge PITA with most other tools over a long enough timescale.
Maybe you are unconsciously doing the right thing(TM) already? So try doing it with SQLite instead :)
Probably because you probably don't have to do those arbitrary transformations that often. I do, being in a security-related role. But I wouldn't have recognized its usefulness in my previous roles as a front/backend dev.