undefined | Better HN

0 pointspas8mo ago0 comments

update already means overwriting.

semantically PUT is exactly upsert.

upsert is update + create if not exists, which is exactly PUT

any update without overwrite is "append" or "extend" (or something else)

0 comments

eggn00dles8mo ago

append or extend is adding keys without updating existing keys. update can add keys and update existing keys.

put will blow away existing keys if they dont exist in the new payload. which is why it cant be upsert.

pasOP8mo ago

... it depends on how the given server defines PUT of course (also how we define upsert, and does upsert make sense outside a DB setting? well, of course some DBs have a HTTP/ReST API.)

that said, usually PUT is meaningful for a URL (or URI), and in these circumstances it's like upsert, and it cannot blow away other keys, as it operates on one key, given by the URL

of course if we assume a batch endpoint, sure, it then can do non-upsert-like things

j / k navigate · click thread line to collapse