Function readDatabase

apps/desktop/src/main/databases.ts:188–215

(root: string, rel: string)

 * stable `id` (one-time migration when opening a plain CSV as a database).
 */
export async function readDatabase(root: string, rel: string): Promise<DatabaseDoc> {
  const csvAbs = databaseDataPath(root, rel)
  let csvText: string
  try {
    csvText = await fs.readFile(csvAbs, 'utf8')
  } catch (err) {
    if (isMissing(err)) throw new Error(`Database not found: ${rel}`)
    throw err
  }

  const existing = await readSidecar(root, rel)
  if (existing) {
    const rows = parseRows(csvText, existing.fields, existing.idFieldId, randomUUID)
    const pageHasContent = await readPageContentFlags(root, existing.pages)
    return hydrate(rel, existing, rows, pageHasContent)
  }

  // Adopt a plain CSV: infer + materialize.
  const grid = parseCsv(csvText)
  const headers = grid[0] ?? []
  const { fields, idFieldId } = inferFields(headers, grid.slice(1, 1 + SCHEMA_SAMPLE_ROWS), randomUUID)
  const { views, activeViewId } = buildDefaultViews(fields, randomUUID)
  const sidecar: DatabaseSidecar = { version: 1, idFieldId, fields, views, activeViewId }
  const rows = parseRows(csvText, fields, idFieldId, randomUUID)
  await persistSidecar(root, rel, sidecar)
  await writeFileAtomic(csvAbs, serializeRows(rows, fields)) // canonicalize + persist ids
  return hydrate(rel, sidecar, rows)
}

/** Persist rows to the CSV (schema/header come from the sidecar). */
export async function writeDatabaseRows(