Range joins in DuckDB

Re:Range joins in DuckDB by orthoxerox on Friday May 27, 2022 @01:40PM (#31532419)

DuckDB has become my preferred tool for hardcore data wrangling. Excel is fine for like 80% of data processing tasks, but the remaining twenty percent are a pain, especially when you're CPU bound on a remote desktop. Smuggling the DuckDB JDBC driver onto said remote machine was the most productive infosec violation I've ever committed.

[ Parent | on HN ]

Re:Range joins in DuckDB by minaguib on Friday May 27, 2022 @02:29PM (#31533050)

I don't know why I waited so long to try it.

I wrangle a ton of raw and aggregate data locally every day. I've had a 10-year habit of massaging via unix CLI tools and pipes then moving to excel. I guess I didn't wanna write code. Funny thing is I love SQL.

But with `duckdb_cli` it's a game-changer. I'm truly truly impressed.

[ Parent | on HN ]

Re:Range joins in DuckDB by ignoramous on Friday May 27, 2022 @03:15PM (#31533666)

> I've had a 10-year habit of massaging via unix CLI tools and pipes then moving to excel.

Have you, at any point, considered / used dgsh [0] or a similar tool? If so, how has been your experience with it?

[0] https://news.ycombinator.com/item?id=13352659

[ Parent | on HN ]

Re:Range joins in DuckDB by minaguib on Friday May 27, 2022 @08:32PM (#31536489)

Interesting. Never tried dgsh before, but yea it looks like my poor-man's CLI workflow for a lot of tasks

[ Parent | on HN ]

Re:Range joins in DuckDB by hawkfish-rmgw on Friday May 27, 2022 @02:25PM (#31532987)

Our lips are sealed.

[ Parent | on HN ]