[04:01:09] <timah> for document _ids such as: _id: { g: 123, o: ObjectId() }… does the order of properties actually matter? the end-result should allow me to query a date range for a given g (group).
[07:12:18] <adibis> hi, trying to get the next and previous item in a database in alphabetical order. I am not able to do that. I could construct a query with the id field and use id.lt and id.gt to get the next item by id but that is not alphabetical. Can someone point me to a tutorial or document that explains getting next items by alphabetical order?
[07:15:07] <adibis> yes, sort is sorting the records. How do I compare it with the current record and then get the next item from the sorted list. That's not working.
[07:15:58] <adibis> for example, I am on M right now. Sorting gave me a sorted list, A..Z. How do I iterate through the list till I reach M and then return the next item from this sorted list, which is N.
[07:18:52] <joshua> Hey I am not much of a coder and I am trying to come up with an easy way for other guys on my team to run a find through a shell or perl script
[07:19:09] <joshua> I can run a query by passing javascript to mongo, but how would you take user input for the search string I am wondering
[14:44:37] <Virunga> Could you give any advise about the document structure for storing irc channel messages, that have different properties, such that retrieving all message of a channel, of a specific day, ordered by time would be easily as possible?
[14:47:34] <Virunga> I thought these solutions, { channel:"channel1", /* day from the 1970 */ 12345435435: { /* messages */ "10:03": {event:"join", nick:"..", host:"..." }, "10:50": {event:"mex", from:"..."}, ...}, 43245645645: {....}}
[14:49:12] <Virunga> Or meaby, {channel:"channel1", day:324342342, hour:"00:01", message: {...}}
[14:54:29] <Virunga> is it ok append a message each time it arrive, of should i do this sometimes? Because i'd like to show the logs in realtime like a chat
[20:47:41] <Ro__> hello, I cant find GRIDFS get_version method in a php driver.
[20:48:04] <Ro__> It's not implemented or I need to map reduce myself?
[21:08:59] <ExxKA> Hey Guys. I have been wondering how to utilize the database vs. connection object. Does the nodejs driver handle connections in some central place, so that I can just fire new queries without managing connections myself?
[21:10:10] <wereHamster> to send a query to the server you need an open connection
[21:12:03] <ExxKA> wereHamster, Yes I am with you that far, but once I have an open connnection do I need to handle how many, and which ones are available for another query?
[21:13:24] <wereHamster> and it's always avialable for a query
[21:14:14] <ExxKA> I get an error saying "db object is already connecting, open cannot be called multiple times", and that is because I try to fire several queries at the same connection
[21:14:27] <wereHamster> are you calling open() multiple times?
[21:35:22] <xeviox> I'm totally new to mongodb and be lost with a (hopefully) simple problem. My document structure is like "http://pastebin.com/z4qC9v8x". No I try to get all samples with a specific "borrower".
[21:39:04] <xeviox> I tried using the query " query: { samples.borrower: "another.user@example.com" } " (taken from the logs)
[21:47:27] <kali> xeviox: you may want to check out the aggregation framework to $unwind the samples for the matching docs and filter the matching samples
[21:48:16] <xeviox> kali: so it may be possible with a standard install (couldn't setup more)
[21:49:32] <kali> aggregation framework is part of a the standard install
[21:50:12] <kali> i'm not aware of anything not being a standard install tbh
[21:50:46] <kali> i mean except for sharding and replication, which have very marginal impact on the feature set, all install are equivalent
[22:29:00] <xeviox> kali: thanks for pushing me in the right direction :D
[22:46:47] <xeviox> is it possible to "change" a single type of field to a list? (e. g. { Books { name: 'name', sample: { 'id': 1} } } => {Books { name: 'name', sample: [ {'id': 1} ] } } )
[23:06:49] <Virunga> I don't want the $ in the document
[23:10:46] <Virunga> I'd like to find the document with id:'ch1', with an array that contains a document with field day with value 'ieri', and push a new element inside the messages array contained in that document.
[23:10:53] <Virunga> I don't know if that's clear :P
[23:22:44] <Virunga> The doc says that save is equivalent to update with a query argument on the _id field and upsert opt, but i get an error with same expression changing only update in save :/