TOSL
TOSL
Explore posts from servers
TTCTheo's Typesafe CultDTDrizzle Team
PostsComments
DTDrizzle Team
Created by SpamixTheProducer on 12/31/2024 in #help
drizzle-kit push tries to re-define all primary keys when updating schema (mysql/mariadb)
I could be wrong but suspect the bug is some type of conflict from having both. If you'd like to use push, I suggest you delete your migration files and stick to just push.
10 replies
DTDrizzle Team
Created by SpamixTheProducer on 12/31/2024 in #help
drizzle-kit push tries to re-define all primary keys when updating schema (mysql/mariadb)
Did you run drizzle generate at any point?
10 replies
DTDrizzle Team
Created by David Gomes on 12/31/2024 in #help
schemaFilter not working as expected
Only works for push and pull commands
4 replies
DTDrizzle Team
Created by SpamixTheProducer on 12/31/2024 in #help
drizzle-kit push tries to re-define all primary keys when updating schema (mysql/mariadb)
You had an already existing db with populated tables then started using Drizzle?
10 replies
DTDrizzle Team
Created by desert.elf on 10/31/2024 in #help
drizzle-kit push keeps trying to drop and recreate the same constraints
Would be good to see schema as well.
7 replies
DTDrizzle Team
Created by desert.elf on 10/31/2024 in #help
drizzle-kit push keeps trying to drop and recreate the same constraints
Did you migrate to Drizzle from something else? Did you pull (introspect) to generate your scheme?
7 replies
DTDrizzle Team
Created by GermanJablo on 12/31/2024 in #help
`findMany` returns an empty array if the number of rows is +500 approx.
Pretty sure this is not a Drizzle limitation. Got to be some limitation imposed by db/db provider. I'd look into that.
3 replies
DTDrizzle Team
Created by Jonathan on 12/31/2024 in #help
Error: Role "root" does not exist
If you want to change your user, you'll need run some SQL to create it. But I'll let you search for that.
3 replies
DTDrizzle Team
Created by Jonathan on 12/31/2024 in #help
Error: Role "root" does not exist
So root is your user. In, MySQL that would the default but for postgres it should just be postgres. postgres://<user>:<password>@<host>:<port>/<database>
3 replies
DTDrizzle Team
Created by Kyrre Gjerstad on 12/31/2024 in #help
Which db provider for Edge connection with transactions
On Supabase, are you using the right type of connection string?
2 replies
DTDrizzle Team
Created by Bryce on 12/31/2024 in #help
Help with relations - Error: Unknown column in 'where clause'
And just to be sure you have pushed/migrated these changes to you db
10 replies
DTDrizzle Team
Created by Bryce on 12/31/2024 in #help
Help with relations - Error: Unknown column in 'where clause'
repost please
10 replies
DTDrizzle Team
Created by Bryce on 12/31/2024 in #help
Help with relations - Error: Unknown column in 'where clause'
So what is schema now?
10 replies
DTDrizzle Team
Created by Bryce on 12/31/2024 in #help
Help with relations - Error: Unknown column in 'where clause'
id column on userTable is char createdBy is varchar
10 replies
DTDrizzle Team
Created by Bryce on 12/31/2024 in #help
Help with relations - Error: Unknown column in 'where clause'
You defined userRelations twice
10 replies
DTDrizzle Team
Created by Sameer on 12/29/2024 in #help
[Solved] Issues with Middleware and Authentication in NextAuth.js with Drizzle and SQLite
perfect no problem
17 replies
DTDrizzle Team
Created by Sameer on 12/29/2024 in #help
[Solved] Issues with Middleware and Authentication in NextAuth.js with Drizzle and SQLite
What service are you using for db url and auth token? I need to get my own env vars
17 replies
DTDrizzle Team
Created by Rahul aithal on 12/30/2024 in #help
Having Issue with Enum in Neon Postgres
Manually altering this column should the issue. I think you can do this in drizzle studio or probably neon if they have a sql runner you can use. 
  ALTER TABLE users
  ALTER COLUMN role TYPE user_role USING role::user_role;
  ALTER TABLE users
  ALTER COLUMN role TYPE user_role USING role::user_role;
should fix it
4 replies
DTDrizzle Team
Created by Rahul aithal on 12/30/2024 in #help
Having Issue with Enum in Neon Postgres
Did you change from a different column type to enum?
4 replies
DTDrizzle Team
Created by Sameer on 12/29/2024 in #help
[Solved] Issues with Middleware and Authentication in NextAuth.js with Drizzle and SQLite
Cool. If not, I think I'd need a simple codesandbox recreation to help anymore.
17 replies