{"id":"unbundled-db-flush-required-for-derived","text":"Derived systems (secondary indexes, materialized views, full-text search) only see mutations after `db.flush()` is called; writes go to WAL and storage immediately but CDC consumers are decoupled.","truth_value":"IN","source":"entries/2026/05/29/unbundled-database-test_unbundled_database.md","source_url":"","source_hash":"","justifications":[],"dependents":["derived-system-consistency-requires-flush-and-old-values"],"metadata":{"example":"def flush(self):\n    for event in self._pending_events:\n        for view in self._derived_views:\n            view.apply(event)\n    self._pending_events.clear()"},"created_at":"","updated_at":"","reviewed_at":"","verified_at":"","retracted_at":"","explanation":{"steps":[{"node":"unbundled-db-flush-required-for-derived","truth_value":"IN","reason":"premise"}]}}