snapshots blobs / snapshots are dynamic tables

[samuelstroschein]

Context

Change control benefits from being able to save binary data.

• storing an asset like an image is a binary

• (future) change controlling lix plugins and apps will likely happen via a zip

• file.metadata is a JSON Binary. Storing it in the change table requires parsing the json to a string to store it in the change table which eliminates the benefits of using jsonb in the first place.

Proposal

Come up with a way to support snapshotting whatever is needed (text, json, blob).

[samuelstroschein]

A potential solution would be to let schema_key be it's own/virtual table. Any props can then be defined as desired.