Log file Viewer

[00:20:27] <benji__> hmm. How do you rename a field output from a mongodb query?

[00:28:04] <_blizzy_> anyone familiar with mgo for Golang?

[00:30:45] <dimon222> http://godoc.org/gopkg.in/mgo.v2

[00:33:53] <_blizzy_> dimon222, thanks for the link, but I had a question about mgo that I needed to ask.

[01:21:00] <benji__> Anyone know how to use widcards in $match in aggregate? I want to get all records containing variations of a word. e.g. { $match : { term : 'rock' } } seems to be exact matches

[01:47:33] <dimon222> you have choice, fulltext index or regex

[01:47:54] <dimon222> $regex : /rock/ is one of the ways

[01:48:24] <benji__> dimon222: Thank man. I ended up figuring it out: went with { $match : { term : { $regex : "rock" } } }

[01:48:49] <dimon222> its slow tho

[01:48:55] <benji__> dimon222: yeah..

[01:49:40] <benji__> at 1.50am in the morning, trying to get through this coursework, optimising my queries is low priority... lol

[02:00:03] <benji__> dimon222: for a question like: List the names of the 10 artists with the most songs associated with them, along with the number of tracks per artist.

[02:00:15] <benji__> is { $group: { _id: "$artist_name" , total: { $sum: "$title" } } } correct?

[02:14:22] <dimon222> might also need limit to 10

[02:14:36] <benji__> Yeah - sorry just meant with the grouping and counting

[02:14:49] <benji__> Totally, Totally new to this language

[02:25:54] <benji__> dimon222: yeah.. thats not right. It seems to be trying to add the value of those fields instead of count number number of them. Eugh.

[02:48:34] <benji__> Would anyone be around to give me some help with a few queries I am trying to run?

[06:17:10] <delinquentme> Is there a rule of thumb when I'll need to start sharding a nosql DB?

[06:17:27] <delinquentme> someone earlier had suggested so long as all the data fits within RAM ... IDK on that

[07:25:27] <parallel21> Is there a way I can retreive an array from multuple documents so it is not nested within the results

[07:27:23] <parallel21> http://pastebin.com/jHu9dmxn

[07:27:43] <parallel21> I have this as a result set, but I'd like it not nest within the v: [{}]

[08:00:15] <kkoders> try to connect to mongodb via node/mongojs, i get this error right off the bat

[08:00:23] <kkoders> Uncaught Error: Cannot find module './commands/base_command'

[08:00:34] <kkoders> anyone seen this before? all i've done is require('mongojs') so far

[08:01:27] <shalinisejwani> hello

[08:02:45] <shalinisejwani> i am new to python and django i am trying to use mongodb as my primary database, django1.7, python3.4, but nothing works.. project wont migrate

[08:03:56] <shalinisejwani> can somebody help me?

[08:34:23] <Progz> Hi I am a new system administrator on a french company, and I've got a trouvle with a mongodb server. On this server we have 1000 mongodb database, one per website. I don't understand why my mongodb server is NOT consuming ram and stay at 599 MB of ram used.... result my load average is always increasing ....

[08:34:48] <Progz> For me, mongodb should use the maximum ram available so in my case 15 GB.

[08:37:01] <kkoders> really frustrating.. why with node+browserify i can't do require('mongojs') ?

[08:37:10] <kkoders> i keep getting 'cannot find module './commands/base_command'

[08:51:55] <NoOutlet> kkoders, are you asking this question in a Node.js IRC channel?

[08:52:16] <kkoders> yes

[08:54:18] <NoOutlet> Okay, they will probably be able to help you better. It's not specifically a MongoDB thing.

[08:54:52] <NoOutlet> And they will probably want the full trace of the problem.

[08:55:02] <kkoders> thx outlet

[08:55:10] <kkoders> will wait till more people get online then

[15:37:42] <willwh> hi guys, anyone running mongo 3 on debian?

[15:38:44] <willwh> run level fun, if 'echo never > /sys/kernel/mm/transparent_hugepage/defrag' in rc.local, it's too late it seems

[15:38:50] <willwh> anyone have any advice here?

[15:39:03] <willwh> doing it in my grub conf is probably going to get tossed on with new kernels?

[15:39:11] <willwh> s/on/out

[15:50:21] <crunch-choco> how does Mongo's find work? does it browse all the database with a loop?

[15:54:40] <crunch-choco> i mean, is it better for me to make a Find in the entired db, or should i manually filter before doing a Find

[19:42:45] <mzarella> what does the timestamp look like for a document in a collection?

[19:42:56] <mzarella> i am looking to use the nodejs mongodb driver

[19:43:08] <mzarella> does it look like a javascript timestamp?

[19:53:27] <mzarella> is it not recommended to create a date property for an object like this: {a: 1, date: new Date()}

[22:29:01] <stiffler> hi

[22:29:16] <stiffler> anybody use sublime text?

[22:30:18] <stiffler> I wonder about its license

[22:30:21] <stiffler> its weird

[22:30:43] <stiffler> it sounds like it would be non expire free to use trial version

[22:30:53] <stiffler> there is nothig about commercial use