Voice Ask me anything app. Built with Next.js, Prisma, TypeScript, Tailwind, React Query, MediaRecorder API, and Cloudinary.
MIT License
Ask Me Anything App!
Built with:
Based on Brian Lovin's AMA page rebuilt with Prisma.
Clone the repository:
git clone [email protected]:2color/prisma-ama.git
cd
into the directory:
cd prisma-ama
Install dependencies:
npm i
Start the client:
npm run dev
Open the site:
localhost:3000
Adjust the Prisma schema (with RDS MySQL) and set referential integrity to prisma
datasource db {
provider = "mysql"
url = env("DATABASE_URL")
referentialIntegrity = "prisma"
}
generator client {
provider = "prisma-client-js"
previewFeatures = ["dataProxy", "referentialIntegrity"]
}
Create a migration (removing the foreign keys) with local DB: npx prisma migrate dev
Run the migration against the RDS MySQL Production DB removing foreign keys in preparation for the migration
Setup the PlanetScale import
Add the imported PlanetScale DB to the Prisma Data Platform and verify using the Data Browser that the data has been successfully replicated.
Switch PlanetScale DB to primary
Update the production DATABASE_URL
env var on Vercel to use the PlanetScale DB
(optional) Add indices for foreign keys (See comment)
pscale branch create prisma-playground shadow
SHADOW_DATABASE_URL
in .env
and configure the Prisma schemanpx prisma migrate dev
pscale branch promote prisma-playground main
pscale branch create prisma-playground add-subtitle-to-posts
pscale connect prisma-playground add-subtitle-to-posts --port 3309
pscale connect prisma-playground shadow --port 3310
DATABASE_URL="mysql://[email protected]:3309/prisma-playground"
SHADOW_DATABASE_URL="mysql://[email protected]:3310/prisma-playground"
npx prisma migrate dev
pscale deploy-request create prisma-playground add-subtitle-to-posts
mysql --protocol TCP -h localhost -P 3306 -u root -p prisma-ama
mysqldump --host eu-central-1.rds.amazonaws.com --user admin -p DB_NAME --no-create-db --set-gtid-purged=OFF > dump-7-12-2021.sql
mysql --protocol TCP -h localhost -P 3306 -u root -p prisma-ama < dump-7-12-2021.sql