[01:10:55] <diegoviola> i'll give it a try, thanks
[02:26:25] <Loplin> Hi. I was going through this article http://highlyscalable.wordpress.com/2012/03/01/nosql-data-modeling-techniques/ and the section labeled "(2) Aggregrates" uses an example of exactly the kind of data that I want to model. However, it says it is applicable to Key-value stores, document databases, and BigTable-style databases.
[02:26:33] <Loplin> Could someone tell me why would I choose one of these types over another, for this use case?
[02:28:54] <Loplin> Also, if applicable, in my usecase, some entity might be composed of other entities, for example: A country might be composed of cities
[02:44:24] <phira> Loplin: without having an actual outline of your data model, nobody is gonna be able to recommend an option
[02:44:54] <phira> that said, bigtable is rarely a suggestion unless you have a really big dataset, in which case it's usually one of the only options, and a KV store has limited queries
[02:45:06] <phira> so unless you've got specific size or performance concerns, you're going to select a document db
[02:48:01] <Loplin> I see, thank you. I imagine I'll go with a document db then.
[02:48:34] <Loplin> Do you happen to know of any recommended reading that could have helped me figure that out myself?
[03:15:49] <phira> Loplin: not really, sorry, I just kind of pick that stuff up
[05:54:41] <gigo1980> hi is there an command where i can set up that an new created databases should created on shard 3?
[07:09:59] <federated_life> I think I had one of the three config servers fail in 1.8 , whats the propery recovery procedure ?
[08:12:20] <cmex> how can i replace map reduce by it
[08:23:01] <TrahDivad> Hi. I'm trying to connect to a remote database with the mongo shell, but I keep getting a "Assertion failure _setName.size()" error. Here's what I've been trying: "mongo mongodb://name:pass@host:port/dbname"
[08:49:16] <TrahDivad> Someobdy else nearly two years ago had the same problem: https://jira.mongodb.org/browse/SERVER-3300
[08:49:32] <TrahDivad> But I'm not sure if this is a bug or if I'm not feeding the URI correctly.
[09:00:58] <TrahDivad> ppetermann: thanks, I'll give that a try.
[09:03:19] <jpee88> Just out of curiosity - when you want to perform a "transaction" ie atomic operation with two documents that are neither embedded or linked to one another how is this possible?
[09:03:46] <TrahDivad> ppetermann: I had indeed missed these options in -h. Thanks for pointing them out!
[09:05:04] <jpee88> Also sharding in and of itself isn't replication - must one configure replication for each shard to have a master copy with all shards recollected? Or can the mongos direct everything to syncronously replicate?
[09:14:56] <NodeX> jpee88 : you will never achieve true transactions with mongo
[09:15:25] <NodeX> jpee88 : look up replica sets in the docs - they explain about replicatio
[09:43:34] <stevie-bash> I guess its a problem on the developer machines
[09:43:43] <stevie-bash> which stop on any warning
[09:43:52] <sawidis> hey everyone. suppose I have a list of tuples [(a, b), (c, d)]. is it possible to find records having (key_a, key_b) matching one of those tuples\/
[09:44:14] <sawidis> i'm looking at advanced queries in the mongodb website but can't find anything relevant
[09:44:17] <stevie-bash> but will try the beta version
[09:55:07] <sawidis> jpee88: the list of tuples contains values e.g. [(1, 2), (3, 4)] and each record in my collection has two keys: key_a, key_b. I'm wondering if it's possible to find all records matching their (key_a, key_b) to one of the tuples in my list
[10:02:34] <stry3> I have collection with lines like: name (string), date (ISODate). Also I have list of timedeltas (e.g. [0, 10, 30, 60], integer seconds). I need to aggregate data to return it like this:
[10:09:01] <jpee88> sawidis: It's just a basic document search. You can use $where if it's more complicated
[10:09:06] <jpee88> But for example: db.users.find({"username" : "joe", "age" : 27})
[10:09:32] <stry3> NodeX: what do you want on pastebin?
[10:09:33] <jpee88> joe and 27 could be replaced with your_tupe[0][0] and [0][1]
[10:10:37] <jpee88> Infact it could be done in a simple list comprehension
[10:11:48] <jpee88> stry3: The timedeltas are in your application not in mongodb right?
[10:14:33] <NodeX> if pasting large lines to the channel use a PASTEBIN
[10:14:48] <stry3> jpee88: No. There must be list of integer timedeltas and smthing as $lt / $gt with new ISODate(ISODate()-timedelta). I want to create a plot and hope to make only 1 query to mongo.
[10:15:21] <stry3> NodeX: Okay, I'll try to remember it next time.
[10:33:59] <stry3> jpee88: All in all it can be list of ISODates instead "timedelta" integers. But even now I don't know, how to create such iterator with 1 mongo query.
[11:35:09] <algernon> fwiw, you can build good stuff on pretty much any stack, if you know what you're doing. similarly, you can build crap on the best stack ever, if you have no idea.
[11:35:39] <cmex> algernon: thats right im just talking about support
[11:36:13] <cmex> ok guys im going to dig the internet :)))
[11:36:48] <Derick> cmex: you can call the aggregation framework like any other mongo command
[11:37:38] <kali> cmex: you're in new territory, here. aggregation is brand new, and c# is not used as much as ruby, have or php in the mongodb community
[11:37:56] <kali> cmex: it's very likely there is NO example of aggregation in c# yet
[11:38:00] <NodeX> cmex: I personaly have no idea about paid support, but just about every question I have ever needed answering has been done on Google, IRC or by reading docs
[11:39:08] <kali> ... or by reading the source. when it is available to you
[11:41:51] <Rhaven> Hi all, i'm complaining with "stale config detected for ns" log message. How i should handle it ?
[11:44:15] <cmex> Gargoyle: im just kidding about PHP i have a friend here a php ptogrammer each time wo going to cigarete we starting those holywar jokes
[11:45:11] <cmex> kali: i understand that ... but u know we has deadlines here :((
[11:45:40] <Derick> Rhaven: Could I suggest you write to the google groups ML about that one? I don't know (but I think it's not a serious thing)
[11:46:20] <cmex> kali:so iwant to jump from 5th floor already :)))
[11:51:15] <Rhaven> Derick: Thank you anyway, I will do that and try to find out.
[12:28:27] <NodeX> when one drops a collectiopn or an index does Mongo give back the memory it used automagically or do I have to run a command ?
[13:04:34] <Mousse_> Hi. can anyone help me inserting a mongodb collection into an instance of solr for testing?
[13:04:49] <Mousse_> I can't seem to find anything relevant in searches
[13:07:19] <skot> NodeX: the os will reuse the memory based on an LRU scheme so it is always effectively available as it is just cache not resident memory.
[13:08:19] <skot> Mousse_: here is a project which does this for you: https://github.com/renctan/mongo-solr
[13:53:35] <NodeX> stry3 : I was building a wrapper around a driver for the aggregate to make it easy so your code wont help but thanks anyway
[13:53:58] <stry3> any python coders here? I wanna ask about pymongo aggregation…
[13:54:00] <Gargoyle> Yeah. I'll try and isolate it. We have two completely separate connections 1 for the app and 1 for session data. Not sure which one it is yet. What's the alternate syntax?
[14:16:22] <NodeX> {"aggregate":"history","pipeline":[{"$group":{"_id":"$comment","total":{"$sum":1}},"$sort":{"total":-1}}]} <---- anyone know why that would throw an error regarding max doc size of 16mb but the identical query without using "runCommand" is fine?
[14:17:05] <skot> NodeX, can you post the whole thing (shell session + error) to gist/pastie/etc?
[14:23:47] <NodeX> ( i am dynamically creating the runCommand options and I've not cast an array somewhere
[14:24:24] <Zelest> algernon, Ah.. yeah, it's not harder than simply modifying the Makefile and edit the distfile.. but you have to do it each time you sync the tree, which is fairly annoying.
[14:24:55] <Zelest> algernon, Not to mention the fact that you have to check for updates manually, whicih sort of defeat the whole point of using ports or a package management system :P
[14:45:16] <ddod> Hey guys, I'm a MongoDB noob, and I was wondering how to grab the generated _id upon insertion. I'm using Node.js
[14:45:51] <algernon> ddod: generate it yourself is the easiest.
[14:46:29] <algernon> other than that, if your driver generates it for you, it may have a function that also returns it. If it's left up to the server, you're most likely out of luck.
[14:46:36] <ddod> all right, I figured as much, but I wasn't sure if that's the best way to do it
[15:04:42] <Derick> Gargoyle: fixed in master on github
[15:04:45] <Vile> When I'm processing timestamped data and aggregating (m/r) it by hour, i need to know one value that is outside of that hour. What would be the best approach to get it?
[15:06:05] <Vile> Is it possible to run sub-query from finalize?
[15:07:10] <Gargoyle> Derick: And One of the nodes is under siege trying to see if it segfaults, but it's been a bit so very hard to test what actually was causing it. Fingers crossed.
[15:34:08] <Gargoyle> Derick: So far so good. I think I was a little bit ahead of githubs cache. After I got the email saying it had been merged, a fresh clone didn't give me the new one. I had to "git pull" in the change manually
[15:38:49] <Gargoyle> Derick: Now finding that the other dev has been using code igniters mongo stuff and is completely skipping the applications connection options! :S
[15:43:38] <Gargoyle> I increased apache's prefork settings, maybe I'll have to put them back to narrow it down.
[16:47:33] <z3a> hi, I'm have one server running on a local network with intermitent connection to internet, and I need to synchronize it with another server on Internet, but I'm not shure what is the best aproach to do that, anyone can drop me a line?
[17:09:29] <garrettwilkin> Any one know how to authenticate via the mongojs module?
[17:09:33] <garrettwilkin> i can't find docs on it
[17:14:21] <Rhaven> Is there a way to restart a forked mongos instance ? service mongos restart return : "restart: Unknow instance:"
[17:20:55] <oreiator> hi, how can I check high queries in mongo?
[17:36:56] <joshua> Can you set up a replica set and make that into a shard server? I don't know the difference between a shard server and a regular one other than passing the flag that it says just changes the port
[17:48:24] <vsmatck> Sharding imposes limitations, but it allows you to spread data across multiple servers.
[17:48:33] <joshua> I guess I can't really test it till I have a config server layout set up
[17:49:44] <joshua> right now we have a single mongod instance, so I guess I convert that to replicated and then add config servers, then ad mongos
[17:50:04] <reikalusikka> hello, I'm following the "Write a Tumblelog Application with Flask and MongoEngine" tutorial which can be found here http://docs.mongodb.org/manual/tutorial/write-a-tumblelog-application-with-flask-mongoengine/ and when I try to run the application (python manage.py runserver), I get the error "from tumblelog import app" "ImportError: no module named tumblelog"
[17:54:17] <reikalusikka> I have followed the tutorial step by step and my folder structure is as follows "/myproject/tumblelog/" and I created all the files in the tumblelog folder
[19:24:03] <LuckySMack> would i be able to package mongodb with a proprietary/binary application/installer for windows? so my application has a local instance of mongo without having the user have to install it manually?
[19:24:43] <LuckySMack> or would i have to have them install it separately? or coulc i have my app installer download and set it up for them?
[20:45:22] <gigo1980> hi, i have an sharded collection… what can i do, to remove sharing on this collection ?
[21:07:02] <munro> hey, how do change a key in a nested set, $set: {my: {nested: {set: 5}} clobbers everything in {my}
[21:10:27] <munro> ah, I got it, I use the $set: {'my.nested.set': 5}, I tried that, but I must of had something else broken when I did
[22:41:21] <bikcmp> hi. i'm trying to figure out how to set up gridfs.
[22:41:37] <bikcmp> i've been trying to figure it out with google for a few minutes now and can't really find anything that good.
[22:48:50] <rpaddock-home> Using the PHP mongo extension. I'm having a hard time figuring out why a $gt query isn't working. In the shell, {'request.time':{$gt: 123}} works, but in PHP find(array('request.time' => array('$gt' => 123))) doesn't.
[22:51:00] <rpaddock-home> ah, solved it. Had to cast the number to a float