Database

Multiple unique single indexes in sharded collections

MongoDB sharded collection can only have one unique index which is the shard key. However, in real applications, one might need more than one single unique index. "Proxy" collections suggested in https://www.mongodb.com/docs/manual/tutorial/unique...

Guest almost 2 years ago in Data Modeling & Indexing 1 Submitted

3 VOTE

updateMany limit

When porting an application backend from an RDBMS to MongoDB, we've spoken to two people who've are looking for a way to specify a limit on the number of documents in .updateMany(). I understand the behavior cannot be defined on a sharded cluster,...

Guest over 5 years ago in Database 1 Submitted

2 VOTE

Clustered Collection TTL on _id should support ObjectId.

Clustered Collections have the ability to expire on the _id field, this would be really helpful if it could use the timestamp portion of the ObjectId.

Guest almost 4 years ago in Data Modeling & Indexing 0 Submitted

3 VOTE

Option to prohibit a non-voting member from becoming a sync source of a voting member

Hi, Our proposition in a few words: add a replica set option to allow chained replication but with the following exception: a non-voting member cannot become a sync source of a voting member under any circumstance. This proposition would allow c...

Guest almost 6 years ago in Database 0 Submitted

2 VOTE

Support Two Array Fields in Compound Indexes

Hi, I've come across a lot of use cases where the business logic has demanded unique constraints on 1-2 fields that have been modeled as arrays on documents. The cases that only contain a single array field is already taken care of using unique i...

Guest almost 4 years ago in Data Modeling & Indexing 0 Submitted

2 VOTE

Query Planner needs a timeOut set as a Database parameter.

Query Planner needs a timeOut set as a Database parameter. We see App queries timing out on Query planner taking >1 sec. Whilst this can be avoided by setting maxTimeMS at client end - this is more of a setting for the overall query and not ju...

Guest almost 4 years ago in Database 0 Submitted

1 VOTE

Is there any limitation on size of query in pipeline (character in query, not data)

I have an aggregate query, when the character in pipeline over 21066 character, the result return wrong format that the pipeline expected. So I wonder is there any limitation on size of query in pipeline? My case is: Query: [ "$match":{"profileI...

Guest about 2 years ago in Querying & Aggregations 0 Submitted

2 VOTE

We need to be able to use $[<identifier>] and "$setOnInsert" in the same command

I want to be able to have a maintain array of counters for a user through a single update statement. If the document containing array of counters does not exist, I want to add it. If it does exist, I want to increment the counter For example, thi...

Guest about 4 years ago in Database 0 Submitted

2 VOTE

hint support for $graphLookup

Currently you can supply a `hint` to the `aggregation` call in order to tell MongoDB to use a specific index for the initial `$match`. But there is currently no way to specify which index to use for a `$graphLookup` later in the pipeline. I would...

Guest about 4 years ago in Querying & Aggregations 0 Submitted

3 VOTE

Validation for referential integrity

Currently, with the JSON Schema validation, we are able to limit the values for a field using enumerations. However, we need to have a way to limit the values to those entered in another collection.

Guest about 6 years ago in Database 0 Submitted

Please enter your email address

FILTER BY CATEGORY