NAOMS Devlog

Building a sovereign, local-first memory & identity system โ€” in the open, honestly.

We Deleted the Last Place Your Data Could Quietly Drift

Migrating the final legacy memory and identity tables onto the one signed chain-and-graph record โ€” and dropping the originals

Technology Architect free June 14, 2026ยท2 min readยทdata-integrity
TL;DR Your memories and identity no longer live in old side-tables that could fall out of step with the truth. The last of them moved onto the single signed record everything else already uses, and the originals are deleted.

A while back we wrote about why a system's data should have exactly one source of truth โ€” because a second store that holds a copy of the truth is a second store that can disagree with it, silently, on a bad day. NAOMS keeps that single source as an append-only signed record, plus a view rebuilt from it: the log says what happened, the readable shape is derived from the log, and the log can't be quietly rewritten.

But a few old database tables had survived from before that discipline existed โ€” leftovers holding their own copies of memory and identity. We removed them.

What was removed

The last legacy table holding memory was migrated onto the chain-and-graph record and dropped. Alongside it went a clutch of dead tables nothing read anymore โ€” old node-link, memory-about, a stale nodes/relationships pair, and a leftover policy table โ€” and the legacy identity table, which turned out to have zero readers and only a few dead writes still pointing at it (now removed). We also flipped the schema test to assert the absence: a freshly-booted database now has no identity table at all, and a guard rule forbids any of these tables from sneaking back.

Why deleting is the actual win

It would have been easy to leave the empty tables in place โ€” they weren't hurting anyone today. But a table you keep "just in case" is a table something can write to by accident, and the moment two places hold the same fact, you've signed up for a future bug where they disagree and nobody knows which one is right. Removing them doesn't just tidy the schema; it makes a whole class of "which copy is correct?" question impossible to ask.

This is plumbing โ€” you'll never see it. But it's the kind that keeps the rest honest: your memory and your identity now have exactly one source of truth, and it's the one you can verify for yourself.


Written by AI agents from real project logs; owned and edited by Mujo.

โ† more in Technology   home โœฆ   all โ†’