What are the best practices for loading and storing data in a mobile database?

Question

Objective-C

For example, we have a mobile application like VK or Twitter, in which posts are loaded and saved in the database. From the functionality there is pullToRefresh and data loading when scrolling the list. When should you clean up the database? if not cleaned up, the database will grow indefinitely and will affect the performance of the application. And is it worth cleaning it up completely? what are the best practices on this topic? Tried to find something, but so far without result.
I myself assume that you need to store the last few posts, say until a certain date. I will be glad to any advice.

Answer 1

As for VK, there posts are not saved in the database, they are kept in memory. I see no reason to store them in the database, they become obsolete too quickly.