Top "Upsert" questions

For issues relating to performing upsert (combination update/insert) operations.

How to update and upsert multiple documents in MongoDB using C# Drivers

I am using MongoDB 2, and I want to update multiple documents and upsert a value like processed:true into the …

mongodb upsert
Bulk insert, update if on conflict (bulk upsert) on Postgres

I am writing a data-mining program, which bulk inserts user data. The current SQL is just a plain bulk insert: …

sql postgresql upsert
Fast or Bulk Upsert in pymongo

How can I do a bulk upsert in pymongo? I want to Update a bunch of entries and doing them …

python mongodb pymongo upsert nosql
MongoDB: Update/Upsert vs Insert

Recently I notice a huge performance difference between doing multiple upserts (via bulk operations) vs an insert (multiple documents). I …

mongodb mongodb-query upsert
Elasticsearch upserting and appending to array

I'm trying to write a script that will upsert a new user record to ElasticSearch, updating any information if the …

elasticsearch upsert
Upsert in Rails ActiveRecord

Does ActiveRecord have a built-in upsert functionality? I know I could write it myself but I obviously don't want to …

ruby-on-rails activerecord upsert
Entity Framework - UPSERT on unique indexes

I searched a bit regarding my problem but can't find anything that really to help. So my problem/dilema stays …

c# sql entity-framework upsert
Node.js MongoDB Upsert update

I'm writing a little application which scores keywords. So if "beirut" and "education" get entered in, if they haven't been …

node.js mongodb upsert
MERGE syntax used to UPSERT or INSERT on duplicate UPDATE

So I'm coming from MySQL where I could do INSERT on DUPLICATE UPDATE: INSERT INTO table (a,b,c) VALUES (1,2,3) …

postgresql upsert sql
MySQL behavior of ON DUPLICATE KEY UPDATE for multiple UNIQUE fields

From MySQL 4.1.0 onwards, it is possible to add ON DUPLICATE KEY UPDATE statement to specify behavior when values inserted (with …

mysql sql-update sql-insert upsert