aboutsummaryrefslogtreecommitdiffhomepage
path: root/test/reference/abstraction/two_bits.christopher_kelty.en.ssp
diff options
context:
space:
mode:
authorRalph Amissah <ralph.amissah@gmail.com>2026-09-07 09:48:09 -0400
committerRalph Amissah <ralph.amissah@gmail.com>2026-09-09 17:13:49 -0400
commitb7601fc599d7c30650f008a5ab8aca5796d6edad (patch)
treeb567dc3d359ad8fde594ddd0c39c54923c9d5d5e /test/reference/abstraction/two_bits.christopher_kelty.en.ssp
parentsqlite db abstraction: make readable as read-only (diff)
ocda db: structural fields (arrays as JSON)
Added the structure ocda was extended to compute as JSON arrays (a column each). JSON arrays, allows SQL can reach inside them (with CHECK(json_valid()) on each) select ocn from objects where json_extract(ancestors,'$[4]') = 9; select ocn from objects where json_array_length(children) > 3; ancestors and table_widths change format for this reason; nothing outside spine reads the file yet, and metadata now records what it is: schema.name, schema.version, source.filename, source.language. INTEGER PRIMARY KEY in place of AUTOINCREMENT, which was paying for a guarantee not needed here and creating sqlite_sequence, and UNIQUE(section, seq), which is the table's actual key. Note for anyone editing this file: the schema is a D string handed to sqlite, so comments inside it must be SQL comments. A D /+ +/ comment there aborts the statement and leaves the table missing, silently. (assisted by Claude-Code)
Diffstat (limited to 'test/reference/abstraction/two_bits.christopher_kelty.en.ssp')
0 files changed, 0 insertions, 0 deletions