From 3aa5cfdf38d36178e6ce965ff429181db39e8c50 Mon Sep 17 00:00:00 2001
From: Daniel Schadt <kingdread@gmx.de>
Date: Wed, 19 Aug 2026 15:34:17 +0200
Subject: use WAL mode for SQLite

this should make it work better for concurrent access, and prevent
"database is locked" errors
---
 fietsboek/models/__init__.py | 1 +
 1 file changed, 1 insertion(+)

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)
-- 
cgit v1.2.3