DT
Drizzle Teaminterdrifter

How to properly do foreign keys in schema with PlanetScale?

I'm aware that foreign key constrains aren't supported, but foreign keys themselves are. push: 
sqlMessage: 'VT10001: foreign key constraints are not allowed'
sqlMessage: 'VT10001: foreign key constraints are not allowed'
export const session = mysqlTable("auth_session", {
    id: varchar("id", { length: 128 }).primaryKey(),
    userId: varchar("user_id", { length: 15 }).notNull().references(() => user.id),
    // ...
});
export const session = mysqlTable("auth_session", {
    id: varchar("id", { length: 128 }).primaryKey(),
    userId: varchar("user_id", { length: 15 }).notNull().references(() => user.id),
    // ...
});
shaw93
shaw93ā€¢303d ago
Hey Murad around 4mins50sec this subject is discussed: https://www.youtube.com/watch?v=d7XJjQesDtE&ab_channel=DaveGray
Dave Gray
YouTube
Build a Random Quote Machine with Nextjs, PlanetScale MySQL, & Driz...
Web Dev Roadmap for Beginners (Free!): https://bit.ly/DaveGrayWebDevRoadmap Build a random quote machine with Nextjs, PlanetScale MySQL, & Drizzle ORM. In this tutorial, we'll set up a MySQL database on PlanetScale, connect to and query the database with Drizzle ORM, and build a Next.js frontend and API routes. šŸš© Subscribe āžœ https://bit.ly/3n...
ejoo
ejooā€¢289d ago
https://planetscale.com/docs/learn/operating-without-foreign-key-constraints 
import { pgTable, serial, text, integer } from 'drizzle-orm/pg-core';
import { relations } from 'drizzle-orm';
 
export const users = pgTable('users', {
    id: serial('id').primaryKey(),
    name: text('name'),
});
 
export const usersRelations = relations(users, ({ many }) => ({
    posts: many(posts),
}));
 
export const posts = pgTable('posts', {
    id: serial('id').primaryKey(),
    content: text('content'),
    authorId: integer('author_id'),
});
 
export const postsRelations = relations(posts, ({ one }) => ({
    author: one(users, {
        fields: [posts.authorId],
        references: [users.id],
    }),
}));
import { pgTable, serial, text, integer } from 'drizzle-orm/pg-core';
import { relations } from 'drizzle-orm';
 
export const users = pgTable('users', {
    id: serial('id').primaryKey(),
    name: text('name'),
});
 
export const usersRelations = relations(users, ({ many }) => ({
    posts: many(posts),
}));
 
export const posts = pgTable('posts', {
    id: serial('id').primaryKey(),
    content: text('content'),
    authorId: integer('author_id'),
});
 
export const postsRelations = relations(posts, ({ one }) => ({
    author: one(users, {
        fields: [posts.authorId],
        references: [users.id],
    }),
}));
Operating without foreign key constraints ā€” PlanetScale Documentati...
How to manage your relational data without formal foreign key constraints in your schema
Want results from more Discord servers?
Add your server
More Posts
Typescript path alias not working properlyI'm new to Drizzle, but I'm not able to use the path alias on schema files. Using absolute paths onExpand query from ID using .select()Hi! I am trying to get the first name of a comment author, but only store the ID so the user can chaPGEnum -> Typescript EnumHey there. Is there any convenient way people have found to conveniently turn a pgEnum into a typescIs Drizzle Kit/Drizzle Studio possible with RDS Data API?I'm able to create the RDSDataClient for querying my DB using Drizzle ORM, but I don't see a way to How to apply migrations on postgres in a serverless enviroment?Hello, I want to apply postgres migrations to my vercel DB. I see that the push command does not woError when trying to generate a migration schemaanyone any ideas to what the problem is? It was working fine yesterday and now it throws an error wh