Dec 28, 2022Liked by Robert Yi 🐳

Just gonna jump in and pile on the hot-takes here...

First off, I don’t know anything about hyperquery so I’m staying out of that part of it.

But analysis both is and isn’t development.

Analysts write code, it should be repeatable, and correct. In other words, it is development. There is nothing fundamentally incompatible or suboptimal with using an IDE for this. Depending on the IDE of course.

But analysts don’t ship code. Not the same way. I mean, you could set up a CI system to generate and publish a report on merges, but that’s quite fanatic. I tried. It was short-lived. So we default to think “notebook” as the solution because it’s code but has plots and isn’t an IDE.

RStudio is an interesting case study here. It is unquestionably an IDE. I have shown it to colleagues in IT and they all agree it is an IDE. It has all the debugging features. The git integration. The testing framework integrations. But it is also definitely a tool for analysis. It displays plots. It produces reports. It publishes interactive visualizations. It can even help you write to word if you need to.

So where does this leave us? A lot of IDEs aren’t good IDEs for analysts. DataGrip (or whatever other SQL client) isn’t, and afaik never attempted to be. Same with IntelliJ, even though someone has tried to duct-tape a “show plots” feature onto it. But there are IDEs for analysis. In addition to RStudio, there is DataSpell (which I haven’t used in a while, and had a very “notebook with stuff glued on” feeling to it if memory serves). Most seem to be python-first though. SQL is left behind.

I have left out any discussion of new-ish entrants like hex (and hyperquery) because I don’t know enough about them. But It feels like we are at a Henry Ford kind of moment where everyone is so used to notebooks, it is the only thing they can think to ask for. The next winner in this space introduces something new that is neither a notebook nor IntelliJ. But they will have to teach people how to use it.

Expand full comment