Log file Viewer
#mongodb logs for Sunday the 22nd of February, 2015
[00:50:00] <bros> Is it worth it to put a compound index on something you always have to query to check whether it exists or not anyways?
[01:11:53] <AWizzArd> Now I am running `db.coll.count({url: {$regex: /^http:/i}})` and this takes a veerry long time.
[01:11:56] <AWizzArd> Is this line of thought right: when all 73 mio URLs start with "http:" then having an index won’t help. Mongo has to iterate through all 73 mio entries on disk to count them.
[01:24:58] <AWizzArd> kexmex: I didn’t know this kind of notation, this {url: /^http:/} - I guess this is syntactic sugar for the regex version I used above?
[06:08:31] <mordonez> Hi guys, I have two libraries for mongo, one for scala (reactive mongo with play mongo) and pymongo for python
[06:09:14] <mordonez> pymongo saves a field like this "updatedAt" : NumberLong("1424053878000"), while reactivemongo just "updatedAt" : 1424053878000
[07:38:08] <mordonez> Hi guys, I have this word "ironía" and I want to search using ironia and ironía
[10:31:53] <iksik> db.collection.find().sort({ $natural: -1 }).limit(10) - how can i use this kind of sort on particular nested field?
[14:16:43] <[WiseWatcher-UK]> Hi kexmex, I've run mongodump on 2.6.0, then mongorestored to v3, but get http://pastebin.com/cHVfnLRx how can I fix it?
[18:13:29] <bros> https://gist.github.com/anonymous/e626592f1e2834bb3749 I can't get update $push to work.
[18:13:56] <OmicroN_> maybe someone in here can help me, fairly new to mongodb, trying to make a query that'll return all documents UNLESS a specific document by id exists then it'll just return that one
[18:20:50] <OmicroN_> roger kali, what i figured but thought maybe i could get away with using one :p
[18:21:21] <OmicroN_> even thought i'm trying to pull all documents i'm not really pulling all documents i'm just finding 1
[18:23:01] <OmicroN_> was thinking if i could use a and/or and have two conditions in my query one to look for the specific id, the other condition to basically pull all records
[18:23:23] <OmicroN_> and if the condition to pull the specific id pulls before the other condition then my findone query will still pull the first record
[18:24:24] <OmicroN_> so if my specific id condition would of pulled first before the condition to pull all, the sort would still throw it off if the specific id condition doesn't have the highest sort
[18:33:30] <ilaron> Hi, I would like to know if there is a possibility in MongoDB to work with dynamic collections ?
[19:01:04] <bros> If it weren't for callbacks, Node would blow all of those out of the water in my opinion. Programming wise at least.
[19:07:17] <bros> db.accounts.find({_id:ObjectId('54ea23d2f94bdbc35215db65')}, { stores: { '$elemMatch': { 'name': 'name'}}});
[20:44:17] <jayjo> In order to insert json as a bulk write operation (~200mb at a time), can I access files in my directory through the mongo shell?
[20:51:56] <Angela_d2> am i able to get all messages from a specific user with this schema? http://pastie.org/9972104
[21:07:58] <Guest51704> db.users.update({"_id":ObjectId("54e664c4e7c3b4d3b5413e39")},{$pull:{“ItemsToRemove”: {id:"ChIJIQBpAG2ahYAR_6128GcTUEo"}}},{ multi: true })
[21:08:33] <Guest51704> but once I look at the record the items in that ‘ItemsToRemove’ array have not been remvoed
[21:10:14] <gaby__> Hey guys, I am quite new to mongodb and I have this question about updating nested documents. Got a gist there with the concern and a code sample : https://gist.github.com/gabriel-dehan/09d94c7b5e8ab6496c1d
[21:40:52] <gaby_> Hello guys, kinda new to mongodb and have a question about updating nested documents. Everything is in the gist : https://gist.github.com/gabriel-dehan/09d94c7b5e8ab6496c1d
[22:08:14] <gaby_> Maybe it is then I might have miss understood how it works. It seems to help to refine the query to get the document, but how does it allow me to update a nested object according to its fields ?
[22:09:01] <Guest51704> here you go joan: http://stackoverflow.com/questions/28663273/pull-mongodb-is-not-removing-items
[22:09:01] <joannac> gaby_: http://docs.mongodb.org/manual/reference/operator/update/positional/#update-values-in-an-array
[22:10:14] <gaby_> Irssi reads it well :) Anyway thanks for the read it is indeed exactly what I want
[22:10:59] <Guest51704> here is an updated gist: https://gist.github.com/theprojectabot/fa05647bcf66a0d7d237
[22:13:02] <joannac> 1. If you are absolutely sure that's exactly how it looks (fields, types, *order of fields*
[22:14:42] <Guest51704> I thought Im just finding the ‘ItemsToDelete field (its an array) on my user doc, then $pull any sub fields that match the placeId
[22:15:30] <Guest51704> error I receive when doing “ItemsToDelete.placeId” => ‘cannot use the part (ItemsToDelete of ItemsToDelete.placeId) to traverse the element’
[22:25:54] <Guest51704> joannac: so yeah with quotes I still get that ‘cannot use the part (ItemsToDelete of ItemsToDelete.placeId) to traverse the element’
[22:29:31] <joannac> db.users.update({"_id":ObjectId("54ea5683681b242a284cbe05")},{$pull:{"ItemsToDelete": {placeId:"ChIJIQBpAG2ahYAR_6128GcTUEo"}}},{ multi: true })
[22:30:37] <Guest51704> joannac: thanks I try that but when I do a refresh on that user again, its ItemsToDelete array still has all the records in it
[22:31:32] <Guest51704> joannac do i have to do a secondary opertation to have the elements of that ItemsToDelete array removed? after the $pull?
[22:34:18] <joannac> "i swear that was the exact same thing I typed 30 mins ago at the start of this mess wth?!"