Flyway

Today I decided to ditch Flyway Desktop execution from CLI and integrate into my Sway + Wofi desktop environment. Basically, there is what you need: Get an Flyway icon and paste it into flyway.svg file Copy that SVG file into $HOME/.local/share/icons/hicolor/scalable/apps/flyway.svg Change the color for the icon by adding fill="#CC0200" to the path Create an $HOME/.local/share/applications/flyway.desktop file with the content like this: 1 2 3 4 5 6 7 8 9 10 11 12 [Desktop Entry] Version=1.0 Type=Application Name=Flyway GenericName=Database migration tool Comment=Database Migrations Made Easy Categories=IDE;Development Keywords=Database;SQL;IDE;JDBC;ODBC;MySQL;PostgreSQL;Oracle;DB2;MariaDB Exec=$HOME/.local/share/flyway/flyway-desktop/flyway-desktop --enable-features=UseOzonePlatform --ozone-platform=wayland --no-sandbox %U Icon=flyway Terminal=false MimeType=application/sql Because Flyway Desktop is Electron app, we are passing few flags to run it on Wayland system. If you still use Xorg, then just remove those flags. ...

Migrating old databases Currently mostly busy with modernizing 15 years old infrastructure of some customer. Old and huge MySQL databses. No foreign keys. No timestamps. It’s all pretty convoluted. Many VM’s running directly on KVM without libvirt abstraction. Failing hard drives. Old PHP. And the overaly of many “big brain” sysadmins. But at least, I gained full access to the most of the resources, restored passwords, established secure remote access, etc. ...