Mistake: a static sitemap that nobody regenerates

Mistake: a static sitemap that nobody regenerates

A hand-built sitemap.xml committed once drifts from reality the day after. New URLs are missing, deleted URLs 404, lastmod is frozen. Crawlers learn the file is unreliable.

Fix checklist:
— ✅ Sitemap is generated from the live database/route table, not a static file in the repo
— ✅ Regeneration runs on a schedule (hourly or on publish) — pick a cadence and enforce it
— New content appears in the sitemap within one regeneration cycle
— Removed content drops out the same cycle and returns 404/410 at the URL

Definition of done: publish a test page, wait one cycle, confirm its URL is in the sitemap and the lastmod matches publish time. Delete it, wait one cycle, confirm it is gone. Both halves must pass.