mongodbdata-modelingdatabasenosql

MongoDB: upsert with different values for update and insert


A little context: I have a document for each user that contains an array with latest 20 events related to a user. As MongoDB does not have this feature(to cap arrays inside a document), I will push my event and pop the latest one.

My problem: initializing the document(aka filling array with nulls). I want to atomically:

or

Do you have any other suggestions? A hack I thought about would be to declare a index with :unique and :dropDups, and to always make an initialization insert.

Related to: MongoDB fixed size array implementation


Solution

  • Not possible in a single operation, yet. You want http://jira.mongodb.org/browse/SERVER-991 or http://jira.mongodb.org/browse/SERVER-453.