Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Mongo Schema-less Collections & C#

Tags:

I'm exploring Mongo as an alternative to relational databases but I'm running into a problem with the concept of schemaless collections.

In theory it sounds great, but as soon as you tie a model to a collection, the model becomes your defacto schema. You can no longer just add or remove fields from your model and expect it to continue to work. I see the same problems here managing changes as you have with a relational database in that you need some sort of script to migrate from one version of the database schema to the other.

Am I approaching this from the wrong angle? What approaches do members here take to ensure that their collection items stay in sync with their domain model when making updates to their domain model?

Edit: It's worth noting that these problems obviously exist in relational databases as well, but I'm asking specifically for strategies in mitigating the problem using schemaless databases and more specifically Mongo. Thanks!

like image 842
Timothy Strimple Avatar asked Sep 02 '11 05:09

Timothy Strimple


People also ask

Is NoSQL schema free?

Characteristics of NoSQL: Schema free. Eventually consistent (as in the BASE property)

How many collections can I have in MongoDB?

In general, try to limit your replica set to 10,000 collections.

Does MongoDB have schema?

Data in MongoDB has a flexible schema. Collections do not enforce document structure by default. This flexibility gives you data-modeling choices to match your application and its performance requirements.


1 Answers

Schema migration with MongoDB is actually a lot less painful than with, say, SQL server.

Adding a new field is easy, old records will come in with it set to null or you can use attributes to control the default value [BsonDefaultValue("abc", SerializeDefaultValue = false)]

The [BsonIgnoreIfNull] attribute is also handy for omitting objects that are null from the document when it is serialized.

Removing a field is fairly easy too, you can use [BSonExtraElements] (see docs) to collect them up and preserve them or you can use [BsonIgnoreExtraElements] to simply throw them away.

With these in place there really is no need to go convert every record to the new schema, you can do it lazily as needed when records are updated, or slowly in the background.


PS, since you are also interested in using dynamic with Mongo, here's an experiment I tried along those lines. And here's an updated post with a complete serializer and deserializer for dynamic objects.

like image 155
Ian Mercer Avatar answered Dec 28 '22 17:12

Ian Mercer