Sometimes you just want to build a simple prototype to read/store data. You don’t want to spend too much time designing the perfect Cassandra schema or writing a wrapper for Elasticsearch, so you default to the good old MySQL.

It turns out that writing a simple Python3 + MySQL script is not as easy as it seems, and you can easily spend a day setting things up.

That’s why I wrote this simple script. You can use it as a reference every time you need to start a new prototype to read/write data using MySQL.

Leo Celis