From e69697300a5e238433faf2e3d1f6e54645a5a1bc Mon Sep 17 00:00:00 2001 From: Yuqian Yang Date: Wed, 30 Apr 2025 00:20:23 +0800 Subject: HALF WORK!: 2025-5-10 --- services/docker/mail-server/aws-sendmail/db.ts | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) (limited to 'services/docker/mail-server/aws-sendmail/db.ts') diff --git a/services/docker/mail-server/aws-sendmail/db.ts b/services/docker/mail-server/aws-sendmail/db.ts index 6a7b100..e239e72 100644 --- a/services/docker/mail-server/aws-sendmail/db.ts +++ b/services/docker/mail-server/aws-sendmail/db.ts @@ -72,7 +72,14 @@ export class DbService { private _migrator; constructor(public readonly path: string) { - this._sqlocal = new SQLocalKysely("database.sqlite3"); + this._sqlocal = new SQLocalKysely({ + databasePath: path, + onInit: (sql) => [ + // Though this can be executed only once when database is + // created, re-calls should not affect performance. + sql`PRAGMA journal_mode=WAL;`, + ], + }); const db = new Kysely({ dialect: this._sqlocal.dialect }); this._db = db; this._migrator = new Migrator({ -- cgit v1.2.3