PMXBOT Log file Viewer

Help | Karma | Search:

#mongodb logs for Sunday the 4th of November, 2018

(Back to #mongodb overview) (Back to channel listing) (Animate logs)
[07:57:00] <rubal> hello
[07:57:08] <rubal> I am on MongoDB shell version: 3.0.15 I have been analysing a query and I didn't understand the specific behaviour For: db.redaction_requests.find( {"state" : { $in : [6 , 2]}}).explain(true) the keysexamined and nreturned are correct: 2568 docs but for db.redaction_requests.find( {"state" : { $in : [6 , 2]}}).limit(1000).explain(true) the nreturned becomes 101 and keysexamined 102 A proper index hits for this query and ixscan i
[11:59:57] <xpsx> hello, i'm new to mongo (and nosql databases in general), and don't know what to look for exactly, maybe some of you could point me towards what i'm looking for? what i have are two databases, users and orders. and what i'm trying to do is get the number of orders for each users, without looping through both collections. in sql i'd just do this: https://gist.github.com/xprnio/5290d2920bcb680ecec895e57cccb0bd
[12:00:13] <xpsx> two collections*, not databases
[12:03:08] <xpsx> something that sort of works is $lookup, but all i could figure out so far with that is how to get all users, and their associated orders (but not the count of them). https://gist.github.com/xprnio/5290d2920bcb680ecec895e57cccb0bd#file-nosql-js
[12:12:36] <xpsx> hello, i'm new to mongo (and nosql databases in general), and don't know what to look for exactly, maybe some of you could point me towards what i'm looking for? what i have are two databases, users and orders. and what i'm trying to do is get the number of orders for each users, without looping through both collections. in sql i'd just do this: https://gist.github.com/xprnio/5290d2920bcb680ecec895e57cccb0bd
[12:12:42] <xpsx> something that sort of works is $lookup, but all i could figure out so far with that is how to get all users, and their associated orders (but not the count of them). https://gist.github.com/xprnio/5290d2920bcb680ecec895e57cccb0bd#file-nosql-js
[16:27:19] <guardian> hello
[16:27:24] <guardian> I'm confused by https://jira.mongodb.org/browse/WT-2880
[16:27:30] <guardian> is zstd supported in Mongo 4?
[17:00:27] <tyteen4a03> I've got some aenum.Enum's. How can I write custom encoders to ensure they get converted to bson correctly?
[17:00:37] <tyteen4a03> (in pymongo)
[17:06:25] <tyteen4a03> ok, looks like I should transform them myself before passing them into pymongo