Prototype semantic schemas and create tables from templates #39

Merged

michielbdejong merged 1 commit from codex/semantic-template-catalog into main 2026-10-16 16:36:38 +02:00

Conversation 0 Commits 1 Files changed -

michielbdejong commented 2026-10-14 15:22:02 +02:00

Owner

Copy link

Draft experiment for the content-addressed semantic-definition counterproposal on https://github.com/ontola/atomic-server/issues/2243#issuecomment-6168088161. Atomic Server work is postponed; this PR changes database-apps only.

Adds db-table-editor-templates: a Create from template picker covering all 14 Atomic Server table starting points, with native row editing, search, sorting, table switching, schema download, and persistence through NextGraph. Repeated installations share semantic Property, Class, Tag and Ontology IDs while table names, storage pointers and row membership remain local.

The experimental BLAKE3 format hashes normative descriptions, datatypes, representations/units, and Class field contracts including requiredness, cardinality and enum references. It excludes drives, ownership and presentation. Definitions and reference closure are verified before runtime shape construction with defineShape. Complete snapshots live in native discrete documents and are verified through a fresh read before their RDF discovery records become visible; reload uses the stored snapshot rather than a newer catalog. The original upstream declarations, commit provenance and MIT license are bundled, and CI checks deterministic generation.

Try it:

pnpm db-app-runner db-table-editor-templates

This is an experimental identity protocol, not official Atomic Server schema support. Normative descriptions and equivalence decisions need review. It supplies data schemas in the existing grid; upstream boards, calendars, timers, computed columns/totals, file upload and integrations are not implemented. Definition editing/migration, recursive Class addressing, plugin registration and cross-user/broker sync proof remain follow-up work. Existing expense/task predicates and tables are not migrated.

Validation: 277 unit tests passed, including the real offline NextGraph WASM verifier's schema-document and RDF record persistence checks; all four template browser tests passed without retries, covering creation/editing of every template, same-type table isolation, reloads, validation, narrow screens and corrupted-schema rejection. Runtime type checking, the final Template Tables production build, and deterministic artifact generation passed. Full broker/wallet browser suites await CI.

Design, storage details and limitations: docs/semantic-templates.md.

Desktop preview:

Mobile previews

Draft experiment for the content-addressed semantic-definition counterproposal on https://github.com/ontola/atomic-server/issues/2243#issuecomment-6168088161. Atomic Server work is postponed; this PR changes database-apps only. Adds `db-table-editor-templates`: a Create from template picker covering all 14 Atomic Server table starting points, with native row editing, search, sorting, table switching, schema download, and persistence through NextGraph. Repeated installations share semantic Property, Class, Tag and Ontology IDs while table names, storage pointers and row membership remain local. The experimental BLAKE3 format hashes normative descriptions, datatypes, representations/units, and Class field contracts including requiredness, cardinality and enum references. It excludes drives, ownership and presentation. Definitions and reference closure are verified before runtime shape construction with defineShape. Complete snapshots live in native discrete documents and are verified through a fresh read before their RDF discovery records become visible; reload uses the stored snapshot rather than a newer catalog. The original upstream declarations, commit provenance and MIT license are bundled, and CI checks deterministic generation. Try it: ```sh pnpm db-app-runner db-table-editor-templates ``` This is an experimental identity protocol, not official Atomic Server schema support. Normative descriptions and equivalence decisions need review. It supplies data schemas in the existing grid; upstream boards, calendars, timers, computed columns/totals, file upload and integrations are not implemented. Definition editing/migration, recursive Class addressing, plugin registration and cross-user/broker sync proof remain follow-up work. Existing expense/task predicates and tables are not migrated. Validation: 277 unit tests passed, including the real offline NextGraph WASM verifier's schema-document and RDF record persistence checks; all four template browser tests passed without retries, covering creation/editing of every template, same-type table isolation, reloads, validation, narrow screens and corrupted-schema rejection. Runtime type checking, the final Template Tables production build, and deterministic artifact generation passed. Full broker/wallet browser suites await CI. Design, storage details and limitations: `docs/semantic-templates.md`. Desktop preview:  <details> <summary>Mobile previews</summary>   </details>

template-picker-mobile.png

56 KiB

template-picker-desktop.png

116 KiB

template-table-mobile.png

38 KiB

michielbdejong added 1 commit 2026-10-14 15:22:02 +02:00

Prototype semantic content-addressed schemas and table template creation 571a21c455

michielbdejong referenced this pull request 2026-10-15 13:33:55 +02:00

Follow-up: coordinate ontology, schema evolution, lenses and headless webhooks #47

michielbdejong added 5 commits 2026-10-16 16:32:40 +02:00

Add Lenses app for Atomic mappings and collection correspondences 23c6056f1c

Trim trailing blank line in vendored lens fixtures eec6b7ebb2

Merge remote-tracking branch 'origin/codex/lenses-app' into codex/merge-open-prs ... 274ba9ea74

# Conflicts:
#	README.md
#	playwright.config.ts

Merge remote-tracking branch 'origin/codex/semantic-template-catalog' into codex/merge-open-prs ... 5ae0cc1c2b

# Conflicts:
#	playwright.config.ts

Align template saves and browser controls with the shared table API 86e5033f87

michielbdejong changed title from [WIP] Prototype semantic schemas and create tables from templates to Prototype semantic schemas and create tables from templates 2026-10-16 16:33:03 +02:00

michielbdejong added 1 commit 2026-10-16 16:36:28 +02:00

Record template PR integration already included in main 24d6323cf5

michielbdejong merged commit 5ede77dcd2 into main 2026-10-16 16:36:38 +02:00

michielbdejong referenced this pull request from a commit 2026-10-16 16:36:40 +02:00

Merge pull request 'Prototype semantic schemas and create tables from templates' (#39) from codex/semantic-template-catalog into main

Sign in to join this conversation.

Reviewers

No reviewers

Labels

Clear labels

No items

No labels

Milestone

Clear milestone

No items

No milestone

Projects

Clear projects

No items

No project

Assignees

Clear assignees

No assignees

1 participant

Notifications

Subscribe

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

ELFA/database-apps!39

No description provided.