All of this is really about web dev, not s/w dev in general.

npm and pip are curses on the planet.

One point right from the beginning of the article: Why would you EVER leave a public port open straight to phpMyAdmin?

This is what SSH tunneling is for...