0x111 / telegram-rss-bot

RSS bot for telegram written in Go
MIT License
41 stars 21 forks source link

Database size #10

Open 0x111 opened 3 years ago

0x111 commented 3 years ago

Right now, we have a .db file where we store all the data in a sqlite database format. This works well, because users don't need to run a separate database server and can use a file based database basically anywhere without extra installation steps.

The database grows over time, depending on how many feeds do you have and how often they publish new entries. We need a cleanup for old records and simply remove them periodically to make the database size as small as possible.

We do not need old entries anyways for long-term. If this is a problem it could be a flag, to turn it on/off based on user preference. Someone might want to save the history maybe.