delete old data to clean up database

[rubo77]

add a config value to set a timout for all data in the homeserver.

If you want to run a server with ephemeral data, there should be an option that everything is deleted e.g. after 7 days.

• users that didn't log in should be deleted
• history deleted
• invites, etc.

[rubo77]

You could add a cronjob, that calls the script suggested in #1034 regularly on all rooms

[fuzzy76]

Would be interesting if someone could make a script that find all rooms automatically first.

[rubo77]

You find all rooms with simply

sqlite3 homeserver.db "pragma busy_timeout=20000; SELECT room_id FROM rooms"

If you look for the names use

sqlite3 --header homeserver.db "pragma busy_timeout=20000; SELECT n.name, r.room_id FROM rooms r, room_names n WHERE n.room_id=r.room_id limit 1"

[rubo77]

If you want to call it via a script you can use the script from my PR here: #1034

[rubo77]

A start would be to "Redact all events older than a certain time" #1730

[rubo77]

This tool also calls the purge API in a configurable task: https://github.com/aperezdc/synpurge