Browsing the archives for the Quick Tip category

Quick Tip: How to $size up a MongoDB Array

5 Aug, 2011 in Querying, Quick Tip by

TweetSince MongoDB will allow you to store more than just string and int values but also things like arrays … from time to time you might need to know how many items are in an array in your document. For example, say you have a hosting business and to make a good profit you need [...]

0 Comments

Quick Tip: Copy DBs Between Servers

11 Apr, 2011 in Administration, Quick Tip by

TweetInspired by this Stackoverflow question I thought it would be worth while to post this quick tip … If you ever need to copy (or “clone”) a MongoDB databse between two MongoDB servers its as easy as running the copyDatabase() command. First, change into your admin db … Then, run copyDatabase() supplying the needed information, the [...]

1 Comment

Quick Tip: Using Users in MongoDB

16 Dec, 2010 in Administration, Quick Tip by

TweetBy default a MongoDB install does not use a username/password combination to access the database. No Password, But Why? This is down to the design philosophy of MongoDB which is to push much of the “logic” to the application level and keep the database doing what databases do best! Hence,  given the way that MongoDB [...]

2 Comments

Quick Tip: MongoDB Distinct Count

30 Aug, 2010 in Querying, Quick Tip by

TweetOne query SQL users are pretty used to writing is DISTINCT with COUNT() to get the number if distinct (unique) rows that match a statement like … SELECT COUNT(DISTINCT(PageURL)) FROM LogTable; This rather simple query will get us back the number of unique PageURL’s in our LogTable … not an amazingly useful query but you get [...]

4 Comments

Quick Tip: Return Only 1 Field

19 Aug, 2010 in Querying, Quick Tip by

TweetSay you have a log of hits to your podcast, something like … { “_id” : ObjectId(“4c6c753800ae261d80000009″), “podcastID” : 1, “remoteUserIP” : “10.40.52.55″, “remoteUserSession” : “gpn1vz1crveoqtgtlbh1tgd1″, “remoteUserAgent” : “iTunes/9.2.1 (Macintosh; Intel Mac OS X 10.6.4) AppleWebKit/533.17.8″, “created” : { “date” : “8/18/2010″, “time” : “5:05:12 PM” } } To get a quick snapshot of hits [...]

2 Comments