Observation and Fix: Sqlalchemy 2.0 Compatibility - Downgrade to Sqlalchemy 1.x

[pannoniac]

Just for information and to help other users of Biophi:

I installed Biophi using miniforge by following instructions provided on the project's github page. However there was a runtime error: AttributeError: 'Engine' object has no attribute 'execute'

I could track the issue down to a change in Sqlalchemy 2.0. Downgrading to Sqlalchemy via conda did the trick: https://docs.sqlalchemy.org/en/14/changelog/migration_20.html It is about engine.execute() which was deprecated in 1.4 and removed in 2.0.

$ conda install "sqlalchemy<2.0" That installed sqlalchemy-1.4.46.

Kind regards and many thanks for providing Biophi, a great application!