Casting fields in MongoDB Docs

So you have your document schema sorted but your application is throwing in mixed types on an indexed field. Not the end of the world, but your indexes are performing sub optimally.

Hit up your MongoShell:

db.runCommand({
	$eval : db.COLLECTION_NAME.find({
		FIELD_NAME : {
			$exists : true,
			$type : 2
		}
	}).forEach( function(obj) {
		obj.FIELD_NAME = new NumberInt(obj.FIELD_NAME);
		db.COLLECTION_NAME.save(obj);
	}),
	nolock: true
});

All types have a numeric identifier and a full list can be seen here.

Much quicker than processing type operators on the application side. However, large collections will lock the database so your mileage will vary!

mongodb

Heartbleed

If you use the internet, it's probably a good idea to reset your passwords. Don't say you haven't been warned.

9 April 2014 4 min read

NGINX with Upload Progress

Using NGINX as a load balancer can be great. Monitoring upload progress to feed back to your user doesn't come out the box.

31 December 2012 2 min read