From: AsamK <asamk@gmx.de>
Date: Tue, 14 Jan 2025 21:35:45 +0000 (+0100)
Subject: Enable sqlite WAL journal_mode
X-Git-Tag: v0.13.12~12
X-Git-Url: https://git.nmode.ca/signal-cli/commitdiff_plain/e11e0930209e330649af182eaa0317d2d987d4e8

Enable sqlite WAL journal_mode

Related #1670
---

diff --git a/lib/src/main/java/org/asamk/signal/manager/storage/Database.java b/lib/src/main/java/org/asamk/signal/manager/storage/Database.java
index 938bb010..5099662e 100644
--- a/lib/src/main/java/org/asamk/signal/manager/storage/Database.java
+++ b/lib/src/main/java/org/asamk/signal/manager/storage/Database.java
@@ -95,7 +95,7 @@ public abstract class Database implements AutoCloseable {
         sqliteConfig.setTransactionMode(SQLiteConfig.TransactionMode.IMMEDIATE);
 
         HikariConfig config = new HikariConfig();
-        config.setJdbcUrl("jdbc:sqlite:" + databaseFile + "?foreign_keys=ON");
+        config.setJdbcUrl("jdbc:sqlite:" + databaseFile + "?foreign_keys=ON&journal_mode=wal");
         config.setDataSourceProperties(sqliteConfig.toProperties());
         config.setMinimumIdle(1);
         return new HikariDataSource(config);