rushil1o1 Posts - Answer Overflow

Topics

rushil1o1

•Created by rushil1o1 on 9/28/2023 in #help

WHERE clause on UNIQUE INDEX postgres does not generate the right migration statement

No description

3 replies

•Created by rushil1o1 on 9/13/2023 in #help

Any way to invoke a SQL function?

For ex: lets say I declare a SQL function CREATE OR REPLACE FUNCTION do_something() how do i invoke this function using Drizzle's interface?

3 replies

•Created by rushil1o1 on 8/17/2023 in #help

updatedAt timestamp update on DB row update

Whats the best way to update Postgres values for updatedAt --- I'm assuming there's a drizzle helper ? Can't find anything

2 replies

•Created by rushil1o1 on 8/8/2023 in #help

Suggestion: Add warning when adding breaking changes.

2 replies

•Created by rushil1o1 on 6/9/2023 in #help

Query from table with where clause NOT IN another sub query?

For ex: select * from TableA where email not in (select email from TableB); ?

3 replies

•Created by rushil1o1 on 4/13/2023 in #help

[BUG?] Postgres transactions throwing connection timeouts after a lot of queries

I think there's a syntax error in Postgres transactions ----> see screenshot cc: @bloberenober

36 replies

•Created by rushil1o1 on 4/10/2023 in #help

[Bug] Postgres migrations are broken on 0.23.10

22 replies

•Created by rushil1o1 on 4/6/2023 in #help

Migrations not working on github actions

9 replies

•Created by rushil1o1 on 4/4/2023 in #help

Drizzle recommended way to migrate reset

Apologies if this is a stupid question, I just recently migrated out of prisma and into drizzle. One of our common use cases for the dev DB was to run yarn prisma migrate reset when we wanted to reset our DB. Is there a drizzle equivalent way to do that?

7 replies

•Created by rushil1o1 on 4/4/2023 in #help

[Bug?] Drizzle generates a broken query when passing an explicit value for a column as `undefined`

7 replies

•Created by rushil1o1 on 4/3/2023 in #help

Drizzle-kit throws module not found error for internal files imported through absolute path

1 replies

•Created by rushil1o1 on 3/29/2023 in #help

BUG: Postgres migration script generates a few syntax errors

34 replies

•Created by rushil1o1 on 3/28/2023 in #help

Any easy way to create a typescript ENUM type from pgEnum?

Prisma used to auto-gen all the enum types as well which are heavily used in our application.

15 replies

•Created by rushil1o1 on 3/28/2023 in #help

Plans to add array related support for Postgres?

6 replies

•Created by rushil1o1 on 3/27/2023 in #help

Numeric // Decimal Postgres types are inferred as strings and expect string as an input as well

No description

8 replies

•Created by rushil1o1 on 3/27/2023 in #help

Is it recommended to create a SQL transaction every time we try to create a foreign relationship?

3 replies