|=--------------------------------------------------=| _________________ .____ ___________________ / _____/\_____ \ | | \_ _____/\______ \ \_____ \ / / \ \| | | __)_ | | \ / \/ \_/. \ |___ | \ | ` \ /_______ /\_____\ \_/_______ \/_______ //_______ / \/ \__> \/ \/ \/ |=--------------------------------------------------=| . |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. |=--------------------------------------------------=| |=--------------------------------------------------=|