Quite interesting — but how is it fundamentally more productive than being in VS code in R or python? You don’t get any of the benefits of an IDE here. I often find myself doing very similar workflows but default to either VS Code or the shell. Trying to imagine this truly making workflows faster/easier/more efficient, but can’t figure it.
Unfortunately not! I do very similar workflows honestly but have basically defaulted to the norm or compromises like:
- write own cli in python that does the sql wrapping and basic transforms and cleaning
- read in the csv with R to make plots and tables.
Boring.
Cursor with 3.5 sonnet has made all this way faster so that’s nice. Often LLMs are now featuring in these pipelines and I see libraries like data bonsai and instructor being helpful. But yeah idk. No bright ideas here but always on the lookout to optimise.
