SeashellDB

Python source code for managing and visualizing Seashells MariaDB database

MariaDB package installation notes

sudo apt install libmariadb3 libmariadb-dev
pip3 install mariadb

Setting up

Install dependencies

pip3 install requirements.txt

Create database

Run tools/db_init.sql on your database server

Import raw data

python3 importer.py -p password

Keep in mind that you have to set your own password through -p argument, otherwise the script will exit with exit status 1

Change the others parameters if needed

Add raw data

python3 importer.py -f filename -p password --add

Local Jupyter set up

Extremely handy during code prototyping (eg.: test SQL queries through mariadb connectors, clean raw data, ...)

If Jupyter is already installed (globally): python3 -m pip install jupyter notebook

Run inside your virtual environment (must be enabled):

python -m pip install ipykernel
ipykernel kernel install --user --name=SeashellsDDB

And now globally (virtual environment deactivated):

python3 -m notebook

From web interface change Kernel from Kernel > Change Kernel