DT
Drizzle Team•10mo ago
Bozic0909

drizzle studio tables are empty

Hi, I created app using Next.js, TRPC and next-auth and I setup auth logic with Discord Provider, everything works fine except when I run drizzle studio all tables are empty even tho I can login without problems, anyone had something similar? btw I'm using sqlite
No description
No description
2 Replies
Angelelz
Angelelz•10mo ago
I believe next-Auth's default is to use JWT and not the Database. Might need to look in to it. You might also want to seed something in the database just to make sure the studio is working properly
Bozic0909
Bozic0909•10mo ago
I manage to solve this by adding fileMustExist: true, in the 
const sqlite = new Database("sqlite.db", {
  fileMustExist: true,
});
const sqlite = new Database("sqlite.db", {
  fileMustExist: true,
});
Want results from more Discord servers?
Add your server
More Posts
Bug on custom type inference? Maybe I'm doing something wrong.```ts export const timez = customType< { data: Date; driverData: string; config: { preJSON with PostgreSQL not serializing correctlyI have define my field like this: ``` hostnames: jsonb("hostnames").$type<string[]>().default([]),hashing password in Cloudflare WorkersCan someone help me find function to hash password and verify it that works in Cloudflare WorkersHow to get the count of records? Here is my normal sql, trying to translate into drizzle```.select({ id: comments.id, parentId: comments.parentId, // TODO countReplies: gIs there a way to create check constraint?I need to have a check constraint in my schema. I know check function is currently not supported, buis there any way to create related records with the main record together like this in prismaHow to add to the database where the table has a many relationship to another tableI have a users table, which has a many relationship to to a posts table. I want to add a new user tWhere clauses across multiple tables in relational queriesIs is possible to specify a where condition in a relational query that includes conditions from the