sik
sik
PostsComments
DTDrizzle Team
Created by sik on 8/26/2023 in #help
import { PostgresError } from "postgres" - build error?
No description
3 replies
DTDrizzle Team
Created by sik on 8/13/2023 in #help
What's the best way to deploy migrations on production database?
I'm confused as to what is the best way to deploy migration on the production database. Locally when I test on my local database instance, I use the commands manually to generate and push the migrations But I want to automate this. Say, I'm using Vercel and I want to push the migration on every commit. In prisma to deploy the generated migrations I use the command prisma migrate deploy, I add this command to the build command like this: prisma generate && prisma migrate deploy && next build There are my scripts in package.json 
"dev": "vite dev",
"build": "vite build",
.....
"db:start": "supabase start",
"db:stop": "supabase stop --backup",
"db:status": "supabase status",
"db:generate": "drizzle-kit generate:pg",
"db:push": "tsx ./src/lib/server/db/migrate.ts",
"db:migrate": "pnpm db:generate && pnpm db:push",
"db:studio": "drizzle-kit studio --port 3000 --verbose"
"dev": "vite dev",
"build": "vite build",
.....
"db:start": "supabase start",
"db:stop": "supabase stop --backup",
"db:status": "supabase status",
"db:generate": "drizzle-kit generate:pg",
"db:push": "tsx ./src/lib/server/db/migrate.ts",
"db:migrate": "pnpm db:generate && pnpm db:push",
"db:studio": "drizzle-kit studio --port 3000 --verbose"
16 replies
DTDrizzle Team
Created by sik on 8/10/2023 in #help
how to convert serial to uuid type
8 replies