Hello, you have come here looking for the meaning of the word
upsert. In DICTIOUS you will not only get to know all the dictionary meanings for the word
upsert, but we will also tell you about its etymology, its characteristics and you will know how to say
upsert in singular and plural. Everything you need to know about the word
upsert you have here. The definition of the word
upsert will help you to be more precise and correct when speaking or writing your texts. Knowing the definition of
upsert, as well as those of other words, enriches your vocabulary and provides you with more and better linguistic resources.
English
Etymology
Blend of update + insert.
Verb
upsert (third-person singular simple present upserts, present participle upserting, simple past and past participle upserted)
- (databases, transitive) To insert rows into a database table if they do not already exist, or update them if they do.
2020, Adam Bellemare, Building Event-Driven Microservices, O'Reilly, →ISBN, page 25:Each entity event is upserted into the key/value table, such that the most recently read event for a given key is represented.
Noun
upsert (plural upserts)
- (databases) An operation that inserts rows into a database table if they do not already exist, or updates them if they do.
- Synonyms: (SQL standard) merge, upsertion
2013, David Hows, Eelco Plugge, Peter Membrey, Tim Hawkins, The Definitive Guide to MongoDB, Apress, →ISBN, page 66:The upsert
option lets you specify whether the update should be an upsert—that is, it tells MongoDB to update the record if it exists, and create it if it doesn't.
Anagrams