Log file Viewer
#mongodb logs for Tuesday the 4th of March, 2014
[02:19:07] <ddod> Question: I have a db of articles in different categories. Is there a single query to get a per-category limit? As in, 10 articles from each category. Bonus points for the node-mongodb-native query. My current query: articles.find({categories: { $in: ['news', 'opinion'] }).sort({'date': -1}).limit(10).toArray()
[02:22:07] <Node_034> Question: I have a question regarding Mongoose queries. I have a database of posts in various threads, when I query for a group of threads I can usually populate them when I've queried for them. However, how would I go about populating the posts inside the group of threads?
[06:55:22] <felixjet> Alternately, db.collection.save() replaces an existing document with the same _id field.
[08:50:23] <palominoz> Hello there. Any suggestions or best practice for architecturing a localized data model on mongodb? i am looking at objectives 1. reducing effort(SLOC to serialize / deserialize objects) to respond to HTTP Content-language headers 2. mantain high performance on queries even with lots of data
[09:02:50] <palominoz> ok. sorry for the big words. i was wondering where to store localized attributes of my documents, while keeping clean source code and mantain high performance. is it more clear?
[09:05:12] <palominoz> one solution could be Product : { locales: { en: { "name": "Car"}, it:{"name":"Automobile" }}}
[10:17:21] <scottyob> Howdy, I'm wondering how to get Timestamp(1393927193, 0) into something more human readable
[10:21:23] <scottyob> Nodex: so can't do it in the Node shell? That's all good, what's the number represent? 1393927193
[10:30:40] <ssapphiree> hi all! can you help me pls? I'm trying to figure out how to make a query I need
[10:31:03] <ssapphiree> I need to find a record in DB where array field exactly matches the array I have
[10:31:31] <ssapphiree> I only found $elemMatch operator in manual, but it's not quite what I need...
[10:32:55] <McSorley> When using mongoimport, is it possible to specify the delimiter of a CSV file?
[10:33:22] <kali> scottyob: have considered using Date and not Timestamp ? Timestamp is mostly for internal use
[10:41:30] <Nodex> http://docs.mongodb.org/manual/reference/operator/query/all/#use-all-with-elemmatch
[11:24:53] <KraK> Hello, I have a php host and I wanted to know if there is a way to have my own Mongodb server on it so I could use it for angularjs, thanks
[11:32:51] <KraK> The reason I want to do this, is I don't have enough money to get a mongodb server ...
[11:34:46] <KraK> I don't think so, I just checked their FAQ, you need to get a VPS and install it on it
[14:58:14] <spicewiesel> hi all, just a short question: I enabled profiling via db.setProfilingLevel(1,50) on all mongod instances in the replicaset. Today, 2 weeks later, the profiling level was back to 0 at the hosts. Does anyone know how this can happen?
[15:26:03] <spicewiesel> I thought only the content of the used capped collection will be flushed, not the profling setting itself
[15:36:52] <Striki> how fast is count with 1 regex match? the field is indexed but the collection has 525 million documents. I've read about issues with slow count queries, just wondering what the status of it is today. the regex match is in the recommended form, with "starts at" and "ends at", checks for 49 symbols on 1 indexes field
[16:01:13] <bensons> hi, if i have sharding active for a collection, hashed as sharding key; when i now add a new shard (replset) data will be reblanaced. is there any way to avoid that for hased shardkey?
[16:07:21] <bensons> kali: well lets say i have 3 shards(replsets) and i want 1 collection to be spread across shard1/shard2 and another across shard2/shard3
[16:09:10] <bensons> but since the sharding key is id hashed its not possible (from what i understand) to set split points
[16:14:20] <kali> bensons: what about this ? http://docs.mongodb.org/manual/reference/command/split/#split-a-chunk-using-values-of-a-hashed-shard-key
[17:10:08] <Rhaven> Hello, i'm using mms and i have some troubles with sharded cluster detection through a mongos. There is no other member except the mongos used for the detection.
[17:45:37] <andrewjacobs> hello everyone, i am using the latest mongodb and C# library, I am running into an error when I try to populate a object[] with a query contain email
[18:29:55] <dmarkey> if i have two documents {"version" : "2.0"} and {"version": "3.0"} , can I do an aggregate query to count the different versions and the total?
[18:45:50] <Rhaven> Hello, i'm using mms and i have some troubles with sharded cluster detection through a mongos. There is no other member except the mongos used for the detection.
[19:34:23] <tristan1990> Hey guys. I have a problem connecting MongoDB to Node. If anybody could help then I have detailed the setup here - http://pastebin.com/ENx9S7M6
[19:37:17] <a13x2121> i added a new user to db admin, i can authenticate but getting a unauthorized when running show dbs
[20:23:47] <tristan1990> Hey, I've followed this tutorial which builds this: https://github.com/ccoenraets/directory-backbone-bootstrap
[20:24:44] <tristan1990> I am also using this with the above https://github.com/ccoenraets/cordova-tutorial/blob/master/www/js/adapters/jsonp-adapter.js
[20:25:15] <tristan1990> so basically I fire up the mongoDB, nodeJS server and then the node app works
[20:25:42] <tristan1990> I want to now connect that code to my MongoLab hosted DB, rather than running locally
[20:34:47] <tristan1990> rkgarcia: I thought I had a problem but actually I think I just need some help and fresh thinking on the project :(
[20:36:29] <tristan1990> I want to make a really simple app using PhoneGap that just searches the MongoDB for the shop the user wants
[20:37:19] <tristan1990> I thought a good place to start would be using a tutorial for PhoneGap to create an employee directory. My thinking was that it had a simple search bar that searches for content on a mongodb (local)
[20:38:27] <tristan1990> The tutorial worked and I have edited the looks of the app to meet my requirements. I want to now make the app read the MongoLabs hosted database rather than the one I started running on my mac
[20:39:32] <tristan1990> this is the tut I followed - https://github.com/ccoenraets/directory-backbone-bootstrap and I added the extra file - directory-rest-nodejs from the same guy's github.
[20:40:04] <tristan1990> This worked so that I started the mongodb, started up nodejs server and then I could use the app as per the tutorial.
[20:41:12] <tristan1990> actually cordova is irrelevent.. It's standard node stuff, i just use cordova to build it after. If i can get it working in node, I can get it working in cordova
[20:43:22] <rkgarcia> for example to select a collections you need "var myCollection = db.collection('myCollectionName');"
[20:43:33] <tristan1990> Okay. This is my node app I think https://gist.github.com/anonymous/9908269e2be7b138441d
[20:44:18] <tristan1990> So you would say that the link you just pasted me is the best way to do it?
[20:45:07] <pmxbot> !8ball (8) !acronym (ac) !anchorman !annoy (a, bother) !bender (bend) !bitchingisuseless (qbiu) !blame !bless !boo !bottom10 (bottom) !calc !chain !cheer (c) !c
[20:45:07] <pmxbot> ompliment (surreal) !config !ctlaltdel (controlaltdelete, controlaltdelete, cad, restart, quit) !curse !dance (d) !danke (dankeschoen, ds, gm, germanmotivate) !
[20:45:07] <pmxbot> deal !define (def) !demotivate (dm) !disembowel (dis, eviscerate) !duck (ducky) !embowel (reembowel) !emergencycompliment (ec, emercomp) !esperantomotivate (em)
[20:45:07] <pmxbot> !excuse (e) !featurecreep (fc) !fight !flip !fm (frenchmotivate) !fml !gettowork (gtw) !golfclap (clap) !google (g) !grail !haiku !hal (2001) !hangover !help (
[20:45:08] <pmxbot> h) !hire !imotivate (im, ironicmotivate) !insult !jm (japanesemotivate) !job (card) !karma (k) !keelhaul (kh) !klingon (klingonism) !lm (latinmotivate) !log !lo
[20:45:08] <pmxbot> go !logs !lunch (lunchpick, lunchpicker) !meaculpa (apology, apologize) !motivate (m, appreciate, thanks, thank, gracias) !murphy (law) !nailedit (nail, n) !nas
[20:45:08] <pmxbot> tygram (nerf, passive, bcc) !norris () !notify !oregontrail (otrail) !panic (pc) !password (pw, passwd) !paste !pick (p, p:, pick:) !pm (piratemotivate) !progre
[20:45:09] <pmxbot> ss !quote (q) !r (r) !resolv !roll !rubberstamp (approve) !saysomething !send_text !simpsons (simp) !stab (shank, shiv) !storytime (story) !strategy !strike !tg
[20:45:09] <pmxbot> if !therethere (poor, comfort) !ticker (t) !time !tinytear (tt, tear, cry) !top10 (top) !troutslap (slap, ts) !urbandict (urb, ud, urbandictionary, urbandefine,
[20:45:09] <pmxbot> urbandef, urbdef) !version (v, e, r) !weather (w) !where (last, seen, lastseen) !wolframalpha (wa) !zinger (zing) !zoidberg (zoid)
[20:47:59] <tristan1990> Okay, just checking. Using node-mongodb-native is it possible to have a search bar? (I realise that may be a ridiculous question)
[20:56:18] <tristan1990> var host = process.env['MONGO_NODE_DRIVER_HOST'] != null ? process.env['MONGO_NODE_DRIVER_HOST'] : 'localhost';
[20:56:19] <tristan1990> var port = process.env['MONGO_NODE_DRIVER_PORT'] != null ? process.env['MONGO_NODE_DRIVER_PORT'] : 27017;
[21:01:16] <tristan1990> I'm not sure. I've opened an example from the git you sent me and these are at the top
[21:04:28] <tristan1990> Okay, so this is the queries.js example in the examples folder of the git I have cloned and done npm install in the same folder of
[21:04:48] <tristan1990> and this is my database login info - mongodb://<dbuser>:<dbpassword>@ds037737.mongolab.com:37737/openingtimes
[21:07:42] <rkgarcia> MongoClient.connect(format("mongodb://%s:%s/stores?w=1", host, port), function(err, db) {
[21:08:50] <tristan1990> Okay, got another problem (surprise!) im getting this trying to install mongodb
[21:12:13] <tristan1990> Error: Cannot find module '/Users/tristankirkpatrick/Documents/openingtimes/node-mongodb-native/queries.js'
[21:18:35] <tristan1990> currently it's this - MongoClient.connect(format("mongodb://%s:%s/stores?w=1", host, port), function(err, db) { db.dropDatabase(function() {
[21:20:32] <tristan1990> var host = process.env['MONGO_NODE_DRIVER_HOST'] != null ? process.env['MONGO_NODE_DRIVER_HOST'] : 'localhost';
[21:20:33] <tristan1990> var port = process.env['MONGO_NODE_DRIVER_PORT'] != null ? process.env['MONGO_NODE_DRIVER_PORT'] : 27017;
[21:21:27] <tristan1990> MongoClient.connect(format("mongodb://tristan:po81*@ds037737.mongolab.com:37737/openingtimes", host, port), function(err, db) { db.dropDatabase(function() {
[21:22:12] <rkgarcia> MongoClient.connect("mongodb://user:pass@ds037737.mongolab.com:37737/openingtimes", function(err, db) {
[21:26:46] <spa-dev> basically I've got a collection of users and a collection of a hierarchy of groups
[21:27:39] <spa-dev> so on my users collection, I have a an array of objects that include the group id and a collection of roles
[21:28:03] <spa-dev> but that seems to make it complicated to work with using any of the standard mongo tools in nodejs like mongoose
[21:29:18] <spa-dev> example user might be { username:'user', groups: [{groupid:ObjectId, roles: ['user', 'special thing']}]}
[21:38:39] <betty> rkgarcia: yea, I know about stats() function, I was wondering if for planning purposes I might estimate what the indexSize will be before creating them. I'm the planning stages of a project and need a rough idea of initial storage needs and cost
[22:16:19] <rkgarcia> betty: http://stackoverflow.com/questions/8607637/are-there-any-tools-to-estimate-index-size-in-mongodb
[23:45:44] <niftylettuce_> hey guys im trying to some advanced query, wondering if you can help ... http://stackoverflow.com/a/11418489 basically this but instead of having to do docs.filter I want to just do something like `.where({ tags: { $ne: null }) ... so it filters out anything that doesn't have tags populated