Kaizen Today I Learned by Ville Säävuori

Posts tagged mysql

Using And Building Legacy Python 2 Libraries on macOS Monterey

Getting an old Python project working on a M1 Mac running macOS Monterey was somewhat of an battle. M1 and old Docker images I first fixed the Dockerfile to the point where it would run MySQL and Redis properly. The M1 architecture is still a bit of a hurdle with some Docker images, and especially the older ones.

· Read the full article →

How to migrate MySQL database to PostgreSQL

I’ve migrated a couple of old Django projects from MySQL to PostgreSQL lately and decided to document the process here to help make it go faster in the future. If your old database is not exotic in any way the migration process is pretty fast and simple. The hard part is figuring out how and how much you should tweak in the old database to get rid of warnings/errors if there are some.

· Read the full article →

Fixing "Error loading MySQLdb module" on macOS 10.15 Catalina

MySql gets usually installed on MacOS by Brew, which installs a bunch of dylib libraries in /usr/local/opt/mysql/lib/. For some reason my Python installation is looking for wrong version of these files and I’ve yet to find a proper solution for matching up the dependencies. The error message looks like this:

· Read the full article →