I have a MongoDB collection with 8k+ documents, around 40GB. Inside it, the data follows this format: { _id: ..., _session: { _id: ... }, data: {...} } I need to get all the _session._id for my application. The following…
I'm using Mongodb on azure (not Mongodb Atlas), I installed manually Mongodb on three VMs on Azure, what I'm looking for is, everytime a new record is inserted or updated or delete on Mongodb I want this change to be…
I'm using an Atlas based mongodb instance and fastify for backend. I'm also using @sinclair/typebox to generate JSON Schemas for data validation. Normally, I use these schemas to validate input messages but I now want to reuse them as validators…
Hello, I'd like to get all the documents where categories array has an element with key CONSULTANT_AGREEMENT and the respective subCategories array inside the CONSULTANT_AGREEMENT category contains only one element. Is this possible in MongoDB or should I write a…
I'm trying to get amount of objects saved in MongoDB with db = myclient.database_sample my_collection = db["database"] mydoc = my_collection.find().count() print("The number of documents in collection : ", mydoc) but I'm getting an error mydoc = my_collection.find().count() AttributeError: 'Cursor' object…
I was wondering if there was an actually good way to aggregate/calculate percentiles based on all data in a database. For example, data like: { 'name':'John' 'rank':5 }, { 'name':'John' 'rank':4 }, { 'name':'John' 'rank':5 }, { 'name':'James' 'rank':3 },…
I am trying to get the last document in a MongoDB collection. The following works in the Mongo shell: db.collection.find().limit(1).sort({$natural:-1}) Results in the last object like so: { "_id" : ObjectId("62c8817075c9400469b1fc3a"), "token" : "135e53ebb05aa2b6055513843cb8e0dca1", "createdAt" : ISODate("2022-07-08T19:11:44.730Z"), "updatedAt" : ISODate("2022-07-08T19:11:44.730Z"),…
i m creating a small shop app with: node.js & express and mongoose and I m facing a problem when I try to send the data to the mongoose database this is my product class const mongoose = require("mongoose"); const…
Let's image that we have a simple endpoint called CreateEntity in some .NET Core controller and we have two services which saves the entity to the Mongo and Neo4j databases (in this particular order). I want to implement some pattern…
I am using MongoseDB in order to receive some information about an item. When i try to search for it, it finds it with no trouble, but for some reasons this function is not pushing them into my array. I…