Validating zod schemas generated from drizzle ORM schemas
I'm trying to create schemas that serve as contracts between my DB, Backend and Frontend systems. I use drizzle as an ORM and zod as a validator. I'm having the hardest time. Sorry, this will be a bit long.
The library I'm using to convert from drizzle to zod schemas is "drizzle-zod". This is the documentation.
The problem I'm facing is typescript errors when setting
It's hard to explain so I made a very minimal reproduction here: https://codesandbox.io/p/sandbox/3yvs9v
I'm not sure what that "SyntaxError" on the preview is, but ignore that. You can see the error if you hover over the
1. My drizzle schema lists a lot of columns as optional. This is because I want to create a user with minimal data. HOWEVER, on my form some of these values are REQUIRED. This should be enforced in both BE and FE, and thus when I call
2. I want as little refinements as possible. Most of the database schema is just as I want my request data. There are SOME changes (like Dates that for the request payload should be strings, but once in the DB they should be
Something being generated by
The library I'm using to convert from drizzle to zod schemas is "drizzle-zod". This is the documentation.
The problem I'm facing is typescript errors when setting
validators: { onChange: myGeneratedSchema }It's hard to explain so I made a very minimal reproduction here: https://codesandbox.io/p/sandbox/3yvs9v
I'm not sure what that "SyntaxError" on the preview is, but ignore that. You can see the error if you hover over the
onSubmit1. My drizzle schema lists a lot of columns as optional. This is because I want to create a user with minimal data. HOWEVER, on my form some of these values are REQUIRED. This should be enforced in both BE and FE, and thus when I call
createSelectSchema(usersTable)email2. I want as little refinements as possible. Most of the database schema is just as I want my request data. There are SOME changes (like Dates that for the request payload should be strings, but once in the DB they should be
DateSomething being generated by
createSelectSchemaDrizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.
