On a similar note, I just spent way too many hours digging around in SQLAlchemy / SQLite internals and there’s a much more poorly written writeup about handling concurrent SQLite queries safely at https://github.com/PrefectHQ/prefect/pull/9594
Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.