Jamie Tanna | Software Engineer
As I wrote about on dependency-management-data's birthday, I've been learning quite a few things about SQL and becoming much more fluent with writing it.
I'll end up writing an SQL query against the dependency-management-data data at least once per day, and so I want to make sure that my workflow works for me.
I've recently made some improvements to the local workflow I've been using for authoring SQL and thought it would be useful to share.
Note: I've called this "2024 edition" but I've never written one of these before. However, I am expecting that in future years this process will be improved and I'll add new posts.
My original setup was that I would write queries directly into the sqlite3, which were often copied from my Neovim editor where at least I had syntax highlighting and could easily create multi-line queries.
Not long after, I learned about the excellent Datasette database browser, and started using that as my main interface for the queries I was writing.
