Astro turns content-focused routes into plain HTML at build time. That gives the public site a small runtime surface and makes Cloudflare Pages a natural deployment target.
The site can still use dynamic systems deliberately. Here, representative Turso rows are fetched during the build and rendered into the page. A new deployment becomes the synchronization point.
When a future feature genuinely needs request-time behavior, it can move behind an API or an SSR host with that trade-off made explicitly.