Gotten in the habit of setting PYTHONUSERBASE to ./site_packages rather than using venv or conda. A couple of dozen projects and all those environments start to take up real disk space.
Bloat beneath Python’s Scales:
A Fine-Grained Inter-Project Dependency Analysis
"Modern programming languages promote software reuse via package managers that facilitate the integration of inter-dependent software libraries. Software reuse comes with the challenge of dependency bloat, which refers to unneeded and excessive code incorporated into a project through reused libraries."
Pulling my hair out figuring out why SQLAlchemy was giving me access denied with a legitimate account. Turned out "mysql+pymysql" failed with access denied, but "mysql+sqlconnector" succeeded. I suspect it had something to do with that "caching_sha2_password" thing.
Could not figure out why my Posit Connect application would not run with the error "Application is of type dash which is not callable". After a couple of hours, I realized that I was deploying with the "api" deployment rather than the "dash".