Function createDatabase

apps/desktop/src/main/databases.ts:253–296

(
  root: string,
  folder: NoteFolder,
  subpath: string,
  title?: string
)

 * vault root rather than inventing an `inbox/` directory.
 */
export async function createDatabase(
  root: string,
  folder: NoteFolder,
  subpath: string,
  title?: string
): Promise<DatabaseDoc> {
  const safeTitle = (title ?? 'Untitled Database').trim() || 'Untitled Database'
  const baseName = safeTitle.replace(/[\\/:*?"<>|]/g, '-')
  const topAbs = await folderRoot(root, folder)
  const cleanSub = toPosix(subpath).replace(/^\/+|\/+$/g, '')
  const dirAbs = cleanSub ? path.join(topAbs, cleanSub) : topAbs
  const dirRel = toPosix(path.relative(root, dirAbs))
  const makeFormDir = (name: string): string =>
    dirRel ? `${dirRel}/${name}${FORM_DIR_SUFFIX}` : `${name}${FORM_DIR_SUFFIX}`
  // Resolve a non-colliding `<Name>.base` folder under the directory.
  let formDirRel = makeFormDir(baseName)
  let n = 2
  for (;;) {
    try {
      await fs.access(databaseDataPath(root, formDirRel))
      formDirRel = makeFormDir(`${baseName} ${n++}`)
    } catch {
      break
    }
  }
  const rel = csvPathForFormDir(formDirRel)

  const idField: DbField = { id: randomUUID(), name: 'id', type: 'text', hidden: true }
  const nameField: DbField = { id: randomUUID(), name: 'Name', type: 'text' }
  const fields = [idField, nameField]
  const { views, activeViewId } = buildDefaultViews(fields)
  const sidecar: DatabaseSidecar = {
    version: 1,
    idFieldId: idField.id,
    fields,
    views,
    activeViewId
  }
  // Create the folder, then the two data files.
  await fs.mkdir(databaseDataPath(root, formDirRel), { recursive: true })
  await persistSidecar(root, rel, sidecar)
  await writeFileAtomic(databaseDataPath(root, rel), serializeRows([], fields))
  return hydrate(rel, sidecar, [])
}

/**
 * Create a "page" note for a database record inside the database folder