A Car has a Brand. So, many Cars have the same Brand. How do you do to map these objects to store in the Firestore? What is the best practice for that? We need to think that a Brand can…
Currently I'm trying to develop a PostgreSQL database schema, it has only 2 tables, one of which contains usernames. The difficulty is that for certain reasons I cannot store the username directly, so I have to store the hash (SHA256).…
I have this mongo query db.getCollection("users").updateMany({ _id: ObjectId('65d8fd25618ef79985233636') }, { $set: { questionAnswers: { hobbies: "$hobbies", islandItems: "$islandItems", superPower: "$superPower" }}}) I am trying to set variables that already exist on this user object to be inside of a new…
I am learning Azure and I just created a fresh account. I attempted to create a Cosmos DB NoSQL account, choosing the serverless capacity mode. This is for a small educational project that would not require many requests or activity.…
My app has a User collection. Each document in the collection averages about .04 MB. At worst case, a document may slightly exceed .1 MB. Needless to say, these are small documents. However, each document could potentially have over 1000…
I want MongoDB query to minus a day from existing date in a column and update the same. query to update a date like original date = '2024-12-24T18:30:32' updated date = '2024-12-23T18:30:32' and how to execute the query on terminal…
I have data on a MongoDB collection stored in documents like these: { "_id": "657c54befca2b6a2cdd935ba", "data": { "name": "Bob", "surname": "xxx", "age": "20", }, "header": { "data": "1702646974156", } "_class": "Prova" } { "_id": "657c54befca2b6a2cdd935bb", "data": { "name": "Tom", "surname":…
I'm new to NoSQL so I need an opinion on how the flow on how noSQL works. I'm trying to make an employee rewards website where users can use points to redeem rewards such as vouchers, and coupons, etc. Therefore,…
I have alot of JSON objects which seem to be exports of collections exported as one document which contains an array of the documents in the collection. I am having a problem importing it to Mongodb as the way I…
I need to count the number of matching elements between 2 arrays using MongoDB filter aggregation. I tried using $eq and $setIntersection on the condition field of filter but the number of matching elements return just 1 even if all…