Skip to content
cciaconaPublic

About

website

Resources

Stars

0 stars

Watchers

0 watching

Forks

Repository files navigation

EPPPE Portfolio

Astro portfolio site configured for Cloudflare Pages, Pages Functions, and a D1-backed reviews catalog.

Source Of Truth

Edit the Astro app under src/:

  • src/pages/index.astro - home page
  • src/pages/portfolio.astro - portfolio page
  • src/pages/vault.astro - services, Minecraft status, and published reviews
  • src/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.

Deployed Project

Local Development

npm install
cp .dev.vars.example .dev.vars
npm run db:migrate:local
npm run pages:dev

REVIEWS_ADMIN_TOKEN in .dev.vars is used by /admin/reviews for create, edit, and delete actions.

Cloudflare Setup

  1. Create the Pages project from this repository.
  2. Create the D1 database:
npx wrangler d1 create epppe-reviews
  1. Copy the returned database_id into wrangler.jsonc.
  2. Set the production admin token:
npx wrangler pages secret put REVIEWS_ADMIN_TOKEN --project-name=epppe-portfolio
  1. Apply the remote migration:
npm run db:migrate:remote
  1. Deploy:
npm run pages:deploy

GitHub Pages

This project deploys with Cloudflare Pages, not GitHub Pages. Keep GitHub Pages disabled in the repository settings to avoid the automatic pages-build-deployment workflow.

Routes

  • / - 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 - public GET, admin GET and POST
  • /api/reviews/:id - admin PUT and DELETE

Review Editing

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

About

website

Resources

Stars

0 stars

Watchers

0 watching

Forks

Contributors

Languages