Expiring old entries - ever growing database problem
The database is constantly growing, even with one active user, not sharing with and being shared with much.
Since I have started running my pod, according to phpMyAdmin the whole database has grown to ~2,661,012 entries with a data usage of 2.8 GiB (!) and only my "little" pod.
The feature should be configurable through yaml config or admin interface.
Updated from comment poster:
-->Only the pod of the original poster is obliged to store the post forever. The other pods can expire the post if no user fetched it for a certain time period. If the pod expires the post it removes everything except the posts metadata from the database. The metadata includes all the stuff needed to keep the post searchable (id, posting user, hashtags). If the pod ever needs the post again it will fetch it from the original posters pod.
This should significantly reduce the database size (especially for small pods) while keeping all posts accessible if needed.