_________________ .____ __________________

|=--------------------------------------------------=|
_________________ .____ ___________________
/ _____/\_____ \ | | \_ _____/\______ \
\_____ \ / / \ \| | | __)_ | | \
/ \/ \_/. \ |___ | \ | ` \
/_______ /\_____\ \_/_______ \/_______ //_______ /
\/ \__> \/ \/ \/

|=--------------------------------------------------=|
. |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.

|=--------------------------------------------------=|
|=--------------------------------------------------=|