Database
293 results found
-
JSON
I'm converting a lot of data for export from MongoDB -> Postgresql
I would like an aggregation function to convert an object to JSON
{
"$addField": {
"_id": true,
"json": {
'$convert': {
'input': '$subdocument',
'to': 'json', # // Idealy, +1 for msgpack https://msgpack.org/
}
}
}
}thus object.json would be a STRING "{abc: true}"
FYI: Postgresql supports JSON(B) in it's field structures: https://www.postgresql.org/docs/current/datatype-json.html
1 vote -
Self-Managed Computed Collections
This feature would enable MongoDB to automatically generate common patterns by computing entire collections. A particularly useful application would be the ability to identify duplicate fields within a collection and create a computed collection that groups all possible duplicate together.
Sometimes, a field is duplicated between two documents, while another field in the same document is duplicated across seven other documents. Each of these seven documents might have fields that are duplicated in yet other documents, leading to a vast iteration in search of possibilities.
Having MongoDB abstract all this logic in a performant manner to create computed collections would…
1 vote -
Make account connections stable
My account is stuck in "We are deploying your changes (current action: configuring MongoDB)" endless loop for the entire eveing and I cannot finish my project for tomorrow. Cannot connect to my database even with a saved IP.
Yes it's a free account, but this is not a way to just kill any possibility to connect to a simple database. This is a flop1 vote -
Fine-tune the update privilege action
We want our devs to be able to update docs, but only one at a time. If they need to update a bunch together, they should check in with the DBA. Right now, we can't fine-tune the update permissions like we'd prefer, so we're looking into ways to make that happen. This will help us manage document updates better and add a layer of security.
1 vote -
Fine-tune the update privilege action
We want our devs to be able to update docs, but only one at a time. If they need to update a bunch together, they should check in with the DBA. Right now, we can't fine-tune the update permissions like we'd prefer, so we're looking into ways to make that happen. This will help us manage document updates better and add layer of security.
1 vote -
no puedo crear bases de datos
quiero elegir un servicio para crear la base de datos y no me deja en cuanto selecciono free o cualquier otro me envia al overview y nunca puedo terminar de apretar el boton para crear la base de datos
1 vote -
AWS IAM Role integration with MongoDB On premise
We are planning to integrate AWS IAM Roles/Users with MongoDB On-premise for password-less authentication. So the authentication happens through IAM Profile. However, we noticed currently MongoDB on-premise doesn't support AWS IAM Role integration. This is a blocker. We want the authentication would happen through AWS IAM Profile rather than Standard Credentials.
This would eliminate or significantly reduce the use of Database Credentials while tightly integrating with AWS Services. Simultaneously, applications can securely connect to MongoDB via AWS Profile.1 vote -
array length as computed to be indexed
in some cases, I need to filter only docs with specific (or range of) sizes of nested arrays.
it will be good if I can configure 'automatic index' to keep the length of the array, based on the field name I will provide to the index, and then I can easily get the docs.(now I need to add and maintain this field on myself or with trigger)
1 vote -
session
The possibility configure what network or IP the user can be connect in the cluster in the mongo atlas.
1 vote -
Allow disabling auto removal for capped collections
Capped collections work as a circular buffer - when adding new documents after the size limit is reached, old documents are removed.
I would like to have an option for the collection, where this behavior can be changed - instead of removing old documents, the insert should fail with a specific error (eg: collection full). This would allow implementing log-rotation, by creating a new collection whenever the old one is full.
My motivation:
I have two services, one creating documents (events), and another one processing them. I'm looking for a reliable way to:
- process all documents from start, without…1 vote -
add index on oplog collection which will avoid full collection scan where change stream enabled , as of now full scan causing high cpu
add an index on oplog collection for change stream to avoid full collection
1 vote -
placement of mongosh,mongo tools and mongo binary inside core bin
Hi Team,
Hope you are doing great!
Didn't understand the purpose of keeping mongosh,mongo tools and mongo binary separately, can't this be place in a single rpm/tar file so that it can be easy the installation process.
As per the current :
Mongo binary location :/var/lib/mongodb-mms-automation/mongodb-linux-x86_64-6.0.8-ent/bin
Mongo Tools location :
/var/lib/mongodb-mms-automation/mongodb-database-tools-linux-x86_64-100.7.4/bin
Mongosh location :
need to keep this file in separate location and access the mongodh. mongosh-1.10.1-linux-x64.tgz
Thank you
1 vote -
Allow rotation of Arbiter TLS certificates when authentication is enabled
Mongo arbiters do not support using db.rotateCertificates(), because they do not possess the internal table of user and role mappings used for authentication.
Add functionality to enable rotation of these certificates.
1 vote -
Exclude PDB files from installation
mongod.pdb is nearly 1.0GB, mongos.pdb - 0.5GB
Since these fils are not necessary for the server to function properly, they should be optional, e.g. provide a checkbox to exclude them during installation.
1 vote -
DB Snapshot triggers when RDS Snapshot starts.
Looking for a feature regarding DB Snapshots, so that we can configure a Snapshot Policy to be triggered whenever a specific AWS RDS snapshot starts (for the daily schedule).
Thank you in advance.
1 vote -
Vector Search
Provide Vector Search capability in MongoDB enterprise edition for On-premise deployments.
1 vote -
Allow live migration using private interface
There should be an option to live migrate data via a private interface instead of public one. With VPC being peered, it would be a great option to avoid exposing database to the public interface (even if it's specific set of IPs). This can resolve concerns of many customers who are following or need to follow some short of compliance on their end.
1 vote -
an aggregation stage to load data to DRAM for the fields that are only requested
When we use $project stage, it loads whole document from disk to memory (if not in working set). Because of this, When we create a data model, We have to create separate collection if the field is not required in frequent access of data. Creating a view is an option, but what if $project itself or $project with some argument in it, or a new pipeline stage or operator gets introduced which fetches the data from disk only for the fields specified instead of loading whole document.
With memory mapped file, retrieving fields specified alone would not be simply possible…
1 vote -
When was last backup/mongodump ran on databases or database backup history
How can get detail of last backup was taken using query. Its very hard to get into log file and see the history of mongodump. Just like other database tool mongodump history can be retrieved via query instead mongo log file.
I know get the detail from ops manager if using enterprise only but what if we are using community edition.
If you include this feature it will very helpful for DBA to get the details juts like other database tools available in market.
1 vote -
$group all fields
$group should have the ability to allow specifying all fields in a document (without explicitly defining them all, which can lead to duplicating dozens of lines just to do "key: $first")
This will help users that use $unwind and then want to $group the results without having to do a subsequent $lookup and $mergeObjects (or similar) to get the final document structure they're looking for.
1 vote
- Don't see your idea?