If you enjoyed watching this video, make sure to like and subscribe so you don't miss out on any future videos. If you'd like to learn more about using Drizzle with Preview Environments, check out our previous video: ua-cam.com/video/EOVa68Uviks/v-deo.html Drizzle ORM Docs: orm.drizzle.team/docs/overview Neon Serverless Driver: github.com/neondatabase/serverless
Glad you found it helpful! > Would love to see an example of using custom types (adding vector embeddings) through drizzle to Neon too This is a great idea! Thank you for sharing your feedback - Mahmoud
If you'd like to do a partial select, you can do it this way const result = await db.select({ field1: users.id, field2: users.name, }).from(users); orm.drizzle.team/docs/select#partial-select
Really enjoyed the video, currently learning to use drizzle for projects. For anyone who is trying to use drizzle-kit generate with cli params. The code in the video will not work. This is my solution after many trials and errors. "db:generate": "drizzle-kit generate --dialect postgresql --schema ./src/db/schema.ts --out=./src/db/migrations" Thank you.
Great stuff! It was really informative. I had a slightly different question. 😅 The editor folder icons and theme, which extension are you using? I really liked em! Would be glad if you could share it.
Hello Neon I just wanted to know something. When I generat a new db migrations like you showed it at 4:37 , it is not accepting the syyntax of sql file . I have installed postgres correctly and also not missing any steps in dependencies. Using VS Code . I hope you can help with a reply!!
Hey! > it is not accepting the syyntax of sql file Do you mind sharing more details? What kind of issues are you running into? What's the error message?
Drizzle doesn't automatically handle the opening and closing of connections for each request. This needs to be handled by the developer, which depends on which database driver they're using
Awesome content! Just one question which might look stupid : in your package.json, why use bun for migrate/seed and bunx for format/lint with biome being a devDependency ?
Not stupid at all! This is how it's recommended to use in the Biome docs biomejs.dev/guides/getting-started/#usage The package is installed in the project so that the editor can format on save. I like including it in the project so that if someone clones the repo they can easily get up and running - Mahmoud
I tried to ask on their Discord server but no answer. Does drizzle support add unique constraint based on two columns? `To make a column unique only based on another column, a playlist title is unique per user ID.
Hello sir, please help tell me how to run generate and migrate commands for a schema other than the default public schema, without using pgSchema (as it is fixed)? Also, could you tell me how to establish a connection with Drizzle ORM using dynamic schemas? Thanks
If I use neon branches, do I still have to create migrations? Planetscale explains that branches negate migrations so use db push instead of db migrate (for prisma)
Neon doesn't manage migrations for you as of today. So you will need to write them (or generate them depending on your framework of choice) and apply them in a Ci/CD pipeline or before your project's build step. Merging branches is something we're thinking about. But we don't have an exact ETA - Mahmoud
export const db = drizzle(sql) This line is showing me the error: "Argument of type 'NeonQueryFunction' is not assignable to parameter of type 'NeonQueryFunction'. Types of property 'transaction' are incompatible.
Hono can be deployed to like Workers, Vercel, Node.js etc.... Elysia main focus is bun right and also it is new right?? Also does any hosting support it??
hello, I have this config import { defineConfig } from "drizzle-kit"; export default defineConfig({ schema:"./src/db/schema.ts", out: "./src/db/migrations", dialect: "sqlite", driver: "d1-http", strictNullChecks : true, strict: true, dbCredentials: { url: "file:./src/db/sqlite.db", }, }); And I'm having the error in the url inside of the dbCredentials : Object literal may only specify known properties, and 'url' does not exist in type '{ accountId: string; databaseId: string; token: string; }'.ts(2353) (property) url: string Any idea on what can be wrong ?? Thank you in advance,
If you enjoyed watching this video, make sure to like and subscribe so you don't miss out on any future videos.
If you'd like to learn more about using Drizzle with Preview Environments, check out our previous video: ua-cam.com/video/EOVa68Uviks/v-deo.html
Drizzle ORM Docs: orm.drizzle.team/docs/overview
Neon Serverless Driver: github.com/neondatabase/serverless
Excellent and timely tutorial! Would love to see an example of using custom types (adding vector embeddings) through drizzle to Neon too
Glad you found it helpful!
> Would love to see an example of using custom types (adding vector embeddings) through drizzle to Neon too
This is a great idea! Thank you for sharing your feedback
- Mahmoud
This is the best intro to Drizzle I've ever seen
Very helpful for understanding Drizzle, thanks!
We're glad you found it helpful!
very informative video and on the target 🎯 love too see more of this types of videos
We're glad you found it helpful!
Well done!
Only thing I would have loved to see along with this, would be how to retrieve only a few specific columns, rather than everything. :)
If you'd like to do a partial select, you can do it this way
const result = await db.select({
field1: users.id,
field2: users.name,
}).from(users);
orm.drizzle.team/docs/select#partial-select
Nice, I am going to try drizzle now.
Holy cows! You are a legend for this banger of a crash course, cheers!
very cool and practical. Thanks!
This is a great intro thank you! Came here from Fireship's vid.
Really enjoyed the video, currently learning to use drizzle for projects. For anyone who is trying to use drizzle-kit generate with cli params. The code in the video will not work. This is my solution after many trials and errors.
"db:generate": "drizzle-kit generate --dialect postgresql --schema ./src/db/schema.ts --out=./src/db/migrations"
Thank you.
thank you, this was a nice one, hope there is another how relationships works in drizzle, tyy
do you need to close the db connection ?
Great stuff! It was really informative. I had a slightly different question. 😅
The editor folder icons and theme, which extension are you using? I really liked em!
Would be glad if you could share it.
Nice file management!
Hello Neon
I just wanted to know something. When I generat a new db migrations like you showed it at 4:37 , it is not accepting the syyntax of sql file . I have installed postgres correctly and also not missing any steps in dependencies. Using VS Code . I hope you can help with a reply!!
Hey!
> it is not accepting the syyntax of sql file
Do you mind sharing more details? What kind of issues are you running into? What's the error message?
Amazing 🔥🔥
lots content for drizzle have been changed. Hope to update it with learning course.
Great stiff. How to deal with mysql pools for i stance? Does drizzle open amd close a connection fir each request?
Drizzle doesn't automatically handle the opening and closing of connections for each request. This needs to be handled by the developer, which depends on which database driver they're using
@@neondatabase yes thanks I saw now, using mysql2 pool connection. Loving this ORM
how can we retrieve large scale json file generated from application like excalidraw ?
great video
thank you 😊😊😊😊😊😊😊😂😂
You look so happy 😊 😊
Awesome content! Just one question which might look stupid : in your package.json, why use bun for migrate/seed and bunx for format/lint with biome being a devDependency ?
Not stupid at all! This is how it's recommended to use in the Biome docs
biomejs.dev/guides/getting-started/#usage
The package is installed in the project so that the editor can format on save. I like including it in the project so that if someone clones the repo they can easily get up and running
- Mahmoud
What theme and icons are you using for VSCode?
I tried to ask on their Discord server but no answer.
Does drizzle support add unique constraint based on two columns? `To make a column unique only based on another column, a playlist title is unique per user ID.
Hello sir,
please help tell me how to run generate and migrate commands for a schema other than the default public schema, without using pgSchema (as it is fixed)?
Also, could you tell me how to establish a connection with Drizzle ORM using dynamic schemas?
Thanks
What vscode icon pack are you using?
Please Please Please tell us what theme and icon pack you're using !!!! 🙏🙏🙏🙏🙏
GitHub Dark default (theme) + Symbols (icons)
- Mahmoud
please help me to generate generic repository pattern using drizzle or dynamic query
If I use neon branches, do I still have to create migrations? Planetscale explains that branches negate migrations so use db push instead of db migrate (for prisma)
Neon doesn't manage migrations for you as of today. So you will need to write them (or generate them depending on your framework of choice) and apply them in a Ci/CD pipeline or before your project's build step.
Merging branches is something we're thinking about. But we don't have an exact ETA
- Mahmoud
export const db = drizzle(sql)
This line is showing me the error: "Argument of type 'NeonQueryFunction' is not assignable to parameter of type 'NeonQueryFunction'.
Types of property 'transaction' are incompatible.
const sql: NeonQueryFunction = neon(process.env.DATABASE_URL);
this will fix it!
Coming from #fireship 😉
Why did you choose Hono over Elysiajs. Elysia has been longer in the game and is faster than Hono.
No reason is in particular. Both are awesome!
- Mahmoud
Hono can be deployed to like Workers, Vercel, Node.js etc.... Elysia main focus is bun right and also it is new right?? Also does any hosting support it??
What is ide ?
GitHub Dark theme + the "Symbols" icons extension
- Mahmoud
no local dev?
Wtf you are already been write the code qnd explaining them , why don't you write the code and explain that during video
hello, I have this config
import { defineConfig } from "drizzle-kit";
export default defineConfig({
schema:"./src/db/schema.ts",
out: "./src/db/migrations",
dialect: "sqlite",
driver: "d1-http",
strictNullChecks : true,
strict: true,
dbCredentials: {
url: "file:./src/db/sqlite.db",
},
});
And I'm having the error in the url inside of the dbCredentials :
Object literal may only specify known properties, and 'url' does not exist in type '{ accountId: string; databaseId: string; token: string; }'.ts(2353)
(property) url: string
Any idea on what can be wrong ??
Thank you in advance,