SQLite self referencing table
Hi! I'm trying to achieve self referencing category structure in my application.
Found this article from wiki: https://orm.drizzle.team/docs/indexes-constraints#foreign-key
I'm getting error
There is not enough information to infer relation "categories.children"
If I name both relations to same, I'm able to get main categories, but not children with
Drizzle ORM - Indexes & Constraints
Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.
1 Reply
did you ever get an answer to this?