From c13e1feed9b73f045f7baba0efc87aba0de3b2c6 Mon Sep 17 00:00:00 2001 From: Xe Iaso Date: Tue, 20 Jun 2023 07:11:40 -0400 Subject: cmd/marabot: use transactions to be compatible with litestream Signed-off-by: Xe Iaso --- 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