Hi, I was trying to work through this tutorial from the Dagster blog https://dagster.io/blog/dagster-crash-course-oct-2022. I see this error when I try to start dagit:

File "/Users/aeury/code/my-dagster-project/.venv/lib/python3.10/site-packages/dagster/_core/storage/sqlite_storage.py", line 54, in __init__
    self._run_storage = SqliteRunStorage.from_local(_runs_directory(base_dir))
  File "/Users/aeury/code/my-dagster-project/.venv/lib/python3.10/site-packages/dagster/_core/storage/runs/sqlite/sqlite_run_storage.py", line 84, in from_local
    engine.execute("PRAGMA journal_mode=WAL;")
AttributeError: 'Engine' object has no attribute 'execute'

I'm using Python 3.10 and one difference from the blog post is that I created a python project from scratch with poetry. Any help would be appreciated! 🙂

Hi Adam - this might be related to a new version of sqlalchemy that just went live today: https://pypi.org/project/SQLAlchemy/#history We're rolling out a pin in the next 24 hours, but in the meantime I would expect this to work if you reinstall with sqlalchemy<2.0.0

Thanks @daniel! I will give that a try. 🙂