diff options
| author | Daniel Schadt <kingdread@gmx.de> | 2026-08-19 15:34:17 +0200 |
|---|---|---|
| committer | Daniel Schadt <kingdread@gmx.de> | 2026-08-19 15:34:17 +0200 |
| commit | 3aa5cfdf38d36178e6ce965ff429181db39e8c50 (patch) | |
| tree | 69f4943978ac57df376e67984b041486262f02d1 | |
| parent | dcf0c26c2449a537bfc8f43b5292118a8091381b (diff) | |
| download | fietsboek-3aa5cfdf38d36178e6ce965ff429181db39e8c50.tar.gz fietsboek-3aa5cfdf38d36178e6ce965ff429181db39e8c50.tar.bz2 fietsboek-3aa5cfdf38d36178e6ce965ff429181db39e8c50.zip | |
use WAL mode for SQLite
this should make it work better for concurrent access, and prevent
"database is locked" errors
| -rw-r--r-- | fietsboek/models/__init__.py | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/fietsboek/models/__init__.py b/fietsboek/models/__init__.py index 2130901..004ed8e 100644 --- a/fietsboek/models/__init__.py +++ b/fietsboek/models/__init__.py @@ -31,6 +31,7 @@ def get_engine(settings, prefix="sqlalchemy."): # checks them. def _fk_pragma_on_connect(dbapi_con, _con_record): dbapi_con.execute("PRAGMA foreign_keys=ON;") + dbapi_con.execute("PRAGMA journal_mode=WAL;") if engine.dialect.name == "sqlite": event.listen(engine, "connect", _fk_pragma_on_connect) |