Dexie cloud: partial updates via REST API

[dusty-phillips]

Can it be possible to do a "patch" style request to a REST endpoint? The only update mechanism right now appears to be a full upsert, where you have to include all of the object's fields.

This means that to do an update, you need to first GET, and then POST the entire updated value. Because these don't happen atomically, this can create a problematic race condition if the UI pushes other updates to the object between the GET and POST that get obliterated.

(TBH, I'm pretty sure the correct answer here is "Dusty stop abusing the REST endpoints.")

[dfahlander]

That would probably be an alternative to #2003 I suppose. Sorry I have been very busy with the YJS support and all smaller FRs have stood back, but now that the YJS support is feature complete and under testing I hope to fix this quite soon. Would a PATCH request eliminate your need for transaction support? I also have another requirement to document the sync end point or enhance it so that it could be used from a node client (#2065). This would make it possible to to transactions but probably a bit more verbose to use.

[dusty-phillips]

I forgot about that. 😂 at least I am consistent.

I don’t think a patch would solve the problem defined in that ticket because it was a multi-table transaction. A transaction would solve the problem in this one, though.

Documenting and using the sync endpoint might be helpful, but I suspect the push/pull nature would be weird since the node service represents multiple users. I don’t want to have to wait to pull the entire db for a user in order to push one change to it. But if I can just somehow inject a patch into it in a safe transaction it’d be cool.

Crazy random thought: what if ssr based frameworks could sync the user’s db seamlessly on client and server? 😵‍💫

[dfahlander]

Yes, the sync end point would need support for some other use cases than what it's tailored for currently. I'd like to cherry pick the consistency features of it without having to sync entire realms or dbs.