diff options
| author | Xe Iaso <me@xeiaso.net> | 2023-06-20 07:11:40 -0400 |
|---|---|---|
| committer | Xe Iaso <me@xeiaso.net> | 2023-06-20 07:13:10 -0400 |
| commit | c13e1feed9b73f045f7baba0efc87aba0de3b2c6 (patch) | |
| tree | 9d153deaefb3aaff415fa3276f797c1e6e148ac2 /cmd/marabot/schema.sql | |
| parent | 7dca3ad008041edf9049b5554c23a3e7d6163fab (diff) | |
| download | x-c13e1feed9b73f045f7baba0efc87aba0de3b2c6.tar.xz x-c13e1feed9b73f045f7baba0efc87aba0de3b2c6.zip | |
cmd/marabot: use transactions to be compatible with litestream
Signed-off-by: Xe Iaso <me@xeiaso.net>
Diffstat (limited to 'cmd/marabot/schema.sql')
| -rw-r--r-- | cmd/marabot/schema.sql | 5 |
1 files changed, 4 insertions, 1 deletions
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, |