nx_sqlite_rows.nx

nx_sqlite_rows.nx -- SOVEREIGN SQLite ROW READER (rung 2) + seg-store PLANE LANDER. RUNG 1 (_hdl_build/_sqlite_read_authored.nx) walks the b-tree and decodes sqlite_master, and declares its own honest limit: "local payload only -- overflow pages not followed yet ... full row/column reads = rung 2". THIS IS RUNG 2: full row+column reads WITH the overflow-page chain, so any row of any size comes out byte-exact. WHY (2026-07-23, F916 re-aimed by the F1010 SOTA reframe): the legacy Elder platform's knowledge lives in SQLite (content.db 390MB: outfits/poses/locations rule mesh + 200k-row batch_history). It is NOT ported as a runtime rule engine (measured: prompt words cap at ~85% semantics / 50% geometry / 0% identity) -- it is MINED AS A DATASET: an L1 semantic prior + a learning corpus + an eval set. This organ is the sovereign read path for that mine. READ-ONLY: it never writes to the SQLite file. VERBS tables <db> list tables: name, rootpage, rows rows <db> <table> [max] dump rows TSV-ish (NULL=\N, tab/nl/backslash escaped) plane <db> <table> <store-prefix> land rows into a seg-store plane, ONE segment per table: key <table>:<rowid> -> canonical NXR1 record (absent field == SQL NULL, so NULL survives losslessly), plus <table>:meta selftest gate, verdict=GREEN|RED ENVELOPE (declared, never silent): row payload cap 8MiB · <=256 cols · REAL rendered to 3 decimals (out-of-range -> x<hex>, never a wrong number) · BLOBs emitted raw (embedded NUL truncates a plane value -- text/int tables are the target; blob-safe values = a later rung) · a table lands in ONE segment (writer cap 128MiB). NOTE (DRY): sqr_rec_field duplicates mv_rec_field's NXR1 walk (2nd copy; at a 3rd, extract to a lib). license_tier: ORIGINAL Read-only, no hw writes (Rule 26).