DT
Drizzle Team•5mo ago
jmandrosz

Relations in schema

Hi, I am a little bit confused about defining relations and foreign keys, why I need to define application level relation with "relations" keyword if I can just define foreign key by references and use it in my select query with join statement?
No description
3 Replies
jmandrosz
jmandrosz•5mo ago
Okay, I assume that this is only for "query api" and if I want to use only regular select statements I can ignore this, am I right?
AstroBear
AstroBear•5mo ago
Yes, I think relations are only used in "queries" (prisma-like selects). You don't need them when using selects
Mykhailo
Mykhailo•5mo ago
you are right, there is a bit more info https://orm.drizzle.team/docs/rqb#foreign-keys
Drizzle ORM - next gen TypeScript ORM
Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.
No description
Want results from more Discord servers?
Add your server
More Posts
Column _ cannot be cast automatically to type integerI have set a `postId` column in my `comments` table, in which I store the ID of the post the commenterror: type "serial" does not existI'm trying to push a generated migration: ALTER TABLE "account" ALTER COLUMN "id" SET DATA TYPE serHow to create tables at runtime?Hi, Is this possible, if not, then what's the best approach for this so I can leverage the orm as muCONNECT_TIMEOUTI run into a strange problem. I use postgres-js and drizzle in my server. My DB is hosted by scalewaadvanced relational query builderhey, i have a use case where i need to return rows from one table based on filters requiring on connIs this error in Docs for drizzle-kit Running Migrations SQLiteIn the following link: https://orm.drizzle.team/kit-docs/overview, it states at the end of the code getTableColumns for sub-queryI am very new to drizzle so I'm not sure the best way to do this. I want to create a query, and thenInsert on postgres autoincrement expects a valueAs the title says, I have an ID colum with an auto incrementing interger for an id. By default the i