Varun Singh
CCConvex Community
•Created by oscklm on 1/15/2024 in #support-community
Advice/feedback on big schema for our video table
This is a small thing I found in taking a quick glance, but it'll make the code a bit cleaner
4 replies
CCConvex Community
•Created by oscklm on 1/15/2024 in #support-community
Advice/feedback on big schema for our video table
4 replies
CCConvex Community
•Created by Varun Singh on 1/13/2024 in #support-community
JSDoc for Convex Functions on Client
Figured it out: my front-end uses jsx instead of tsx even though my backend uses typescript. When I switch it to tsx it works
10 replies
CCConvex Community
•Created by Varun Singh on 1/13/2024 in #support-community
JSDoc for Convex Functions on Client
Ah, maybe I just need to configure something. I'll take a look
10 replies
CCConvex Community
•Created by Varun Singh on 1/13/2024 in #support-community
JSDoc for Convex Functions on Client
10 replies
CCConvex Community
•Created by Varun Singh on 12/29/2023 in #support-community
Does ConvexError replace Error?
Oh perfect, I didn't realize the ConvexError takes an object literal, thank you.
6 replies
CCConvex Community
•Created by Varun Singh on 12/27/2023 in #support-community
Database Design: Intersection of three fields
I've only avoided that approach because I want to maintain a single source of truth and I like following database normalization religiously, for better or for worse
29 replies
CCConvex Community
•Created by Varun Singh on 12/27/2023 in #support-community
Database Design: Intersection of three fields
Then I loop through this checking the team for that row, and eventually finding the competition
29 replies
CCConvex Community
•Created by Varun Singh on 12/27/2023 in #support-community
Database Design: Intersection of three fields
I ended up implementing it by using the by_user index on participants, because I figure the number of hackathons a single user enters is much less than the number of competitions there will be or the number of teams across competitions
29 replies
CCConvex Community
•Created by Varun Singh on 12/27/2023 in #support-community
Database Design: Intersection of three fields
The second one: Get the team associated with a user and a competition
29 replies
CCConvex Community
•Created by Varun Singh on 12/27/2023 in #support-community
Database Design: Intersection of three fields
The problem with this approach is that the participants table does not have a competition column, only the teams table does. Participants is essentially a "team members" table so I'd be storing duplicate information if I put competition as a column in this table.
29 replies
CCConvex Community
•Created by Varun Singh on 12/27/2023 in #support-community
Database Design: Intersection of three fields
I’ll take a look, thank you
29 replies
CCConvex Community
•Created by Varun Singh on 12/27/2023 in #support-community
Database Design: Intersection of three fields
erquhart had suggested user+competition index which is what I wanted to do but I can’t when these two fields are in two different tables
29 replies
CCConvex Community
•Created by Varun Singh on 12/27/2023 in #support-community
Database Design: Intersection of three fields
I know I can use a query on participants to get the rows that I need but I am wondering if I can do it with indexes so that it doesn’t require any iteration
29 replies
CCConvex Community
•Created by Varun Singh on 12/27/2023 in #support-community
Database Design: Intersection of three fields
That’s a good point. If in the future, it does need to be optimized to a point query, how would I add a user+competition index if the user isn’t a column? I wanted to do it this way but the way I designed it, I don’t know how to account for that even with a different design. The most efficient way I can use is the users since the number of competitions a user enters is going to be much lower than the total number of teams or participants.
29 replies
CCConvex Community
•Created by Varun Singh on 12/20/2023 in #support-community
Convex front-end error: Could not find public function
Thank you works great now!
9 replies
CCConvex Community
•Created by Varun Singh on 12/20/2023 in #support-community
Convex front-end error: Could not find public function
Got it
9 replies
CCConvex Community
•Created by Varun Singh on 12/20/2023 in #support-community
Convex front-end error: Could not find public function
Oh okay, I thought this was only used when the file is not inside a folder. Are modules usually a single file instead? Like if I put all of my functions into a competition.ts and exported them like that
9 replies