<    April 2017    >
Su Mo Tu We Th Fr Sa  
                   1  
 2  3  4  5  6  7  8  
 9 10 11 12 13 14 15  
16 17 18 19 20 21 22  
23 24 25 26 27 28 29  
30
00:00 `jpg joined
00:26 LouisT joined
00:26 YoY joined
00:29 timg__ joined
00:46 joshontheweb joined
00:52 castlelore joined
00:52 castlelore joined
00:56 Gwayne joined
01:07 `jpg joined
01:11 <Squarism> Does mongo db have 47 chromosomes?
01:24 edrocks joined
01:38 kyuwonchoi joined
01:44 artok joined
02:01 `jpg joined
02:08 freeport joined
02:17 sumobob joined
02:24 realisation joined
02:25 realisation left
02:38 firebalrog joined
02:42 orbyt_ joined
02:51 YoY joined
02:52 culthero joined
02:52 jeffreylevesque joined
02:55 raspado joined
02:55 sumobob joined
02:57 orbyt_ joined
03:03 SkyRocknRoll joined
03:10 SpeakerToMeat joined
03:10 fels joined
03:18 `jpg joined
03:32 firebalrog joined
03:33 fels joined
03:33 hfp_work joined
03:42 jri joined
03:43 jr3 joined
04:09 svm_invictvs joined
04:12 jr3 joined
04:16 timg__ joined
04:16 sumobob joined
04:51 ayogi joined
04:59 n0arch joined
05:05 ninjada joined
05:08 edrocks joined
05:10 firebalrog joined
05:12 firebalrog joined
05:13 lpin joined
05:17 firebalrog joined
05:17 timg__ joined
05:17 firebalrog joined
05:37 quattro_ joined
05:38 fels joined
05:41 VeeWee joined
05:47 orbyt_ joined
05:51 firebalrog joined
05:56 firebalrog joined
06:02 preludedrew joined
06:02 VeeWee joined
06:06 Skuzzzy joined
06:07 <Skuzzzy> I have knowledge of SQL, trying to write some mongo queries out off interest, is there a good guide of mapping sql ideas to mongo (obviously issues with underlying data model, but just from a usage perspective)
06:07 <Skuzzzy> Like I want a basic SELECT FROM WHERE GROUP BY HAVING sql query put into mongo
06:08 <firebalrog> The mongo website has some basic sql to mongo information.
06:08 <Skuzzzy> yes, did find https://docs.mongodb.com/manual/reference/sql-comparison/ this just now, examining it
06:10 <firebalrog> yup thats the page was just looking it up for you
06:11 <firebalrog> goodnight
06:18 timg__ joined
06:18 orbyt_ joined
06:30 rendar joined
06:33 coudenysj joined
06:46 quattro_ joined
06:52 _jd joined
06:52 <Skuzzzy> Suppose I have a aggregation pipeline that at a particular step I have a "ratings" : [ 4, 7, 7, 4 ] and I only want to let this pass through further in my pipeline if all ratings are above 5
06:52 Doow_ joined
06:52 <Skuzzzy> would a match following this be correct?
06:53 <Skuzzzy> ($match ($gt ($min ratings) 5)) not exactly sure how to express this
06:54 jri joined
06:56 skot joined
06:56 AlexejK joined
06:57 AvianFlu joined
06:57 kevc_ joined
06:57 Garo_ joined
06:57 PerpetualWar joined
06:57 cpama joined
06:57 siruf joined
06:59 evil_gordita joined
06:59 sftp joined
07:00 marc0s joined
07:00 amackera joined
07:02 <Skuzzzy> hm, I'm now just trying to make a filter that grabs the min of the list, but still struggling with the syntax
07:06 mylord joined
07:07 aV_V joined
07:10 <aV_V> I would like my id field to be an UUID. How do I generate and store on java?
07:10 <aV_V> Following the doc. https://docs.mongodb.com/manual/core/document/#the-id-field
07:11 <aV_V> I set the id as BinData type but java doesn't recognize such type
07:14 <Skuzzzy> whoo! Figured my thing out! I hate the syntax so far
07:18 fels joined
07:18 timg__ joined
07:19 <aV_V> " store the UUID as a value of the BSON BinData type" how I do that on Java?
07:20 Cust0sLimen joined
07:22 shortdudey123 joined
07:23 coudenysj joined
07:29 Folkol joined
07:31 Lujeni joined
07:32 <aV_V> ok, BinData is just the mongo type stored, not a Java type. So I must define my id as java.util.UUID i guess
07:40 fels joined
07:45 Folkol joined
07:54 Silenced joined
07:55 jri_ joined
07:57 jri__ joined
08:00 SkyRocknRoll joined
08:07 armyriad joined
08:30 art-solopov joined
08:31 bweston92 joined
08:34 <art-solopov> Hi! I'm working on one of my pet projects: a web app for managing projects (think Redmine's or Jira's gimp clone). I've recently had an idea to use MongoDB for it. It seemed like a good idea for me because the main limitation of MongoDB (lack of multi-document transactions) doesn't seem to be that important in such systems (in my experience, the entities are usually changed independently of each other). On the other hand,
08:34 <art-solopov> having quick reads could be very useful when it comes to such systems. What do you think? Is it really a good idea or am I missing something here? Thank you.
08:46 gfidente joined
08:47 <Derick> art-solopov: MongoDB works well as a generic database
08:49 dbarrett joined
08:54 culthero joined
08:55 jwd joined
09:08 mbwe joined
09:22 synchroack_ joined
09:30 kyuwonch_ joined
09:36 kexmex joined
09:46 `jpg joined
09:48 jri joined
09:50 jri joined
10:11 mylord joined
10:31 synchroack_ joined
10:32 aV_V joined
10:39 mylord joined
10:51 undertuga joined
10:58 coudenysj joined
11:05 lpin joined
11:10 edrocks joined
11:15 mylord joined
11:24 kexmex joined
11:25 Folkol joined
11:30 artok joined
11:33 SpeakerToMeat joined
12:03 `jpg joined
12:09 StephenLynx joined
12:13 coudenysj joined
12:14 `jpg joined
12:15 coudenysj joined
12:21 `jpg joined
12:25 yeitijem joined
12:27 `jpg joined
12:49 edrocks joined
12:54 trevor joined
12:55 freddy_ joined
12:58 <freddy_> I am trying to use mongodb node in node red. It is showing me following error "MongoError: Sort exceeded memory limit of 104857600 bytes, but did not opt in to external sorting. Aborting operation. Pass allowDiskUse:true to opt in." I tried different way to use use allowDiskUse but none of them is working
12:58 <freddy_> I have tried msg.allowDiskUse = true;
12:58 <freddy_> msg.payload.options = { allowDiskUse: true };
12:58 <freddy_> msg.payload.allowDiskUse = true;
12:59 <freddy_> so how exactly should I use allowDiskUse in node-red
12:59 <freddy_> I can't find anything on internet except https://groups.google.com/forum/#!topic/node-red/2EKmS4Hwo8E
13:00 jeffreylevesque joined
13:02 ramortegui joined
13:04 firebalrog joined
13:08 jr3 joined
13:09 edrocks joined
13:16 freddy_ joined
13:17 fredd____ joined
13:19 fred_____ joined
13:19 coudenysj joined
13:20 coudenysj joined
13:21 coudenysj joined
13:22 coudenysj joined
13:25 kyuwonchoi joined
13:37 coudenysj joined
13:49 gentunian joined
13:53 jayline joined
14:00 geoffb joined
14:06 culthero joined
14:06 culthero joined
14:10 freeport joined
14:12 sumobob joined
14:14 DroidBurgundy joined
14:14 orbyt_ joined
14:33 kyuwonchoi joined
14:41 freeport joined
14:41 coudenysj joined
14:45 gentunian joined
14:45 DrYucatan joined
14:45 <DrYucatan> Does mongod need to be running to do a mongodump?
14:49 <Derick> yes
14:50 <DrYucatan> coolio
14:51 <* DrYucatan> has never used mongo and has to learn it for work
14:53 re1 joined
15:13 coudenysj joined
15:18 yeitijem joined
15:22 artok joined
15:27 fmt_caret joined
15:28 SkyRocknRoll joined
15:41 coudenysj1 joined
15:42 kyuwonchoi joined
15:48 sumobob joined
16:01 tambu joined
16:03 <tambu> Hey guys is it ok to ask for query help? https://pastebin.com/4qJJMp37 basically i'm trying to do a query like this.. but obviously it doesn't work: db.data.find({‘tasks.*.name’: ‘checkSyncDevices’})
16:08 <sumobob> tambu I'm not an expert but check out $elemMatch
16:08 <sumobob> looks like that might be what you need
16:09 <tambu> sumobob Thanks.. I was trying that but felt like it was only for inside array.. I'll take another look
16:19 edrocks joined
16:19 coudenysj joined
16:21 louie_louiie joined
16:27 svm_invictvs joined
16:32 freddy_ joined
16:33 jri joined
16:33 jaequery joined
16:34 Keverw joined
16:35 freddy___ joined
16:36 edrocks joined
16:38 coudenysj joined
16:38 <fmt_caret> tambu: you might need to use the aggregation framework with that data structure. it would be easier if tasks was an array
16:39 SpeakerToMeat joined
16:40 <tambu> fmt_caret: chuckle I've found four article off google saying that the schema design is a bad way to go and to use an array.. so I'm not surprised.. "aggregation framework" I'm not certain what that means lemme google it or is there something u can point to? We did figure out a way to do it with javascript inside the mongo query but that seems excessive..
16:40 <fmt_caret> tambu: https://docs.mongodb.com/manual/aggregation/
16:41 <tambu> thanks :)
16:41 <fmt_caret> sure thing. i haven’t thought through whether that will actually allow you to make the query that you want, but the aggregation framework definitely provides more query flexibility
16:42 freddy_ joined
16:47 quattro_ joined
16:48 alexi5 joined
16:49 kyuwonchoi joined
17:01 freddy_ joined
17:02 freddy_ joined
17:06 DroidBurgundy joined
17:12 hfp_work joined
17:15 orbyt_ joined
17:28 synchroack_ joined
17:34 harttho joined
17:40 gentunian joined
17:50 alexi5 joined
17:51 jri joined
17:58 kyuwonchoi joined
17:59 Sasazuka joined
18:01 artok joined
18:17 fels joined
18:32 <sumobob> hmm I'm doing a group and then my project has a $cond statement in it
18:33 <sumobob> i group based on week and year, and a boolean
18:33 <sumobob> then do a $cond in my project based on that
18:35 <sumobob> is there any way i can take these two object and smush them together based on the new _id?
18:44 jr3 joined
18:48 _yoy_ joined
18:56 alexi5 joined
19:02 rendar joined
19:03 coudenysj joined
19:07 kyuwonchoi joined
19:09 kexmex joined
19:27 sz0 joined
19:27 coudenysj joined
19:32 artok joined
19:46 apollonovich joined
19:47 <apollonovich> Is writing a custom storage engine a practical approach to getting a real-time replica of a mongo cluster in a different system? Or am I better off tailing the op log?
19:48 `jpg joined
19:48 <apollonovich> And, further, are there any 3rd party storage engines in common use, or is it WiredTiger for basically everyone?
19:49 `jpg joined
19:50 `jpg joined
19:51 `jpg joined
19:52 `jpg joined
19:53 `jpg joined
19:54 `jpg joined
19:54 `jpg joined
19:58 cime joined
20:08 sumobob joined
20:11 <atbe> hi peeps, is it possible for me to grant a role that only allows reads and inserts in mongodb 3.4?
20:12 <atbe> I found this page but it does not specify if I an create my own roles https://docs.mongodb.com/manual/reference/built-in-roles/
20:12 <atbe> I want to prevent the collections from being dropped or documents removed by a specific user
20:13 <atbe> readWrite seemed okay but it allows drops and removes
20:15 kyuwonchoi joined
20:28 sumobob joined
21:04 SpeakerToMeat joined
21:09 `jpg joined
21:13 okapi joined
21:17 brk_ joined
21:25 kyuwonchoi joined
21:25 StephenLynx joined
21:29 jeffreylevesque joined
21:37 re1_ joined
21:38 re1_ joined
21:40 re1_ joined
21:50 fels joined
22:09 apollonovich joined
22:10 LouisT joined
22:19 apollonovich joined
22:20 `jpg joined
22:24 `jpg joined
22:29 `jpg joined
22:33 kyuwonchoi joined
22:42 LouisT joined
22:56 SpeakerToMeat joined
23:33 silenced joined
23:37 re1 joined
23:42 kyuwonchoi joined
23:43 orbyt_ joined
23:43 silenced joined
23:48 gentunian joined
23:57 orbyt_ joined