diff options
| author | Ralph Amissah <ralph.amissah@gmail.com> | 2026-09-07 09:48:09 -0400 |
|---|---|---|
| committer | Ralph Amissah <ralph.amissah@gmail.com> | 2026-09-09 17:13:49 -0400 |
| commit | b7601fc599d7c30650f008a5ab8aca5796d6edad (patch) | |
| tree | b567dc3d359ad8fde594ddd0c39c54923c9d5d5e /test | |
| parent | sqlite 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')
0 files changed, 0 insertions, 0 deletions
