How to create new object for a new date in mongodb?
I want to change the value of a variable named count in mongodb. Count is needed for every day.
For example, if count changes from 15 to 17 in one day, i want to update the existing object. Again start the next day with 0 and keep track of it.
This way I will have 365 objects(in a year) for a user which has the count value for each day.
How to do it in mongodb? or is relational db more suitable for this?
Solution
Create an array of objects (counters) in the document and save the counter in a specific object.
- How to return JSON objects without explicit aliasing in postgresql
- Reading SQL-table by pandas raises NotImplementedError
- Sharing databases between projects within Intellij
- SQL replace colum value with a specific string
- How can I run just the statement my cursor is on in SQL Server Management Studio?
- Error calling procedure in posgres "No procedure matches the given name and argument types. You might need to add explicit type casts."
- MySql views performance
- Storing 2 same id of post table with different language into database
- Error while trying to migrate data from one table to another in BigQuery
- How To Import a Big .csv(~2GB) Into a PostgreSQL Table
- Optimistic vs. Pessimistic locking
- Unable to Initialize and Start MySQL in XAMPP on Windows 11 - Can't Connect to MySQL Server (10061)
- TypeORM limit number o created connections with createConnection(...)
- Update DB field at midnight each day according to user timezone
- Postgres AWS RDS Database high load during random moments
- SQLAlchemy: How can I update the table in the database when I update the model in models.py
- SQL Query - Ignore row if data is null for multiple rows on single condition
- How do I relate requesters of different type?
- How can I get a separated row instead of a CSV concated group?
- YYYYWW format in SQL Redshift
- How to use the physical location of rows (ROWID) in a DELETE statement
- Maximum number of records in a MySQL database table
- MySQL query that selects all users that have more than one entry per day
- Error connecting to Postgres database, but can connect on pgadmin
- LENGTH of ARRAY [42883]: ERROR: function array_length(text[]) does not exist
- Is there a way that i store timestamp with time zone in Postgres and not converting it to UTC
- follower/following relationship
- Laravel - Rollback specific eloquent transaction after many other transactions committed
- how to use RBAC on azure?
- Enable binary mode while restoring a Database from an SQL dump