CODEWITHSUNDEEP
mongodbmongodb-query
Cameron Roberson
Cameron Roberson

Reputation: 13

Automated functions in Mongo DB

I was wondering if there is something like a script that I can write on the MongoDB side that would do something like delete an item in a list if it is older than a week old etc.

I want to have the DB do this check every day. Are there some kind of automated functions that I can setup on the DB to do this?

I could just write a few small methods to do it on the userside myself, but I remember my old SQL DB having this feature. Any help would be appreciated. Thanks,

Upvotes: 0

Views: 832

Answers (2)

rom1bl
rom1bl

Reputation: 153

Then you might want to check out the MongoDB TTL feature :

https://docs.mongodb.com/manual/tutorial/expire-data/

It won't run every day like a script, but it will automatically remove data after some time.

Hope it can help !

Upvotes: 1

tbhaxor
tbhaxor

Reputation: 1943

If you are using Self-Managed MongoDB, The answer is NO.

Like SQL, MongoDB doesn't support scheduled transactions. However you can run the scheduled jobs in your programming language and perform the operations. For example, https://thecodebarbarian.com/node.js-task-scheduling-with-agenda-and-mongodb

If you are using MongoDB Atlas, Then you need to check this https://docs.mongodb.com/realm/triggers/scheduled-triggers/

Upvotes: 1

Related Questions