Skip to content
This repository has been archived by the owner on May 30, 2024. It is now read-only.
/ Pestoverse Public archive

The official website for running, upcoming and archived events created by Yuniiho's community!

License

Notifications You must be signed in to change notification settings

Tougrel/Pestoverse

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Pestoverse

License GitHub Contributors GitHub Issues GitHub pull requests Static Badge Static Badge

Welcome to the Pestoverse github repo! The official community website built for Yuniiho's community to celebrate milestones and archive them so we can go back and watch/read them!

The website currently only has an interactive map with markers that show images of pesto plushies around the world! We are planning on adding more stuff in the future!

Credits will be given to all pesties that help (even with bug fixing and ideas)!

This is a community project! If you want to contribute feel free to fork the repo and open a pull request.


How to set up the database locally

The latest commit doesn't include a database. Please refer to commit 2898619 which was the last one that included a database/auth system

  1. Initialise the database: pnpm migrate:local This will create the database and run migrations.
  2. Seed the categories table: sqlite3 local.db < ./migrations/categories_seed.sql
  3. Seed some submissions into the database with pnpm seed:submissions
  4. Seed some votes into the database with pnpm seed:votes

N.B. Steps 3 and 4 can be run multiple times and they will add new submissions and votes to the database.

Performing D1 migrations (in beta/prod)

Migrations cannot be done via drizzle-kit directly, so we have to execute SQL scripts via wrangler

  1. npx wrangler d1 execute pestoverse --file ./migrations/[filename].sql

How to run the website

Keep in mind that we deploy the website in cloudflare pages so everything we add needs to be tested there. To be sure that everything works correctly you can run the NITRO_PRESET=cloudflare-pages pnpm build script and it will build it with the cloudflare preset.

If you want to expose the development version so others can see your progress without having to commit your changes so far, you can do it using cloudflared (you can find how to setup your first tunnel here)

# We are using pnpm as a package manager but you can use whatever you want
# Make sure to install the dependencies:
pnpm install

# Once you install the dependencies you can start a development server using
pnpm dev
# This will start a dev server on http://localhost:3000

# To test the application locally you can run
pnpm preview

Check out the deployment documentation for more information.

Image

About

The official website for running, upcoming and archived events created by Yuniiho's community!

Topics

Resources

License

Code of conduct

Stars

Watchers

Forks

Contributors 4

  •  
  •  
  •  
  •