interactive icon indicating copy to clipboard operation
interactive copied to clipboard

Allow SQLite query results to be saved and shared between cells (like for SQLServer)

Open techarch opened this issue 2 years ago • 1 comments

First I want to say that polyglot notebooks are fantastic including all the extensions. I also love support for SQLite as it is very useful when prototyping SQL schemas and queries. It would be even more awesome if the results of a query could be saved and shared with other cells just like the SQLServer extensions does. So ideally we could write:

#!connect sqlite --kernel-name moviedb "Data Source=movies.db"

#!sql-moviedb --name movies SELECT * FROM MOVIE

#!share --from sql-moviedb movies movies

// then we could iterate over the rows from the movies variable.

techarch avatar Dec 29 '23 17:12 techarch

You guys have too much work to do! Here is a similar situation in the Jupyter notebook:

Image

Error: (1,24): error DNI103: Unrecognized parameter name '--name'

Full notebook: https://github.com/BryanWilhite/jupyter-central/blob/main/polyglot-notebooks/sqlite-tabular-data-resource.ipynb 📓

BryanWilhite avatar Mar 06 '25 04:03 BryanWilhite