Log file Viewer
#mongodb logs for Sunday the 4th of January, 2015
[01:47:21] <AronBrrr> hey all, i’m having some trouble figuring out the best way to store nested data in a mongo collection
[01:56:31] <AronBrrr> so i have a collection of, say, television shows, and inside each show is a seasons array, which contains info about each season, and inside each season object, there’s an array of episode objects. is this a good/bad way to do it?
[01:56:53] <AronBrrr> or should i have an episodes collection and then a tv shows collection? and link them somehow?
[04:54:01] <torarch> is there much sense in terms of efficiency to split a users collection into guest users and permanent users? I am getting large quantities of guest users which I expire based on a sparse index on a field that only the guest users have
[04:55:08] <torarch> there are some unique indexes that are applied to the user collection which dont need to hold for guest users
[14:43:44] <mordof> Patteh: http://stackoverflow.com/questions/10519432/how-to-do-raw-mongodb-operations-in-mongoose
[14:44:13] <mordof> Patteh: i'm not sure about actually using the current connection with the other module though
[14:56:08] <mordof> Patteh: you wouldn't happen to know about the geospatial indexes mongo has would you?
[14:56:30] <mordof> trying to find an answer to my question, and haven't had any luck in this channel so far unfortunately
[14:58:00] <mordof> because this is the first i've tried to do anything with geospatial stuff at all
[14:59:39] <mordof> so i've got a bunch of different items in several different collections that are holding x, y values (indexed with generic 2d index in mongo). my thought was that if i held a box (2 tuples or w/e they're called), that i could query a "is this point inside any user box"? type of thing
[14:59:56] <mordof> so as to find out which user needs to be alerted when an item in a collection gets updated
[15:00:36] <mordof> essentially all i've been trying to determine for the past week or so, is if that's a good idea, and if so - can mongo do that with "normal" 2d indexes
[15:01:39] <mordof> it's a game for the sake of testing out node+mongo and other processes working together. so the user is looking at a current location, and if something gets updated - they should see that come up
[15:02:19] <mordof> so i'm trying to determine a decent way to mark that a user should receieve updated info
[15:02:42] <mordof> without just having the client request all data every few seconds or something, lol
[15:03:37] <mordof> the whole architecture/process for the game has been geared towards allowing for latency issues and certain timeouts and whatnot, so that part is fine
[15:04:13] <mordof> been wondering if i'm trying to do something too unusual and that's why i can't find anything, lol
[15:07:20] <mordof> when connecting through commandline (that's messed me up the first few times i tried to look for stuff)
[15:13:02] <mordof> i generally have to jump on random remote boxes in production to check data quality and ensure records are there, so if i only knew the IDEs for the databases I work with... well that wouldn't work at all
[15:14:13] <mordof> i suppose a person can learn both well. generally that only occurs through necessity either way though
[15:21:26] <mordof> https://groups.google.com/forum/#!topic/mongodb-user/LTt53Ki4Rug this is similar to what i want to do, without the need for the $near in the query... but i don't want to use lat/lng - and i'm wondering if this is possible to be done NOT based on a sphere (or if it's not, does it even matter?). i want to use x, y values with currently undetermined min/max limits
[15:25:42] <mordof> modulus^: i'm making a game - user has a viewport (area of space they see). it's all 2D. each document in a collection has an x,y location for it. i want to update a user with new info if a document within his viewport has been updated
[15:27:17] <mordof> but there's not really any gravity (in most scenarios) or other factors on the objects
[15:28:40] <mordof> modulus^: i figured if i stored a polygon for the user's viewport, then each time a document gets updated - i could update that user's document to say "i need to update" and only then send new data to the user
[15:29:37] <mordof> modulus^: by doing a $geoWithin. but the part i don't know about is if that *always requires* lat/lng and calculates on a sphere. the documentation is not clear on this
[15:36:02] <riceNbeans> "Unexpected token . " in return Foods.find({Session.get(foodCategory): {$in: [true]}}); What is wrong here?
[15:36:48] <mordof> riceNbeans: is it possible your foodCategory session variable is an invalid key?
[15:49:45] <mordof> ugh.. the legacy 2d box is only supported in querying, not storage. not what i need
[17:46:54] <rogero> my problem is: the above line removes the other entries in the document but the updated ones, why would that happen?
[17:53:10] <rogero> iraycd: which generates: {'abc': u'hi', 'last_operation': datetime.datetime(2015, 1, 4, 17, 45, 53, 428148)}
[18:00:35] <iraycd> Yeah, it is, but if it applied on multiple objects. You have to include { multi: true }
[18:15:17] <iraycd> rogero: You can't do that, because set is like a command in background. There are many other operations.
[18:21:37] <iraycd> rogero: This is what update does in pymongo. https://github.com/mongodb/mongo-python-driver/blob/master/pymongo/collection.py#L415
[23:31:26] <vagueBrother> hey all, can anyone recommend any techniques or patterns to storing nested data in a mongo db?
[23:31:48] <vagueBrother> i’ve been having some odd problems with querying data that is objects nested inside arrays nested inside objects
[23:37:37] <Boomtime> how about you describe your current document schema and the 'odd problems', maybe we can help with those instead