ocda db: full text index and three views

An FTS5 virtual table over the object text, external content
(content='objects', content_rowid='id') so the text is not stored
twice, built from the rows once they are written. This is per
document, for exploring one abstraction; the collection wide
search database is a separate thing and is unaffected.

  SELECT o.ocn, o.text FROM objects_fts f JOIN objects o ON o.id=f.rowid
    WHERE f.text MATCH 'mercatoria';

War and Peace, 12,135 objects: 100 full text queries in 0.23s
including 100 process starts, 400 hits for Napoleon.

Three views name the shapes worth asking for, so that datasette or
anyone opening the file finds them without writing SQL:
  outline (headings with their levels and interval),
  citable (ocn > 0),
  document_files (what the file carries).

Over the document sample the index size is/adds about a quarter
that of the files.

(assisted by Claude-Code)

0 files changed, 0 insertions, 0 deletions