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 over 1 year ago in Data Modeling & Indexing 1 Submitted

3 VOTE

Deny Network Access to MongoDB Cluster

To improve network security, please create an option to Deny specific Network Adresses to MongoDB Cluster.

Guest about 5 years ago in Database 1 Submitted

3 VOTE

view on nested array

* It is quite common to have nested array in documents in MongoDB. * It is also quite common to have to "flatify" those arrays in queries. Here is an example where we have a collection with consultants and their professional experiences. ``` con...

Guest over 5 years ago in Database 0 Submitted

2 VOTE

Add hash function (eg. md5) to aggregation pipeline

I would like to implement hash-based sharding in my own application on top of MongoDB. For that purpose, I would like to pull a stable pseudorandom subset of documents into each of my servers, and I would like to do so without enlarging the docume...

Guest over 3 years ago in Querying & Aggregations 0 Submitted

2 VOTE

$dateDiff operator should be useful to calculate age

In the documentation it says: " For example, two dates that are 18 months apart would return 1 year difference instead of 1.5 years.". But if startDate is 2021-08-01 and endDate is 2023-02-01, the result is 2 years difference. I think it should be...

Guest over 3 years ago in Querying & Aggregations 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 over 3 years ago in Data Modeling & Indexing 0 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

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

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 almost 2 years ago in Querying & Aggregations 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 over 5 years ago in Database 0 Submitted

Please enter your email address

FILTER BY CATEGORY