From c13e1feed9b73f045f7baba0efc87aba0de3b2c6 Mon Sep 17 00:00:00 2001
From: Xe Iaso <me@xeiaso.net>
Date: Tue, 20 Jun 2023 07:11:40 -0400
Subject: cmd/marabot: use transactions to be compatible with litestream

Signed-off-by: Xe Iaso <me@xeiaso.net>
---
 cmd/marabot/schema.sql | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

(limited to 'cmd/marabot/schema.sql')

diff --git a/cmd/marabot/schema.sql b/cmd/marabot/schema.sql
index f38537f..9ddc789 100644
--- a/cmd/marabot/schema.sql
+++ b/cmd/marabot/schema.sql
@@ -1,4 +1,7 @@
-PRAGMA journal_mode=WAL;
+PRAGMA journal_mode = WAL;
+PRAGMA synchronous = NORMAL;
+PRAGMA wal_autocheckpoint = 0;
+PRAGMA busy_timeout = 5000;
 
 CREATE TABLE IF NOT EXISTS discord_roles (
     id TEXT PRIMARY KEY,
-- 
cgit v1.2.3

