Enable WAL mode in SQLite (NativePHP#405)

simonhamp · web-flow · commit fd5860a0c25c · 2024-11-12T18:27:55.000Z
diff --git a/src/NativeServiceProvider.php b/src/NativeServiceProvider.php
@@ -4,6 +4,7 @@
 
 use Illuminate\Console\Application as Artisan;
 use Illuminate\Support\Arr;
+use Illuminate\Support\Facades\DB;
 use Native\Laravel\Commands\FreshCommand;
 use Native\Laravel\Commands\LoadPHPConfigurationCommand;
 use Native\Laravel\Commands\LoadStartupConfigurationCommand;
@@ -122,6 +123,9 @@ public function rewriteDatabase()
         ]]);
 
         config(['database.default' => 'nativephp']);
+
+        DB::statement('PRAGMA journal_mode=WAL;');
+        DB::statement('PRAGMA busy_timeout=5000;');
     }
 
     public function removeDatabase()
