How database migrations work when using Drizzle ORM

My Products
🏗️ WDC StarterKit: wdcstarterkit.com
📖 ProjectPlannerAI: projectplannerai.com
🤖 IconGeneratorAI: icongeneratorai.com
📝 ThumbnailCritique: thumbnailcritique.com
Useful Links
💬 Discord: / discord
🔔 Newsletter: newsletter.webdevcody.com/
📁 GitHub: github.com/webdevcody
📺 Twitch: / webdevcody
🤖 Website: webdevcody.com
🐦 Twitter: / webdevcody

[@hhhhhhhhhhhhhhhhhhhhhh]

The team behind Drizzle actually just added a "migrate" command to drizzle-kit's beta version on April 26th which will likely make this more straightforward if you're not in need of some custom behavior. This way definitely still works too but just figured I'd point it out

[@WebDevCody]

I’ll have to look more into it

[@ShaneCodes]

Do you have a link to this? Its not in their docs

[@gadgetboyplaysmc]

You've been uploading a ton dude. sick!

[@elmalleable]

my scripts always have db:generate:seed and db:generate:refresh (refresh to tear down and rebuild my local db)

[@bnssoftware3292]

I really like this series of following along with your SaaS template build out. I will definitely be a buyer of it.

[@iamsomraj]

Dude you really made a whole video… thanks man

[@mojo6689]

Great video. Clarified a lot of things that were confusing me

[@buddy.abc123]

Is something wrong with me? Once I understood Go earlier this year I'm not interested in server side js 😭 I've always done C# but for side projects I still used node. Now node is for frontend and Go is backend. What's wrong with me? The only thing keeping me in js land is the ui components like Shadcn and Aceternity

[@rahultech77]

Thanks for uploading this. I was running db:push manually as i wasn't able to figure out how to run this automatically on CI

[@euanmorgann]

Awesome video 🙏 One question though, Since this is a monorepo if you had multiple apps in there pointing at the same shared DB, would you still run migrations on start for all of them?

[@WebDevCody]

You’d probably only want one to control running the migrations,or a separate ci cd process maybe

[@peteregbujie]

Hi Cody, why did you use text and randomuuid as id in the schema instead of id: uuid("id").primaryKey().defaultRandom() ?

[@hyper-stack]

I have a question. What if, let's say my hello table, already had some data in it, and I added some more columns into the hello schema. How can I migrate the changes but still manage to keep all my existing data in the hello table.

[@rodjenihm]

If new columns are nullable, then there is no issue. If you want to make them not nullable you first have to make them nullable, then populate the data for existing records and then make them not nullable after that.

[@WebDevCody]

like @rodjenihm said, but also I think you can also just add a default value to the columns.

[@hyper-stack]

@@rodjenihm thank you so much!

[@hyper-stack]

@@WebDevCody thank you so much!

[@Flash136]

The only annoying thing about Drizzle is their push command when prototyping. With Prisma, the push command will let you keep pushing to the database as long as it isn't going to delete any data. With Drizzle, the push command will ask for your intervention even when a table has been renamed or has been removed from the schema. This is quite annoying when prototyping because any major change to the database structure requires you to manually clear unused tables. Also, Drizzle just doesn't seem to know when data deletion is possible. You have to keep telling it that yes this push operation is safe, go ahead. Prototyping with Prisma is a breeze. I just need to generate migrations IF and WHEN I actually already want/need to.

[@WebDevCody]

Prisma feels a bit better honestly. I think drizzle assumes you will do traditional migration scripts and they don’t recommend using push for production deploys

[@Its-InderjeetSinghGill]

Hi, I love your videos , I have one question about migrations. I followed the pattern showing in your video works great but just to make sure and test each edge case I delete migrations folder form my project after generating and migrating previously and then I re generated migrations and ran migrate script, but it throw an error like SQL_INPUT_ERROR: SQL input error: table `customers` already exists. It looks like it lost the track of changes I made earlier in the schema. A quick answer would be really appreciated.

[@WebDevCody]

I think you either need to do a drizzle kit pull so that your meta directory and journal file is correctly updated, or just keep your migration scripts around even after running them.

[@Its-InderjeetSinghGill]

@@WebDevCody Thanks man, I really appreciate the help, I have been pulling my hair over this for hours. I read the docs again and found out that I have to run introspect and then make sure my current schema matches with the introspection schema and then I can make changes again to my schema and do migrations with no problem.

[@DouglasSouza-te9bt]

How often do you get discouraged with scheduling? And what do you usually do to deal with it?

[@WebDevCody]

What do you mean?

[@Harish-rz4gv]

Did u use arc browser which Theo uses??

[@WebDevCody]

No I use chrome

[@SeibertSwirl]

First!!!! Also, love ya! You’re doing a great job❤

[@WebDevCody]

Love you babe, thanks for being first. I'm going to give you something special later tonight

[@SeibertSwirl]

@@WebDevCody sir…. Log off the internet for the day please lol

[@chiubaca]

Is WDC starter kit going to be open sourced ?

[@WebDevCody]

Nah it’s a paid starter kit

[@Stallion45]

Would be cool if you did a video on how and why you choose your database options for projects. Drizzle, Prisma, Convex…, mysql, psgr etc. I’ve used mysql for years, and been learning the others, but this is a major frustration point t as I keep second guessing myself and wondering if my choice is the right choice. From video to video on this channel and others it seems the choice is random. Just one of my obstacles that keeps me from finishing projects.

[@WebDevCody]

It depends on scale and data needs. In most cases postgres or mysql is the best bet. Convex if you want an all inclusive baas

[@Stallion45]

@@WebDevCody Thanks, as a PHP dev for almost 15 years mysql was my goto, so I've been having a good time just playing with other arms and db's but I am leaning toward Convex more often than not. It's fast, real-time, very slick dev env, and as you said it's kind of a complete package with file storage. Keep up the great videos and would love to see more with Convex.

[@-lumqua-827]

Great

[@lev1ato]

maybe a video about next auth pls 🥺🥺