Getting started

Launch Jupyter notebook with jupyter notebook or Jupyter lab with jupyter lab and create a new SQLite notebook by selecting the xsqlite kernel. Or launch Jupyter console with jupyter console –kernel xsqlite.

To perform operations on xeus-sqlite you must have a loaded database. You can do that using the %LOAD or %CREATE magics. Magics are commands that allow you to perform operations that are not necessarily SQLite code, we give a brief example on how to use the mentioned ones here, for more extensive explanation on magics access the main page.

Creating a new database

If you want to create a new database from scratch you can use:

%CREATE path-to-db/yourdatabase.db namedb

This will create a yourdatabase.db file in the specified location.

Loading a new database

If you already have a database you can load it with:

%LOAD path-to-db/yourdatabase.db

Usage

Now you can run normal SQLite code and the changes will take place on this database.

Warning: the changes made while in the jupyter interface are permanent to your database.

To change the database you’re working with simply run the %LOAD or %CREATE magic with a new target.

Notes

It’s recommended to use words from the syntax in upper case and arguments in lower case simply to improve readability. The input strings are sanitized and it doesn’t matter if the input is written in upper or lower case, with the exception of names (like column names, tables names, etc) and the reading options to load a database that should receive the [r w rw] arguments in small letters.