Next Quote - Which quote is funnier?

An application for voting on your favourite technology/development quotes. It's like ranking the stars but for geeks ✨.

Features

• Vote between two quotes
• See the overall results (cached and revalidated after 10 minutes once a user visits the /results page)

Tech-stack

• Next.js SSR React framework
• Tailwind.css for utility-first CSS styling
• Prisma as Database ORM
• Planetscale as MySQL database host

Installation and Setup Instructions

Prerequisite:

• Local MySQL database / Planetscale database with local connection

Clone down this repository. You will need node and npm installed globally on your machine.

Setup

1. npm install
2. Create .env file
3. Add a DATABASE_URL= variable with the connection string to your MySQL instance
4. Generate artifacts (e.g. Prisma Client) - npx prisma generate
5. Generate db schema - npx prisma db push
6. Seed the database with quotes - npm run ts-node ./scripts/db-backfill.ts
7. Run the dev server - npm run dev