Mr Volcano
Explore posts from serversDTDrizzle Team
•Created by Mr Volcano on 11/3/2023 in #help
Appending SQL chunks to a query
I really appreciate your help 😉
13 replies
DTDrizzle Team
•Created by Mr Volcano on 11/3/2023 in #help
Appending SQL chunks to a query
Thank you guys, I will try and take it from here
13 replies
DTDrizzle Team
•Created by Mr Volcano on 11/3/2023 in #help
Appending SQL chunks to a query
Looks good. So it's pretty much the same even if I add the
ArrayIn operator, right ? Because thats what I'll need to use to filter based on multiple "status" params13 replies
DTDrizzle Team
•Created by Mr Volcano on 11/3/2023 in #help
Appending SQL chunks to a query
Yeah, I'm at this point right now. I can get the related user that belongs to a campaign, now Im trying to see how I can get the campaign users where their status are
status1 OR status2 etc13 replies
DTDrizzle Team
•Created by Mr Volcano on 11/3/2023 in #help
Appending SQL chunks to a query
Yeap, in some cases it will have to be Angelelz
13 replies
DTDrizzle Team
•Created by Mr Volcano on 11/3/2023 in #help
Appending SQL chunks to a query
yes ofc!
So I have a NextJS route that gives me some query params like this:
searchParams: { [key: string]: string | string[] | undefined };
Query params can be: campaignId and status .
A special case is here is that can be multiple "status" params. So:
"status=ACTIVE" and "Status=INACTIVE" etc
I'm now wondering how I can see which params are present, what are their values, and make queries to the db based on those.13 replies
DTDrizzle Team
•Created by Mr Volcano on 11/3/2023 in #help
Appending SQL chunks to a query
So far I've found this but I'm wondering if there's another way (ideally one that doesn't use raw sql)
https://orm.drizzle.team/docs/sql#sqlappend
13 replies
DTDrizzle Team
•Created by Mr Volcano on 11/1/2023 in #help
Unable to run migrations
Interesting stuff, thanks for the response!
11 replies
DTDrizzle Team
•Created by Mr Volcano on 11/1/2023 in #help
Unable to run migrations
Sounds right to me
11 replies
DTDrizzle Team
•Created by Mr Volcano on 11/1/2023 in #help
Unable to run migrations
Now I'm trying to understand why it worked
11 replies
DTDrizzle Team
•Created by Mr Volcano on 11/1/2023 in #help
Unable to run migrations
HA, I solved it. I just had to delete the "drizzle" schema and the migrations got applied and the "public" schema got its tables created
11 replies
DTDrizzle Team
•Created by Mr Volcano on 11/1/2023 in #help
Unable to run migrations
I'm using vercel postgres btw
11 replies
DTDrizzle Team
•Created by Mr Volcano on 10/19/2023 in #help
VercelPostgresError - 'missing_connection_string': You did not supply a 'connectionString'
Literally spent 5 hours straight trying to debug this
14 replies
DTDrizzle Team
•Created by Mr Volcano on 10/19/2023 in #help
VercelPostgresError - 'missing_connection_string': You did not supply a 'connectionString'
oohh okay good good. Now that makes a bit more sense.
Thank you very much, you're a wizard!
Thank you very much, you're a wizard!
14 replies
DTDrizzle Team
•Created by Mr Volcano on 10/19/2023 in #help
VercelPostgresError - 'missing_connection_string': You did not supply a 'connectionString'
Like, shouldnt drizzle be taking the variable from "connectionString" anyway ?
14 replies
DTDrizzle Team
•Created by Mr Volcano on 10/19/2023 in #help
VercelPostgresError - 'missing_connection_string': You did not supply a 'connectionString'
Hmm, didn't really get that.
When I do
connectionString = process.env.PROD_POSTGRES_URL I assign the env variable to connectionString.
Why is connectionString = process.env.POSTGRES_URL = process.env.PROD_POSTGRES_URL any different ?14 replies
DTDrizzle Team
•Created by Mr Volcano on 10/19/2023 in #help
VercelPostgresError - 'missing_connection_string': You did not supply a 'connectionString'
Hey @Angelelz and thanks for the response, this actually works!
I'm really surprised, do you mind sharing why this is working ? It looks like sorcery to me 😛
14 replies
DTDrizzle Team
•Created by Mr Volcano on 10/18/2023 in #help
VercelPostgresError - 'missing_connection_string'
Okay so I'm pretty sure this is a bug. Drizzle doesn't even look at the connection string, even if you supply it.
Instead, what it does is look for "POSTGRES_URL" inside the
Instead, what it does is look for "POSTGRES_URL" inside the
.env
That's why it previously worked fine. Because the db url was in the "POSTGRES_URL" variable and now that I renamed it to "DEV_POSTGRES_URL" it cant find it.2 replies
DTDrizzle Team
•Created by Mr Volcano on 8/30/2023 in #help
node-postgres uses crypto under the hood ?
Makes sense, thanks you again Raphael 🙂
16 replies