Top "Upsert" questions

How to update or insert on Sequel dataset?

I just started using Sequel in a really small Sinatra app. Since I've got only one DB table, I don't …

ruby upsert sequel

get mongodb _id object after upsert with php

is it possible to get the new/updated _id after the query? example code: $key = array( 'something' => 'unique' ); $data = …

php mongodb upsert

Bulk upsert with SQLAlchemy

I am working on bulk upserting lots of data into PostgreSQL with SQLAlchemy 1.1.0b, and I'm running into duplicate key …

python postgresql sqlalchemy upsert

If Record Exists, Update Else Insert

I'm trying to move some data between two SQL Server 2008 tables. If the record exists in Table2 with the email …

sql sql-server sql-server-2008 merge upsert

mongodb - create doc if not exist, else push to array

I have a document in the following form: { "_id" : ObjectId("4d2d8deff4e6c1d71fc29a07"), "user_id" : "714638…

arrays mongodb upsert

How to update all columns with INSERT ... ON CONFLICT ...?

I have a table with a single primary key. When I attempt to do an insert there may be a …

sql database postgresql insert upsert

serial in postgres is being increased even though I added on conflict do nothing

I'm using Postgres 9.5 and seeing some wired things here. I've a cron job running ever 5 mins firing a sql statement …

postgresql auto-increment upsert

Is SELECT or INSERT in a function prone to race conditions?

I wrote a function to create posts for a simple blogging engine: CREATE FUNCTION CreatePost(VARCHAR, TEXT, VARCHAR[]) RETURNS INTEGER …

sql postgresql concurrency plpgsql upsert

UPSERT in PostgreSQL using jOOQ

I am trying to perform an UPSERT in PostgreSQL using the jOOQ library. For doing this I am currently trying …

java sql postgresql jooq upsert

how to use python Elasticsearch client upsert api

I'm using Elasticsearch python client as http://elasticsearch-py.readthedocs.org/ I tried hard but still could not find the update …

python elasticsearch upsert