How do you plan to fill the database? Is it just one big database and you will cycle it or you plan to add to it every day?

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.