|=--------------------------------------------------=|
_________________ .____ ___________________
/ _____/\_____ \ | | \_ _____/\______ \
\_____ \ / / \ \| | | __)_ | | \
/ \/ \_/. \ |___ | \ | ` \
/_______ /\_____\ \_/_______ \/_______ //_______ /
\/ \__> \/ \/ \/
|=--------------------------------------------------=|
. |03.01 - SQLite Kernel For Jupyter .
|=--------------------------------------------------=|
Target of this Chapter is to run own SQL Terminal
environment nbtermix with sqlik kernel. The nbtermix
is for of nbterm, terminal jupyter notebook client.
And sqlik kernel is a kernel for jupyter notebook
that allows You to run sqlite database queries in it.
To prepare the environment You'll need at least
several MB of memory to run the nbtermix and sqlite
kernel. However there is some more needed for the
jupyter kernel. The nbtermix is in this case client
of the jupyter kernel.
To install nbtermix just use:
$ pip install nbtermix
To install sqlite kernel for jupyter kernel use:
$ pip install sqli_kernel
To prepare sqlite kernel for jupyter use:
$ sqlik_install
To verify sqlite kernel is installed use:
$ nbtermix --list-kernels
If above was successful the result is:
sqlik|/home/user/.local/share/jupyter/kernels/sqlik
Now You should be prepared to use the sqlite kernel.
To start Your very first notebook issue:
$ nbtermix --kernel sqlik sqlik_test.ipynb
And You should see the jupyter notebook with sqlite
kernel:
sqlik_test.ipynb
----------------------------------------
In [ ]: | |
----------------------------------------
sqlik (idle) @ 1/1 |x|
Note You can use Jupyter Notebook as a web client.
However this is not in scope of this document.
|=--------------------------------------------------=|
; v | Thanks Linux and Vim | buy me a coffee | o |;
|=--------------------------------------------------=|
|