Vivarium · Layer 1 · Pyodide · sqlite3

Reproducing python/cpython#137205

Python's sqlite3 stdlib silently drops PRAGMA foreign_keys = ON when the connection was opened with autocommit=False. The same PRAGMA on a second connection opened with autocommit=True takes effect — so two connections that should have identical FK enforcement disagree. The disagreement is the bug surface.