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 938bb010e73e7492bc22b431b41570ee11bd1de4..5099662ef21e74bedb19641be9da76b221136a7e 100644 (file)
--- 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();
         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);
         config.setDataSourceProperties(sqliteConfig.toProperties());
         config.setMinimumIdle(1);
         return new HikariDataSource(config);