Snapshot.content: TEXT | BLOB | JSON

[samuelstroschein]

Context

Snapshotting text is valuable:

• csv saving row changes is text
• markdown entire file snapshots are text

snapshot.content = "Lisa,5" 

Plugins have to do a workaround atm

snapshot.content = { text: "Lisa,5" }

Proposal

Evaluate defining a snapshot (schema) as type: "text" | "blob" | "json"

Pros

• higher DX it feels intuitive to snapshot text if it is text
• tiny bit less storage space
• slightly better performance by not requiring json serialization and parsing

Cons

• dynamic column types (sqlite has no problem dynamic column types)