1 files changed, 27 insertions, 0 deletions
diff --git a/server/jobs/incremental-vacuum.js b/server/jobs/incremental-vacuum.js
new file mode 100644
index 0000000..f0fa78a
--- /dev/null
+++ b/server/jobs/incremental-vacuum.js
@@ -0,0 +1,27 @@
+const { R } = require("redbean-node");
+const { log } = require("../../src/util");
+const Database = require("../database");
+
+/**
+ * Run incremental_vacuum and checkpoint the WAL.
+ * @returns {Promise<void>} A promise that resolves when the process is finished.
+ */
+
+const incrementalVacuum = async () => {
+    try {
+        if (Database.dbConfig.type !== "sqlite") {
+            log.debug("incrementalVacuum", "Skipping incremental_vacuum, not using SQLite.");
+            return;
+        }
+
+        log.debug("incrementalVacuum", "Running incremental_vacuum and wal_checkpoint(PASSIVE)...");
+        await R.exec("PRAGMA incremental_vacuum(200)");
+        await R.exec("PRAGMA wal_checkpoint(PASSIVE)");
+    } catch (e) {
+        log.error("incrementalVacuum", `Failed: ${e.message}`);
+    }
+};
+
+module.exports = {
+    incrementalVacuum,
+};