Function configureDatabaseConnection

packages/core/src/db/db-core.ts:82–103

(database: IDatabase)

}

async function configureDatabaseConnection(database: IDatabase): Promise<void> {
  try {
    await database.execute("PRAGMA journal_mode = WAL");
  } catch {
    // Some adapters may not support WAL mode changes
  }
  try {
    await database.execute("PRAGMA synchronous = NORMAL");
  } catch {
    // Some adapters may not support synchronous mode changes
  }
  try {
    await database.execute("PRAGMA foreign_keys = ON");
  } catch {
    // Some adapters may not support PRAGMA configuration
  }
  try {
    await database.execute("PRAGMA busy_timeout = 15000");
  } catch {
    // Some adapters may not support PRAGMA configuration
  }
}

export async function cleanupOrphanedSyncRows(databaseArg?: IDatabase): Promise<void> {
  const database = databaseArg ?? (await getDB());