jsingleton37
DTDrizzle Team
•Created by jsingleton37 on 9/2/2024 in #help
What is the best way to get distinct values from a table?
![No description](https://cdn.answeroverflow.com/1280196179325354108/image.png)
3 replies
DTDrizzle Team
•Created by jsingleton37 on 8/16/2024 in #help
Properly setting timestamp column
![No description](https://cdn.answeroverflow.com/1273888456073809923/image.png)
1 replies
DTDrizzle Team
•Created by jsingleton37 on 7/27/2024 in #help
Confused about onConflictDoUpdate when having a constraint
I have a table that looks like
and after going through some docs, I was doing an insert like so
However, I get
PostgresError: there is no unique or exclusion constraint matching the ON CONFLICT specification
What am I doing incorrect here?4 replies
DTDrizzle Team
•Created by jsingleton37 on 7/23/2024 in #help
Is there a way to say a column value should come from another table?
I have the following two schemas
And in the
weeks
table, I want to say that the year should come from the seasons
table. Is that something that's possible? Is that something that is advisable? I currently grab this information from an ESPN endpoint, but figured I should probably migrate this into my own DB so I don't rely on an endpoint that could potentially get blocked.3 replies
DTDrizzle Team
•Created by jsingleton37 on 7/20/2024 in #help
Is there a way to just return a specific column?
I have a DB that holds voting results and I want to grab all the weeks that have votes. I.e. if there are votes for weeks 0-5, I just want to return 0, 1, 2, 3, 4, 5 and not the entire row for each of those weeks.
7 replies
DTDrizzle Team
•Created by jsingleton37 on 7/5/2024 in #help
TypeError saying `id` doesn't exist in table?
![No description](https://cdn.answeroverflow.com/1258889486524485772/image.png)
1 replies
DTDrizzle Team
•Created by jsingleton37 on 6/19/2024 in #help
Is there a way to check/constrain a column?
![No description](https://cdn.answeroverflow.com/1253120811791941693/image.png)
1 replies
DTDrizzle Team
•Created by jsingleton37 on 6/15/2024 in #help
Querying DB returning same row for two different userIds
Hi everyone 👋 ,
I am running into an issue where I have two different users logged in (one on Chrome and one on Safari) to test multiple users logging in at once. One user has submitted a ballot and the other has not. However, with the one that has not voted,
hasVoterVoted
is returning true AND getUsersVote
is returning the vote of the other user. I logged out user.userId
and they are different in each call... So why would drizzle/supabase be returning the exact same information for two different userId? My guess is due to the eq(model.userId, user.userId) && eq(model.year, year) && eq(model.week, week)
because if I remove the check for year and week in the hasVoterVoted
, it returns false for the user who has not voted.2 replies
DTDrizzle Team
•Created by jsingleton37 on 6/15/2024 in #help
How to add a new column to an existing table
![No description](https://cdn.answeroverflow.com/1251414014391619675/image.png)
2 replies
DTDrizzle Team
•Created by jsingleton37 on 6/10/2024 in #help
onConflictDoNothing still incrementing primaryKey
![No description](https://cdn.answeroverflow.com/1249537726047326312/image.png)
9 replies
DTDrizzle Team
•Created by jsingleton37 on 6/4/2024 in #help
What's the best way to prevent duplicate entries?
I am building a voting app for college sports. A user can go and submit their Top 25 teams each week in a season.
My API route looks like
Right now I can just keep submitting the same form over and over again. Is there a quick and dirty way to just see if this user has submitted a vote for that week and year? Currently year is just autopopulated.
11 replies
DTDrizzle Team
•Created by jsingleton37 on 6/2/2024 in #help
Drizzle Studio Not Showing Tables that are in Supabase
I am starting to work on a project and using Drizzle and Supabase. I just did a
drizzle-kit generate
followed by a drizzle-kit migrate
. When I look in supabase.com it shows that table. However, when I run drizzle-kit studio
, I just get a spinner. This is what my drizzle.config.ts
looks like
The POSTGRES_URL
is from the Vercel & Supabase integration and uses the port 6543
. However, if I use the POSTGRES_URL_NON_POOLING
env var that ends in 5432
, the studio will load. When looking into Supabase's Database Settings, it looks like the one ending in 6543
is for transaction mode and the one ending in 5432
is for session mode. Does this mean I need to use the non pooling URL for drizzle studio?3 replies
DTDrizzle Team
•Created by jsingleton37 on 6/2/2024 in #help
Trying to figure drizzle & Supabase out
![No description](https://cdn.answeroverflow.com/1246901960406204629/image.png)
1 replies