Ways to implement data versioning in MongoDB

by

The first big question when diving in to this is “how do you want to store changesets”?

  1. Diffs?
  2. Whole record copies?

My personal approach would be to store diffs. Because the display of these diffs is really a special action, I would put the diffs in a different “history” collection.

I would use the different collection to save memory space. You generally don’t want a full history for a simple query. So by keeping the history out of the object you can also keep it out of the commonly accessed memory when that data is queried.

To make my life easy, I would make a history document contain a dictionary of time-stamped diffs. Something like this:

{
    _id : "id of address book record",
    changes : { 
                1234567 : { "city" : "Omaha", "state" : "Nebraska" },
                1234568 : { "city" : "Kansas City", "state" : "Missouri" }
               }
}

To make my life really easy, I would make this part of my DataObjects (EntityWrapper, whatever) that I use to access my data. Generally these objects have some form of history, so that you can easily override the save() method to make this change at the same time.

UPDATE: 2015-10

It looks like there is now a spec for handling JSON diffs. This seems like a more robust way to store the diffs / changes.

More Related Contents:

  1. Query for documents where array size is greater than 1
  2. Mongodb $push in nested array
  3. Conditional $sum in MongoDB
  4. mongoDB/mongoose: unique if not null
  5. Find MongoDB records where array field is not empty
  6. MongoDB – Update an object in nested Array
  7. Creating Multifield Indexes in Mongoose / MongoDB
  8. Mongodb Explain for Aggregation framework
  9. MongoDB aggregation comparison: group(), $group and MapReduce
  10. Multiple Counts with single query in mongodb
  11. NoSQL (MongoDB) vs Lucene (or Solr) as your database [closed]
  12. Delete everything in a MongoDB database
  13. Failed to start mongod.service: Unit mongod.service not found
  14. How to return array of string with mongodb aggregation
  15. Mongoose’s find method with $or condition does not work properly
  16. Using MongoDB $pull to delete documents within an Array
  17. return query based on date
  18. MongoParseError: options useCreateIndex, useFindAndModify are not supported
  19. Can’t find documents searching by ObjectId using Mongoose
  20. Mongodb aggregation $group, restrict length of array
  21. mongodb – Find document with closest integer value
  22. mongodb, replicates and error: { “$err” : “not master and slaveOk=false”, “code” : 13435 }
  23. MongoDB/NoSQL: Keeping Document Change History
  24. Update a value in MongoDB based on its current value
  25. MongoDB normalization, foreign key and joining
  26. Meteor: uploading file from client to Mongo collection vs file system vs GridFS
  27. MongoDB $lookup on nested document
  28. How are MongoDB’s ObjectIds generated?
  29. How to get all result if unwind field does not exist in mongodb
  30. How to get a specific embedded document inside a MongoDB collection? [duplicate]

Leave a Comment