"upsert" meaning in All languages combined

{
  "etymology_templates": [
    {
      "args": {
        "1": "en",
        "2": "update",
        "3": "insert"
      },
      "expansion": "Blend of update + insert",
      "name": "blend"
    }
  ],
  "etymology_text": "Blend of update + insert.",
  "forms": [
    {
      "form": "upserts",
      "tags": [
        "present",
        "singular",
        "third-person"
      ]
    },
    {
      "form": "upserting",
      "tags": [
        "participle",
        "present"
      ]
    },
    {
      "form": "upserted",
      "tags": [
        "participle",
        "past"
      ]
    },
    {
      "form": "upserted",
      "tags": [
        "past"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "upsert (third-person singular simple present upserts, present participle upserting, simple past and past participle upserted)",
      "name": "en-verb"
    }
  ],
  "lang": "English",
  "lang_code": "en",
  "pos": "verb",
  "senses": [
    {
      "categories": [
        {
          "kind": "topical",
          "langcode": "en",
          "name": "Databases",
          "orig": "en:Databases",
          "parents": [
            "Computing",
            "Technology",
            "All topics",
            "Fundamental"
          ],
          "source": "w"
        },
        {
          "_dis": "52 48",
          "kind": "other",
          "name": "English entries with incorrect language header",
          "parents": [
            "Entries with incorrect language header",
            "Entry maintenance"
          ],
          "source": "w+disamb"
        },
        {
          "_dis": "53 47",
          "kind": "other",
          "name": "Pages with 1 entry",
          "parents": [],
          "source": "w+disamb"
        },
        {
          "_dis": "54 46",
          "kind": "other",
          "name": "Pages with entries",
          "parents": [],
          "source": "w+disamb"
        }
      ],
      "examples": [
        {
          "ref": "2020, Adam Bellemare, Building Event-Driven Microservices, O'Reilly, →ISBN, page 25:",
          "text": "Each entity event is upserted into the key/value table, such that the most recently read event for a given key is represented.",
          "type": "quote"
        }
      ],
      "glosses": [
        "To insert rows into a database table if they do not already exist, or update them if they do."
      ],
      "id": "en-upsert-en-verb-Tor1zUOe",
      "links": [
        [
          "database",
          "database"
        ],
        [
          "insert",
          "insert"
        ],
        [
          "row",
          "row"
        ],
        [
          "table",
          "table"
        ],
        [
          "update",
          "update"
        ]
      ],
      "raw_glosses": [
        "(databases, transitive) To insert rows into a database table if they do not already exist, or update them if they do."
      ],
      "tags": [
        "transitive"
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ]
    }
  ],
  "word": "upsert"
}

{
  "etymology_templates": [
    {
      "args": {
        "1": "en",
        "2": "update",
        "3": "insert"
      },
      "expansion": "Blend of update + insert",
      "name": "blend"
    }
  ],
  "etymology_text": "Blend of update + insert.",
  "forms": [
    {
      "form": "upserts",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "upsert (plural upserts)",
      "name": "en-noun"
    }
  ],
  "lang": "English",
  "lang_code": "en",
  "pos": "noun",
  "senses": [
    {
      "categories": [
        {
          "kind": "topical",
          "langcode": "en",
          "name": "Databases",
          "orig": "en:Databases",
          "parents": [
            "Computing",
            "Technology",
            "All topics",
            "Fundamental"
          ],
          "source": "w"
        },
        {
          "_dis": "58 42",
          "kind": "other",
          "name": "English blends",
          "parents": [],
          "source": "w+disamb"
        },
        {
          "_dis": "52 48",
          "kind": "other",
          "name": "English entries with incorrect language header",
          "parents": [
            "Entries with incorrect language header",
            "Entry maintenance"
          ],
          "source": "w+disamb"
        },
        {
          "_dis": "53 47",
          "kind": "other",
          "name": "Pages with 1 entry",
          "parents": [],
          "source": "w+disamb"
        },
        {
          "_dis": "54 46",
          "kind": "other",
          "name": "Pages with entries",
          "parents": [],
          "source": "w+disamb"
        }
      ],
      "examples": [
        {
          "ref": "2013, David Hows, Eelco Plugge, Peter Membrey, Tim Hawkins, The Definitive Guide to MongoDB, Apress, →ISBN, page 66:",
          "text": "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.",
          "type": "quote"
        }
      ],
      "glosses": [
        "An operation that inserts rows into a database table if they do not already exist, or updates them if they do."
      ],
      "id": "en-upsert-en-noun-YXcJ72Y0",
      "links": [
        [
          "database",
          "database"
        ],
        [
          "insert",
          "insert"
        ],
        [
          "row",
          "row"
        ],
        [
          "table",
          "table"
        ],
        [
          "update",
          "update"
        ]
      ],
      "raw_glosses": [
        "(databases) An operation that inserts rows into a database table if they do not already exist, or updates them if they do."
      ],
      "synonyms": [
        {
          "word": "merge"
        }
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ]
    }
  ],
  "word": "upsert"
}

{
  "categories": [
    "English blends",
    "English countable nouns",
    "English entries with incorrect language header",
    "English lemmas",
    "English nouns",
    "English verbs",
    "Pages with 1 entry",
    "Pages with entries"
  ],
  "etymology_templates": [
    {
      "args": {
        "1": "en",
        "2": "update",
        "3": "insert"
      },
      "expansion": "Blend of update + insert",
      "name": "blend"
    }
  ],
  "etymology_text": "Blend of update + insert.",
  "forms": [
    {
      "form": "upserts",
      "tags": [
        "present",
        "singular",
        "third-person"
      ]
    },
    {
      "form": "upserting",
      "tags": [
        "participle",
        "present"
      ]
    },
    {
      "form": "upserted",
      "tags": [
        "participle",
        "past"
      ]
    },
    {
      "form": "upserted",
      "tags": [
        "past"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "upsert (third-person singular simple present upserts, present participle upserting, simple past and past participle upserted)",
      "name": "en-verb"
    }
  ],
  "lang": "English",
  "lang_code": "en",
  "pos": "verb",
  "senses": [
    {
      "categories": [
        "English terms with quotations",
        "English transitive verbs",
        "en:Databases"
      ],
      "examples": [
        {
          "ref": "2020, Adam Bellemare, Building Event-Driven Microservices, O'Reilly, →ISBN, page 25:",
          "text": "Each entity event is upserted into the key/value table, such that the most recently read event for a given key is represented.",
          "type": "quote"
        }
      ],
      "glosses": [
        "To insert rows into a database table if they do not already exist, or update them if they do."
      ],
      "links": [
        [
          "database",
          "database"
        ],
        [
          "insert",
          "insert"
        ],
        [
          "row",
          "row"
        ],
        [
          "table",
          "table"
        ],
        [
          "update",
          "update"
        ]
      ],
      "raw_glosses": [
        "(databases, transitive) To insert rows into a database table if they do not already exist, or update them if they do."
      ],
      "tags": [
        "transitive"
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ]
    }
  ],
  "word": "upsert"
}

{
  "categories": [
    "English blends",
    "English countable nouns",
    "English entries with incorrect language header",
    "English lemmas",
    "English nouns",
    "English verbs",
    "Pages with 1 entry",
    "Pages with entries"
  ],
  "etymology_templates": [
    {
      "args": {
        "1": "en",
        "2": "update",
        "3": "insert"
      },
      "expansion": "Blend of update + insert",
      "name": "blend"
    }
  ],
  "etymology_text": "Blend of update + insert.",
  "forms": [
    {
      "form": "upserts",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "upsert (plural upserts)",
      "name": "en-noun"
    }
  ],
  "lang": "English",
  "lang_code": "en",
  "pos": "noun",
  "senses": [
    {
      "categories": [
        "English terms with quotations",
        "en:Databases"
      ],
      "examples": [
        {
          "ref": "2013, David Hows, Eelco Plugge, Peter Membrey, Tim Hawkins, The Definitive Guide to MongoDB, Apress, →ISBN, page 66:",
          "text": "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.",
          "type": "quote"
        }
      ],
      "glosses": [
        "An operation that inserts rows into a database table if they do not already exist, or updates them if they do."
      ],
      "links": [
        [
          "database",
          "database"
        ],
        [
          "insert",
          "insert"
        ],
        [
          "row",
          "row"
        ],
        [
          "table",
          "table"
        ],
        [
          "update",
          "update"
        ]
      ],
      "raw_glosses": [
        "(databases) An operation that inserts rows into a database table if they do not already exist, or updates them if they do."
      ],
      "synonyms": [
        {
          "word": "merge"
        }
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ]
    }
  ],
  "word": "upsert"
}