Astro portfolio site configured for Cloudflare Pages, Pages Functions, and a D1-backed reviews catalog.
Edit the Astro app under src/:
src/pages/index.astro- home pagesrc/pages/portfolio.astro- portfolio pagesrc/pages/vault.astro- services, Minecraft status, and published reviewssrc/layouts/Layout.astro- shared navigation, page shell, and footer
The old hand-written static site has been archived in legacy-static/ for reference. Cloudflare Pages builds from Astro into dist/, so root-level legacy HTML files should not be edited for the live site.
- Production: https://epppe.net
- Alternate host: https://www.epppe.net
- Pages fallback: https://epppe-portfolio.pages.dev
- D1 database:
epppe-reviews - Local copy of production review admin token:
.admin-token
npm install
cp .dev.vars.example .dev.vars
npm run db:migrate:local
npm run pages:devREVIEWS_ADMIN_TOKEN in .dev.vars is used by /admin/reviews for create, edit, and delete actions.
- Create the Pages project from this repository.
- Create the D1 database:
npx wrangler d1 create epppe-reviews- Copy the returned
database_idintowrangler.jsonc. - Set the production admin token:
npx wrangler pages secret put REVIEWS_ADMIN_TOKEN --project-name=epppe-portfolio- Apply the remote migration:
npm run db:migrate:remote- Deploy:
npm run pages:deployThis project deploys with Cloudflare Pages, not GitHub Pages. Keep GitHub Pages disabled in the repository settings to avoid the automatic pages-build-deployment workflow.
/- home page/portfolio- business portfolio and composition research portfolio/portfolio/composition- composition research portfolio materials/vault- services, Minecraft status, and published reviews/admin/reviews- spreadsheet-style review editor/api/reviews- publicGET, adminGETandPOST/api/reviews/:id- adminPUTandDELETE
The admin sheet supports inline row editing, selected-row deletion, save-all, CSV export, and CSV/TSV paste import. Use .admin-token as the admin token.
For trusted bulk SQL changes, use D1 directly:
npx wrangler d1 execute epppe-reviews --remote --command "SELECT * FROM reviews;"
npx wrangler d1 execute epppe-reviews --remote --file ./bulk-update.sql