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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-EOVa68Uviks.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.
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 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?
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
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
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??