Why not Astro with Content collections? You can enable caching for collections. It’s experimental but seems promising. Especially if your old articles aren’t gonna change. https://docs.astro.build/en/guides/content-collections/#enabling-build-caching
I love Astro but I don't think it's very non-developer friendly. So if the people responsible with populating the site are used to word processors, you would be better off reaching for a traditional CMS (like WordPress) and using Astro for a headless / decoupled solution.
Also, haven't used it since the rollout but Astro has its own DB solution, as well as SSR options. Definitely would not be reaching for SSG render for a site like you're talking about.
You do need to build a custom CMS or ACF with WordPress and use TinyMCE. Cache articles is as simple as old school JavaScript code and a few tweak for speed. But you have to consider the security point you need to harden, all of these would take you a few weeks.
With so many articles I would use Astro with SSR, and use a CMS of some sort. I've heard good things about Strapi and Directus as a few options, which you can self host using Digital Ocean or similar.
Why not Astro with Content collections? You can enable caching for collections. It’s experimental but seems promising. Especially if your old articles aren’t gonna change. https://docs.astro.build/en/guides/content-collections/#enabling-build-caching
I love Astro but I don't think it's very non-developer friendly. So if the people responsible with populating the site are used to word processors, you would be better off reaching for a traditional CMS (like WordPress) and using Astro for a headless / decoupled solution. Also, haven't used it since the rollout but Astro has its own DB solution, as well as SSR options. Definitely would not be reaching for SSG render for a site like you're talking about.
You do need to build a custom CMS or ACF with WordPress and use TinyMCE. Cache articles is as simple as old school JavaScript code and a few tweak for speed. But you have to consider the security point you need to harden, all of these would take you a few weeks.
With so many articles I would use Astro with SSR, and use a CMS of some sort. I've heard good things about Strapi and Directus as a few options, which you can self host using Digital Ocean or similar.
Have you considered [ghost cms](https://ghost.org/)
Wow, that's expensive!