Help me with my stack...
Hi folks,
I'm prototyping a website for scores for a niche sport I play. The current popular one is some 2005 era wordpress monstrosity. This one will be nice and simple - display events, teams, players, scores, blog, news, and standings.
Because of the nature of the site, there will be many pages (thousands eventually) that will change quite regularly, so I'll need to SSR. However most of the requests will be for stale data (think people refreshing the score page many times) so I'm thinking I need a solid way to cache results, either in a CDN or serverside db, in order to keep costs low (it's out of my own pocket) and also to keep the site fast.
I'll need localisation as well, curling is played all over Europe as well as in Canada. And I want to use deno for the backend.
I was thinking of a few options
1. Astro frontend with the deno adaptor, deno backend, some DB (ps, cockroach, supabase). Hosted on Deno deploy or netlify. Cloudflare CDN managing the cache through a worker.
2. Astro frontend hosted on netlify with a redis/sqlite cache.
3. Just suck it up and use Next.js on vercel with ISR, with a deno backend hosted anywhere.
Anyone have some recommendations or suggestions? Cheers
I'm prototyping a website for scores for a niche sport I play. The current popular one is some 2005 era wordpress monstrosity. This one will be nice and simple - display events, teams, players, scores, blog, news, and standings.
Because of the nature of the site, there will be many pages (thousands eventually) that will change quite regularly, so I'll need to SSR. However most of the requests will be for stale data (think people refreshing the score page many times) so I'm thinking I need a solid way to cache results, either in a CDN or serverside db, in order to keep costs low (it's out of my own pocket) and also to keep the site fast.
I'll need localisation as well, curling is played all over Europe as well as in Canada. And I want to use deno for the backend.
I was thinking of a few options
1. Astro frontend with the deno adaptor, deno backend, some DB (ps, cockroach, supabase). Hosted on Deno deploy or netlify. Cloudflare CDN managing the cache through a worker.
2. Astro frontend hosted on netlify with a redis/sqlite cache.
3. Just suck it up and use Next.js on vercel with ISR, with a deno backend hosted anywhere.
Anyone have some recommendations or suggestions? Cheers
