I'm trying to find all unique strings of some subdocument in MongoDB, as long as at least one of them contains a certain substring. These strings are localized though. I want to have the results for all possible languages. So,…
The picture shows example oF JSON data I am trying to query "id" value under images field in aws redshift mode. I tried SELECT json_extract_path_text(images, 'id') FROM table_name; This query give me an error ERROR: function json_extract_path_text(super, "unknown") does not…
I’m currently using C# driver (v2.17.1 ) to connect to local Mongo Database and then loop through every document and update a field inside the document. One iteration might take 2 to 5 seconds . This works up until 1.4k…
Struggling to add extra properties and values to the object returned from mongoDB database in NodeJs It is a nodeJs project. There are few items stored in cart table in MongoDB database. The architecture is, the items are fetched from…
I am facing problem while connecting mongodbCompass to Backend enter image description here i trying it to connect backend, but i am facing difficulty to initilize db in mongodb compass, in backend i have connected it, its my first db…
I have a dockerized database : mongodb: image: mongo:latest container_name: mongoose-db ports: - "27017:27017" environment: MONGO_INITDB_ROOT_USERNAME: root MONGO_INITDB_ROOT_PASSWORD: 1234 volumes: - mongodb_data:/data/db I have a Nest.JS project running on http://localhost:3000/ and not inside a dockerized stack. I want to correctly…
module.exports.follow = async (req, res) => { if ( !ObjectID.isValid(req.params.id) || !ObjectID.isValid(req.body.idToFollow) ) return res.status(400).send("ID unknown : " + req.params.id); try { // add to the follower list await UserModel.findOneAndUpdate( req.params.id, { $addToSet: { following: req.body.idToFollow } }, { new:…
I have the following collection: [ { "_id": 1, "favorite": { "color": "red", "foods": { "fruits": "banana", "fastfood": [ "burger", "sandwich" ] } } }, { "_id": 2, "favorite": { "color": "green", "foods": { "noodles": "ramen", "fastfood": [ "fries", "burger",…
On MongoDB the _Id field for some reason is always very similar, so similar that after 20 documents I cant insert more because the _Id will be the same. What I think is happening is MongoDB generates the _Id based…
I have started the working on transaction concept of database but, I don't know when to use transaction and when we should not? Suppose, If I am running simple SELECT * FROM table_name query. So, Do I have to use…