Learn Drizzle ORM in 13 mins (crash course)

[@neondatabase]

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: kzbin.info/www/bejne/e4C5kmluitucodU Drizzle ORM Docs: orm.drizzle.team/docs/overview Neon Serverless Driver: github.com/neondatabase/serverless

[@bengribbin6440]

Excellent and timely tutorial! Would love to see an example of using custom types (adding vector embeddings) through drizzle to Neon too

[@neondatabase]

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

[@PlayerRPG85]

This is the best intro to Drizzle I've ever seen

[@JosefuDorayvu]

Holy cows! You are a legend for this banger of a crash course, cheers!

[@DanielDrejerDK]

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. :)

[@neondatabase]

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

[@8bitWatermelon]

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.

[@ThunderboltPath]

Very helpful for understanding Drizzle, thanks!

[@neondatabase]

We're glad you found it helpful!

[@srijonp4]

Nice, I am going to try drizzle now.

[@siyedyoussef3202]

very informative video and on the target 🎯 love too see more of this types of videos

[@neondatabase]

We're glad you found it helpful!

[@VincentFulco]

very cool and practical. Thanks!

[@marta84-k5i]

thank you, this was a nice one, hope there is another how relationships works in drizzle, tyy

[@eliastouil7686]

This is a great intro thank you! Came here from Fireship's vid.

[@haydonge5328]

lots content for drizzle have been changed. Hope to update it with learning course.

[@JissJoy-zt1is]

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.

[@anirudhsinghbhadauria4034]

Nice file management!

[@javierfuentesmora1814]

do you need to close the db connection ?

[@eliuddyn]

Amazing 🔥🔥

[@abhinasregmi9742]

You look so happy 😊 😊

[@TristanRemy]

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 ?

[@neondatabase]

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

[@LarsRyeJeppesen]

Great stiff. How to deal with mysql pools for i stance? Does drizzle open amd close a connection fir each request?

[@neondatabase]

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

[@LarsRyeJeppesen]

@@neondatabase yes thanks I saw now, using mysql2 pool connection. Loving this ORM

[@mdsalahuddin2841]

how can we retrieve large scale json file generated from application like excalidraw ?

[@carlotadias9335]

great video thank you 😊😊😊😊😊😊😊😂😂

[@faizanhaider]

Coming from #fireship 😉

[@omkar._.k]

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!!

[@neondatabase]

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?

[@raine-works]

What theme and icons are you using for VSCode?

[@mouradbougarne1162]

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.

[@abhisekdas9976]

What vscode icon pack are you using?

[@asadmehboob1300]

please help me to generate generic repository pattern using drizzle or dynamic query

[@etj1237]

Please Please Please tell us what theme and icon pack you're using !!!! 🙏🙏🙏🙏🙏

[@neondatabase]

GitHub Dark default (theme) + Symbols (icons) - Mahmoud

[@tradecate]

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)

[@neondatabase]

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

[@sudiptapaul278]

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.

[@hamzasaleem2]

const sql: NeonQueryFunction = neon(process.env.DATABASE_URL); this will fix it!

[@WorkerThreads]

What is ide ?

[@neondatabase]

GitHub Dark theme + the "Symbols" icons extension - Mahmoud

[@linodil]

Why did you choose Hono over Elysiajs. Elysia has been longer in the game and is faster than Hono.

[@neondatabase]

No reason is in particular. Both are awesome! - Mahmoud

[@jitxhere]

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??

[@hakuna_matata_hakuna]

no local dev?

[@carlotadias9335]

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,