Migrated to MySQL

posted on 09:01 PM on Saturday 07 December 2019

SQLite was great but concurrency was a problem, so the website has now swapped to using MySQL. Some code changes were needed due to data types but nothing major. Some settings specific to MySQL needed to be done but again nothing major. Took the time to update the code not to rely on cron but to use an internal scheduler in the flask framework and an offline GeoIP database rather than ad hoc queries to online systems. The navigation bar has been fixed to work better on small screens too. Fixed a number of bugs too.