Mykhailo
DTDrizzle Team
•Created by Acro on 3/21/2024 in #help
When to use what? drizzle-kit push:* Vs. having a file with drizzle migrate client?
drizzle-kit migrate
use migrate
function under the hood6 replies
DTDrizzle Team
•Created by Acro on 3/21/2024 in #help
When to use what? drizzle-kit push:* Vs. having a file with drizzle migrate client?
hey @adrtivv! no, there is no difference between them
6 replies
DTDrizzle Team
•Created by Angel on 6/5/2024 in #help
UUID Cast error with pg and aws-data-api in kit studio
Hey @g63sol. I will ask developer who worked on this and I will come back with the answer
9 replies
DTDrizzle Team
•Created by Dari on 7/3/2024 in #help
Drizzle Push to Turso fails on third attempt
Hey @Dari. The problem lies with your schema. You should change
current_timestamp
to (current_timestamp)
and reset your database3 replies
DTDrizzle Team
•Created by Angel on 6/5/2024 in #help
UUID Cast error with pg and aws-data-api in kit studio
This is bug and will be fixed
9 replies
DTDrizzle Team
•Created by wylex on 6/14/2024 in #help
__old_push table
Got it, could you show
municipio
table please?4 replies
DTDrizzle Team
•Created by wylex on 6/14/2024 in #help
__old_push table
Hey @wylex Could you show your schema please?
4 replies
DTDrizzle Team
•Created by mutex on 6/9/2024 in #help
Use COALESCE in index
got it, I will reproduce and make issue for this case. thank you!
4 replies
DTDrizzle Team
•Created by mutex on 6/9/2024 in #help
Use COALESCE in index
Hey @mutex! Try to wrap into parentheses:
4 replies
DTDrizzle Team
•Created by Jeremy on 5/4/2024 in #help
Is there a way to have Prototype / Push run without confirmation?
Hey @BumontheRun @Jeremy. Make sure to off
strict
parameter in your drizzle.config.ts
file.
https://orm.drizzle.team/kit-docs/config-reference#strict
If we speak about data loss confirmation then it is not possible to skip now4 replies
DTDrizzle Team
•Created by Cambaru on 6/9/2024 in #help
Creating DB with schema
Hey @Cambaru! You should specify mode for your schema in drizzle parameters like here: https://orm.drizzle.team/docs/rqb#modes
2 replies
DTDrizzle Team
•Created by Carlos Ziegler on 6/6/2024 in #help
Next Js middleware error " ⨯ cloudflare:socketsModule build failed: UnhandledSchemeError: Readin":
Hey @Carlos Ziegler! What db client are you using?
2 replies
DTDrizzle Team
•Created by Fair Enough on 6/7/2024 in #help
Weird unique constraint
Hey @MyMainWasBanned. You can create unique index with
lower
expression
You can check this guide to learn how to do unique case insensitive column based on email
https://orm.drizzle.team/learn/guides/unique-case-insensitive-email2 replies
DTDrizzle Team
•Created by Louis on 6/7/2024 in #help
Reference the same table
Hey @Louis. You should add type
AnyPgColumn
4 replies
DTDrizzle Team
•Created by diurivj on 5/25/2024 in #help
Drizzle studio doesn't handle timestamps properly
Hey @DiamondDragon. I will reproduce this issue and will reply later
4 replies
DTDrizzle Team
•Created by Paul on 6/3/2024 in #help
How to set a GIN index on the JSONB column?
Hey @Paul! You can use new index API for orm version 0.31 or higher & drizzle-kit version 0.22.0 or higher.
https://github.com/drizzle-team/drizzle-orm/releases/tag/0.31.0
But I am not sure about the second one
3 replies
DTDrizzle Team
•Created by Paul on 6/3/2024 in #help
When using a foreignKey({}), is there a way to specify onDelete: "cascade'?
Yep, we will add it to the docs, thanks!
4 replies
DTDrizzle Team
•Created by Paul on 6/3/2024 in #help
When using a foreignKey({}), is there a way to specify onDelete: "cascade'?
Hey @Paul. Try this
4 replies
DTDrizzle Team
•Created by ar7casper on 5/29/2024 in #help
Migration and existing policy issues
Hey @Qing @ quotion.co, as of now, Drizzle does not generate the 'IF NOT EXISTS' statement in migration SQL directly. However, in the future, there will be an option to generate SQL with or without the 'IF NOT EXISTS' statement.
6 replies
DTDrizzle Team
•Created by andystevenson on 5/29/2024 in #help
weirdness with sql`CURRENT
It won't fix your issue because there is a problem in drizzle studio. But team knows this bug, so it will be fixed:)
(CURRENT_TIMESTAMP)
instead of CURRENT_TIMESTAMP
just prevents issues that could be raised by push
command because Drizzle Kit can misidentify if it is a string or constraint, so parentheses are important5 replies