nina_xmpp icon indicating copy to clipboard operation
nina_xmpp copied to clipboard

Database cleanup job

Open jplitza opened this issue 1 year ago • 0 comments

The IDs of handled events accumulate over time, so they need to be cleaned up! (For reference, my database is still <6MB after 2 years of operation.)

We probably need to introduce a timestamp column in the events table that gets updated every time we see the ID in a feed. Then we could delete IDs that haven't been seen for a configurable amount of time (like 7 days).

jplitza avatar Oct 01 '22 18:10 jplitza