I've seeded it with 4 months of data (stored statically in json files for simplicity for now), and have a script to add data for additional days, but the plan is to migrate over to a db (curious to try supabase) so that users can save / like individual entries.
SQLite might be a good choice for a project like this.
So all your sources for all categories are automated? My main worry was if you have to hunt for content manually - that might not be sustainable.
This would also be great for Telegram. You could easily forward daily content into a channel. Or even create a bot that allows people to subscribe only to some categories.