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: th-cam.com/video/EOVa68Uviks/w-d-xo.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
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.
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.
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
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
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?
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
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.
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.
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
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: th-cam.com/video/EOVa68Uviks/w-d-xo.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!
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
very informative video and on the target 🎯 love too see more of this types of videos
We're glad you found it helpful!
This is a great intro thank you! Came here from Fireship's vid.
Holy cows! You are a legend for this banger of a crash course, cheers!
Nice, I am going to try drizzle now.
very cool and practical. Thanks!
thank you, this was a nice one, hope there is another how relationships works in drizzle, tyy
Nice file management!
do you need to close the db connection ?
Amazing 🔥🔥
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.
lots content for drizzle have been changed. Hope to update it with learning course.
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.
You look so happy 😊 😊
great video
thank you 😊😊😊😊😊😊😊😂😂
how can we retrieve large scale json file generated from application like excalidraw ?
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
Please Please Please tell us what theme and icon pack you're using !!!! 🙏🙏🙏🙏🙏
GitHub Dark default (theme) + Symbols (icons)
- Mahmoud
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
What theme and icons are you using for VSCode?
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?
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
please help me to generate generic repository pattern using drizzle or dynamic query
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.
Coming from #fireship 😉
What vscode icon pack are you using?
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!
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
What is ide ?
GitHub Dark theme + the "Symbols" icons extension
- Mahmoud
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??
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,