How long are the push notifications stored in the database? How big can this database get?
1) User can't have more than 100 messages with statuses "Sent" or "Error" for one application. So every time when user sent message, we check such messages and delete the oldest ones (for current application) from database.
Okay, great...self maintaining.
2) All push notification messages for application will be removed from database, if user deletes this particular application.
Okay.
3) User can delete push notification messages by himself, if he goes to Tab: Push Notification > open application > sub-tab> Scheduled push notifications> click on cross icon.
User would have no access to this only us.
Thanks for the information. I just wanted to make sure we did not need to maintain this table.
Hi rblanchard, I'm trying to find you answers to your 2 questions... Sorry for the delay.
Hi rblanchard,
Let me answer your questions.
There is no direct timeframe limitation for storing push notifications in database. However, here are some points regarding the deletion of push notifications from DB:
1) User can't have more than 100 messages with statuses "Sent" or "Error" for one application. So every time when user sent message, we check such messages and delete the oldest ones (for current application) from database.
2) All push notification messages for application will be removed from database, if user deletes this particular application.
3) User can delete push notification messages by himself, if he goes to Tab: Push Notification > open application > sub-tab> Scheduled push notifications> click on cross icon.
1) User can't have more than 100 messages with statuses "Sent" or "Error" for one application. So every time when user sent message, we check such messages and delete the oldest ones (for current application) from database.
Okay, great...self maintaining.
2) All push notification messages for application will be removed from database, if user deletes this particular application.
Okay.
3) User can delete push notification messages by himself, if he goes to Tab: Push Notification > open application > sub-tab> Scheduled push notifications> click on cross icon.
User would have no access to this only us.
Thanks for the information. I just wanted to make sure we did not need to maintain this table.