Another option for SQLite notebook like functionality

[bucweat]

Hi,

Just sharing another way for you to execute SQLite in a notebook environment that you may want to take a look at, especially if you have the need to generate output as this solution lets you operate in a standard jupyter notebook formatted file with all the options that provides. This solution is more complex as it requires conda and xeus and may not run on your platform (see Apple Silicon note below).

Could vscode-sql-notebook be made to work with .ipynb formated notebook file?

From xeus-sqlite website, xeus-sqlite is a Jupyter kernel for SQLite based on the native implementation of the Jupyter protocol [xeus](https://github.com/jupyter-xeus/xeus). Installation is fairly easy with conda https://xeus-sqlite.readthedocs.io/en/latest/installation.html. Note that this does NOT work currently if you have Apple Silicon (this comment based on third person info...there may be Apple Silicon support but I could not find explicit documentation of such).

vscode-jupyter https://github.com/microsoft/vscode-jupyter allows you to run jupyter notebooks inside of Visual Studio Code. The current release (2022.8.100) of vscode-jupyter does NOT work with xeus-sqlite as it cannot find the xsqlite kernel. HOWEVER, I've been working with one of the developers on this issue (microsoft/vscode-jupyter#11240), and a solution has been found which should be released in the near future (I hope!).

My main reason for looking at this solution is the fact that the file is a standard notebook .ipynb which allows for mixing cells and markdown, and adds a lot of flexibility especially for output. It saves the output of the SQLite queries to a standard jupyter notebook file, which can then be exported to a huge number of file types in the jupyter notebook environment, and can also be processed with many different types of tools like Pandoc to create all kinds of file output formats.

Running in Visual Studio Code Insiders (pre-release version of vscode-jupyter):

Same .ipynb file running in jupyter notebook with xeus-sqlite kernel (note I did not run any of the cells...this is the .ipynb file as saved from Visual Studio Code in previous image):

.ipynb file exported to HTML: