Changeset 7b07035 in Klonkt

Timestamp:

07/01/2026 06:18:14 PM (2 months ago)

Author:

roboburr <roboburr@…>

Branches:

main

Children:

dc41bef

Parents:

f1956d7

Message:

chore(db): add busy_timeout + synchronous=NORMAL for concurrent writers

The delivery worker, request handlers and the upcoming background thread-crawler
write concurrently. busy_timeout retries a short write-lock instead of throwing
SQLITE_BUSY; synchronous=NORMAL is safe under WAL and cuts fsyncs.

• src/config/database.js — busy_timeout=5000, synchronous=NORMAL (alongside WAL).

Co-Authored-By: Claude <noreply@…>

File:

• src/config/database.js (modified) (1 diff)

src/config/database.js

@@ -17 +17 @@
 db.pragma('journal_mode = WAL');
 db.pragma('foreign_keys = ON');
+// With WAL + several concurrent writers (request handlers, the delivery worker, the
+// background thread-crawler) a short write-lock should retry rather than throw SQLITE_BUSY.
+db.pragma('busy_timeout = 5000');   // wait up to 5s for a lock instead of failing immediately
+db.pragma('synchronous = NORMAL');  // safe with WAL (no torn writes); fewer fsyncs = faster writes
 
 export function initializeDatabase() {