Python source code for managing and visualizing Seashells MariaDB database
sudo apt install libmariadb3 libmariadb-dev
pip3 install mariadb
pip3 install requirements.txt
Run tools/db_init.sql on your database server
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
python3 importer.py -f filename -p password --add
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