python mysql interface is outdated

[cg-laser]

The python packageMySQL-python is outdated. On MacOs it only compiles with an old mysql version

brew remove mysql
brew install [email protected]
brew link --force [email protected]
pip install mysql-python

See https://stackoverflow.com/questions/51343325/command-cc-failed-with-exit-status-1-on-osx-high-sierra/51351548#51351548 for a possible list of replacements.

[anelles]

Going through these issues: I think it is important that we move to another currently maintained library. Nothing is worse than broken externals.

[anelles]

@cg-laser, if we change to MongoDB, will this solve this problem along with other issues?

[cg-laser]

the ARIANNA DB will stay in mysql, there's not really a point in transferring that to MongoDB, so we still need the SQL interface. But this bug is not really critical as one can get the SQL library to work on all current systems, and because we anyway ship the database as JSON, so most people will never need the SQL manager.