Features 03 — Kagadmodyaa

Inside Ostrich

Everything a database does, in a file you can open.

Branch your database like code.
Every pull request gets its own copy of the data and its own schema. Review the migration as a diff, then merge it.
- mainproduction212 notes
- pr-482add note tags212 notes, +1 column
- pr-479fix owner index212 notes
- pr-475seed demo data1,040 notes
```
  -- 0042_note_tags.sql  + alter table notes add column tags text[];+ update notes set tags = '{}' where tags is null;+ create index notes_tags on notes using gin (tags);  - drop index notes_owner_old;
```
- Migration applies cleanly to a copy of main
- 212 rows read back unchanged
- Slowest query: 0.9 ms, was 0.8 ms
Checks passed
Queries that stay under a millisecond.
The engine runs inside your process, so there is no network between a question and its answer.
Go back to any minute.
Every write is logged. Restore the whole file to how it was at 14:32.

Generate them once. A renamed column fails the build, not the page.

// generated from schema.sql
const note = await db.notes.get(41)

note.title   // string
note.tags    // string[] | null
note.edited  // Date