CJ, the work you're putting into these videos cannot be overstated. We really appreciate all the effort that is being directed into sharing all this knowledge and news, please keep this up
I love creators dedicating time to explain details like these. I was confused because while I was setting up drizzle I saw the docs for `drizzle/connect` then it vanished some hours later and I thought I was getting crazy lol Having you cover this is really heartwarming and makes my trust in the community even stronger :)
Awesome! I didn't know about drizzle's updates, certainly solves many of my gripes especially the docs and how I had to do initial setup for the connection.
Drizzle is great. Currently Drizzle has 2 things to improve: - Git conflicts - If you have two branches, each of them generated a new migration, and when they get merged there will be a merge conflict in the jurnal file. I don't have trust in me to touch the _jurnal file. It would be best if people don't need to bother with fixing git conflict inside the drizzle folder. - Reverting migrations - Lets say that you are on a branch A, you created 3 migrations files, but you realize that you actually want to remove those 3 migrations files, and have one single file. How do you do that? I would appreciate a drizzle down command to revert the last applied migration. Ideally, I would revert the last 3 migrations, and than generate a new migration. Lucky It seems like Drizzle is going to address these issues soon.
Thank you so much for the cool content! Would like to see more drizzle videos. If possible, could you make another video and explain migrations with drizzle? (Simple and complex ones)
With Drizzle 0.36.0 and above, there's a change in third param of schema to use array instead of object and the docs are not updated quite yet. I'm trying to setup Auth.js with Drizzle Adapter if someone can guide how to change the following Auth.js verificationToken table schema to work with latest Drizzle version i.e. defining compound or composite indexes. export const verificationTokens = pgTable( "verificationToken", { identifier: text("identifier").notNull(), token: text("token").notNull(), expires: timestamp("expires", { mode: "date" }).notNull(), }, (verificationToken) => ({ compositePk: primaryKey({ columns: [verificationToken.identifier, verificationToken.token], }), }) )
I think Drizzle is still absolutely unready. I decided to use it for a new project using SQLite as development database, and I constantly ran into brick walls using Next.js 15. The documentation is horrible. Hopefully v1 will be better. Until that I'm writing raw SQL.
CJ, the work you're putting into these videos cannot be overstated. We really appreciate all the effort that is being directed into sharing all this knowledge and news, please keep this up
I love creators dedicating time to explain details like these.
I was confused because while I was setting up drizzle I saw the docs for `drizzle/connect` then it vanished some hours later and I thought I was getting crazy lol
Having you cover this is really heartwarming and makes my trust in the community even stronger :)
sorry, we've fixed the mistake
Awesome! I didn't know about drizzle's updates, certainly solves many of my gripes especially the docs and how I had to do initial setup for the connection.
Drizzle is great. Currently Drizzle has 2 things to improve:
- Git conflicts - If you have two branches, each of them generated a new migration, and when they get merged there will be a merge conflict in the jurnal file. I don't have trust in me to touch the _jurnal file. It would be best if people don't need to bother with fixing git conflict inside the drizzle folder.
- Reverting migrations - Lets say that you are on a branch A, you created 3 migrations files, but you realize that you actually want to remove those 3 migrations files, and have one single file. How do you do that? I would appreciate a drizzle down command to revert the last applied migration. Ideally, I would revert the last 3 migrations, and than generate a new migration.
Lucky It seems like Drizzle is going to address these issues soon.
that's on me, yes
yeah, those docs are way way better. was going through them a few weeks ago and it was pretty lousy. very happy with the new ones, good job drizzle!
I swear to god, CJ videos are the best thing since sliced bread
Thanks for the material, I will keep an eye out for new videos and hopefully see more material from Hono and cloudflare.
Thank you so much for the cool content! Would like to see more drizzle videos. If possible, could you make another video and explain migrations with drizzle? (Simple and complex ones)
Bro you are really awesome, thanks a lot
very informative video, thanks.
Very good. Thanks.
Bro when will they add seeders? I need them for my project with faker.
Any issues using drizzle with nextjs 15, react 19 RC and authJS (v5)?
is drizzle support auto release connection to pool for postgresql ?
hopefully on 1.0 drizzle is compatible with instrumentation tools 🤞
Cj, please do a drizzle supabase vid with the new rls (claims etc)
Pleaaaaase ❤
With Drizzle 0.36.0 and above, there's a change in third param of schema to use array instead of object and the docs are not updated quite yet. I'm trying to setup Auth.js with Drizzle Adapter if someone can guide how to change the following Auth.js verificationToken table schema to work with latest Drizzle version i.e. defining compound or composite indexes.
export const verificationTokens = pgTable(
"verificationToken",
{
identifier: text("identifier").notNull(),
token: text("token").notNull(),
expires: timestamp("expires", { mode: "date" }).notNull(),
},
(verificationToken) => ({
compositePk: primaryKey({
columns: [verificationToken.identifier, verificationToken.token],
}),
})
)
Syntax releasing content about Prisma and Drizzle on the same week: "I'm playing both sides so that I always come out on top"
Please restock the blazing fast tee in medium!
Restock coming soon!
nice ❤
Can't wait till they have SQL Server for us corporate code slingers.
personally i want prisma like schema
example nestjs+drizzle please . . .
I think Drizzle is still absolutely unready. I decided to use it for a new project using SQLite as development database, and I constantly ran into brick walls using Next.js 15. The documentation is horrible. Hopefully v1 will be better. Until that I'm writing raw SQL.
👍