exportSqlite method

Future<void> exportSqlite(
  1. String path, {
  2. int pageSize = 4096,
  3. bool includeIndexes = true,
})

Write every local table (excluding sqlite_* shadow tables) to a real SQLite-format database file at path. The resulting file is readable by package:sqlite3 and the official sqlite3 CLI, including all rows and any non-expression, non-partial single-column indexes.

Columns whose declared type is BLOB keep their bytes; everything else is stored using SQLite's natural serial types (INT / REAL / TEXT / NULL). Booleans are stored as 0/1 integers.

Implementation

Future<void> exportSqlite(
  String path, {
  int pageSize = 4096,
  bool includeIndexes = true,
}) async {
  final bytes = _buildSqliteBytes(
    pageSize: pageSize,
    includeIndexes: includeIndexes,
  );
  await _atomicWriteBytes(path, bytes);
}