I have a large set of records in this schema: { username: "[email protected]", timestamp: 1646006400000 //unix timestamp in milliseconds amount: 100 } Given an arbitrary range of dates, I need to find the change in average amount value vs a…
I have this schema to represent a user: const UserSchema = mongoose.Schema({ username: { type: String, required: false }, social: [{ facebook: { type: String, required: false }, twitter: { type: String, required: false } }] }); how can I…
How do we enable PyMongo to read from the nearest? This field db.read_preference is read-only now. from pymongo import ReplicaSetConnection from pymongo import ReadPreference db = ReplicaSetConnection('localhost:27017', replicaSet='rs1')['my_db'] db.read_preference = ReadPreference.NEAREST db.tag_sets = [{'secondaries': 1}]
I have a simple node express app and I just try to connect to my MongoDB atlas. But It pulls this error. I also deleted node_modules and download all packages again but it doesn't work. I get this error: Cannot…
I'm trying to connect my MERN stack application to MongoDB by using mongoose but I'm getting this error even if I am using dotenv file or directly. I've search for many solutions but didn't work for me, please help if…
I am trying to count how many times does a particular value occur in a collection. { _id:1, field1: value, field2: A, } { _id:2, field1: value, field2: A, } { _id:3, field1: value, field2: C, } { _id:4, field1:…
I want to delete a document after a specified amount of time. Like if the user selects 24 hours then it should be auto-deleted after 24 hours. I heard about TTL in mongo but in that, I have to specify…
I am trying to link two tables in mongo db. I have a User table where user has an _id. And a News table where the columns should be _id(for the news) and the userId (to link news to a…
I'm trying to make a timer that would check when the last request to a specific path was made and if the last request was made more than a minute ago, I want the script to delete a document from…
I have created a MERN app with MongoDB Atlas such that node runs on port 3000 and react runs on 3001 and connected the node end points to react. the Docker file for react is FROM node:14 WORKDIR /usr/src/app COPY…