Class ElectronSQLiteStorageAdapter

examples/electron/offline-first/src/db/todos.ts:37–73

* SQLite-backed storage adapter for the offline transactions outbox. * Stores pending mutations in the main process SQLite database via IPC, * so they survive app restarts (unlike IndexedDB in Electron).

 * so they survive app restarts (unlike IndexedDB in Electron).
 */
class ElectronSQLiteStorageAdapter implements StorageAdapter {
  private prefix: string

  constructor(prefix = 'offline-tx:') {
    this.prefix = prefix
  }

  private prefixedKey(key: string): string {
    return `${this.prefix}${key}`
  }

  async get(key: string): Promise<string | null> {
    return window.electronAPI.kv.get(this.prefixedKey(key))
  }

  async set(key: string, value: string): Promise<void> {
    await window.electronAPI.kv.set(this.prefixedKey(key), value)
  }

  async delete(key: string): Promise<void> {
    await window.electronAPI.kv.delete(this.prefixedKey(key))
  }

  async keys(): Promise<Array<string>> {
    const allKeys = await window.electronAPI.kv.keys()
    return allKeys
      .filter((k) => k.startsWith(this.prefix))
      .map((k) => k.slice(this.prefix.length))
  }

  async clear(): Promise<void> {
    const keys = await this.keys()
    for (const key of keys) {
      await window.electronAPI.kv.delete(this.prefixedKey(key))
    }
  }
}

/**
 * Fetch with retry and exponential backoff.