Skip to content

Andre

My feedback

3 results found

  1. 2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    planned  ·  2 comments  ·  Compass » General  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    Andre commented  · 

    Thank you for quick feedback and a work-around.

    I have Visual Studio and VS Code installed on this computer, so it's a bit surprising that it wouldn't find some usable monospace font equivalent.

    Andre shared this idea  · 
  2. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Database » Indexes  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Andre shared this idea  · 
  3. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Database » Query and Aggregation Pipeline  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    Andre commented  · 

    Just wanted to add that in case if it wasn't very clear from my response, the original suggestion *does* use the `localField`/`foreignField` form where it's suitable, which only works for aggregating array sub-objects, such post comments or reviews.

    What the suggestion does outline is that for 1-to-1 joins, which just need a few fields from the foreign collection and is a very common use case, the syntax becomes nightmarish and if Mongo DB would came up with a straightforward 1-to-1 join syntax, it would work very well for many Mongo DB users who want to use simple references, like we do in SQL, rather than having to update tens of thousands of denormalized documents, like we have to do today.

    PS Can somebody please look at the broken Markdown formatting of these comments and the ridiculous 5-line window size on this site?

    An error occurred while saving the comment
    Andre commented  · 

    Thanks for the response, Katya.

    `$match` in my example isn't used as a replacement of the form with `localField`/`foreignField`, but because I need only those fields from the linked collection and this is the only way not to pull the entire linked object, but rather just fields required for this join.

    In reality, only simple aggregation pipelines use the `localField`/`foreignField` form and in most cases the pipeline form would be used to control what's returned and how it is named via the projection.

    The ask really is to recognize 1-to-1 joins or allow people to specify them explicitly, so one doesn't have to jump through the hoops manipulating all these sub-objects - it makes queries quite convoluted and also cannot be good for the server that needs multiple BSON operations to perform all those merges and unwinds.

    Andre shared this idea  · 

Feedback and Knowledge Base