Python sqlite3 practical example for Research Software Engineers. This tutorial is prepared for a presentation at the local RSE seminar and aims to new SQL users with some experience in Python.
Provide a practical example where relational databases are used in research to organize and maintain large sets of data.
This tutorial has been tested only on Ubuntu 16.04 with pre-installed sqlite3 and sqlitebrowser along with python3 from Anaconda. However it should work as it is on other Linux and Mac machines, and hopefully Windows.
Follow the tutorial by working through Python scripts starting with part in ascending order.
Provided here solutions are overly simplified and not always the best way of doing things. This is done merely for instructive purposes and introduction to the general workflow and SQL syntax. For instance, refer to SQLAlchemy and Pandas for further steps towards more professional solutions.
The content of slides has been mercilessly ripped off from multiple publicly available sources.
Please contact me with any suggestions or general feedback.