Login Sign up

Wednesday Oct. 14, 2020, 5:30 p.m.–Oct. 14, 2020, 5:45 p.m. in Jupyter Community: Tools

The MariaDB Jupyter kernel

Robert Bindar

Audience level:
Novice

Brief Summary

The MariaDB kernel allows to run MariaDB directly in your Jupyter notebook. You can display the results of you favourite SELECTs in matplotlib graphics or export them to a DataFrame in another Python Notebook through database specific %magic commands. You'll get to know how the kernel works, how to install and use it and its most important features.

Outline

We were lucky to find out how powerful the Jupyter ecosystem is when we decided to run some analytics on how well we were doing on handling community contributions.

Some months after, after running a little experiment changing the Jupyter Echo kernel code with minor effort we were amazed by how almost magically were able to run regular SQL statements in a Jupyter Notebook. We recorded a short video with our little breakthrough and ideas started flowing. This is when we decided to implement a kernel properly.

This talk covers the current state of the MariaDB kernel, the existing features, how to install and use it and how we imagine it should look like in terms of functionalities in the upcoming months.

It will also explain the inner structure of the kernel, how to pass it different configuration options and demo some common use cases.

There is no background knowledge expected to understand the content of this talk, if you've ever used a Jupyter notebook, a SQL database or both or you'd just love to hear about these technologies, you're more than welcome to attend.