4 ms·
The notebook style of exploring data in a database is absolutely great, but I have yet to find a great implementation of it. Azure Data Studio can connect to a
by wodenokoto 2y ago
The notebook style of exploring data in a database is absolutely great, but I have yet to find a great implementation of it.
Azure Data Studio can connect to a variety of databases and has completions, but tend to forget if you've set a cell to output a plot. It also doesn't have good functionality for carrying over results from one cell to the next.
Jupyter notebooks don't have any kind of autocompletion against a database (at least to my knowledge), but you do get a lot of control of how you want to store things between cells and display things.
This DuckDB UI looks great, and while DuckDB can read a lot of files, I'm not sure if it has enough connectors to be a general database exploration notebook
- RyanHamilton 2y agoI also didn't like the existing notebook implementations. I wanted it to run locally, be based on markdown, specialized for just SQL and be easy to store in git. So I wrote one myself: https://www.timestored.com/sqlnotebook/ https://www.timestored.com/sqlnotebook/ It ships as part of qstudio and can connect to 30+ databases. If you have any feedback please leave it on github, I only released it a few months ago.