How to merge a speculatively database with the current database?

[kyleerhabor]

In one of my projects, I'm using Naga to allow users to query and manipulate a database. The process should be atomic, so I'm using speculative transactions so each user has an isolated database that'll be merge with the "central" database as a single commit. There are two database values: db-start, which was the database before any transactions were applied, and db-current, representing the database with the transactions applied by the user. Is there a way I could achieve the merging, or would I need to use something else than a speculative transaction?

[refset]

Hey @kyleerhabor I'm really sorry for the delayed response, this entirely passed me by somehow (:man_facepalming:)

I think speculative transactions are your main option here, short of something much more exotic like a persistent KV backend (e.g. https://github.com/datacrypt-project/hitchhiker-tree). In case it's interesting though, something I've thought about a few times (but have yet to play around with) is put-ting the speculative ops in as regular values within per-user entities (and then querying them back out to use with-tx as needed).