Re: [sqlalchemy] Transaction integrity issue in SQLAlchemy SQLite dialect

2023-05-10 Thread Mike Bayer
the pysqlite driver does not deliver SERIALIZABLE isolation in its default mode of use. you have to use workarounds to achieve this. See the documentation at https://docs.sqlalchemy.org/en/20/dialects/sqlite.html#serializable-isolation-savepoints-transactional-ddl which details how to use thes

[sqlalchemy] Transaction integrity issue in SQLAlchemy SQLite dialect

2023-05-10 Thread Roman Diba
Summary: The SQLAlchemy SQLite dialect does not fully support serializable transaction isolation in SQLite, leading to potential invalid data when transactions interleave. Hello, This report documents an issue with transaction integrity in the SQLAlchemy SQLite dialect. SQLite itself is able