Baris
CCConvex Community
•Created by Baris on 9/29/2024 in #support-community
Turborepo Vercel Deploy Build Command
Yep, I can probably find it if I spend some time, but maybe there is someone who has done the same process who can help me.
4 replies
CCConvex Community
•Created by Baris on 9/26/2024 in #support-community
How can I get the reason for login/signup failure with Convex auth?
Thank you 🙏
13 replies
CCConvex Community
•Created by Baris on 9/26/2024 in #support-community
How can I get the reason for login/signup failure with Convex auth?
With all due respect, Jamal, while I appreciate your willingness to help, this is not the answer to what I am trying to learn.
Additionally, what you're saying isn't correct. If there isn't an active rate limiting system in place, regardless of whether you show the message or not, you could still fall victim to brute force attacks. Almost all platforms on the web nowadays display separate messages for "email not found" and "password incorrect" because it's better for the user experience. Thanks again.
13 replies
CCConvex Community
•Created by Baris on 9/26/2024 in #support-community
How can I get the reason for login/signup failure with Convex auth?
I’m using password provider
13 replies
CCConvex Community
•Created by Baris on 9/26/2024 in #support-community
How can I get the reason for login/signup failure with Convex auth?
I would appreciate it if someone from the Convex team could confirm this.
13 replies
CCConvex Community
•Created by Baris on 9/26/2024 in #support-community
How can I get the reason for login/signup failure with Convex auth?
Can you give me an example?
13 replies
CCConvex Community
•Created by Baris on 7/2/2024 in #support-community
How can I sort a query by a field in the referenced document?
Thank you once again for your time and support, Michal. After considerations, we decided to denormalize all sortable fields, and it turned out really well. 🙏
26 replies
CCConvex Community
•Created by Baris on 7/2/2024 in #support-community
How can I sort a query by a field in the referenced document?
It’s a matter of preference, and we offer endless possibilities for selecting how to view your tasks. Just because it doesn’t align with your preferences doesn’t mean it’s a ‘useless UI’
26 replies
CCConvex Community
•Created by Baris on 7/2/2024 in #support-community
How can I sort a query by a field in the referenced document?
To clarify, we don't want to display 10 thousand tasks. Only 100 tasks will be paginated, but we need the entire list to sort them. That's why I mentioned that.
We thought about creating a separate table named
task_assignee
, but it doesn't change anything. ctx.db.get
allows a maximum of 4 thousand runs. Also, a task can be in multiple projects. There are many other little things like this.26 replies
CCConvex Community
•Created by Baris on 7/2/2024 in #support-community
How can I sort a query by a field in the referenced document?
We are working on a work management & collaboration tool, a product that will compete with Notion and Asana.
Naturally, users should be able to sort their tasks by assignee. And in a project where a maximum of 10,000 tasks are allowed, we still haven't found a way to sort all the tasks without collecting them all first.
In many ways, Convex could be the best backend service we've tried so far, but such shortcomings are making us reconsider returning to SQL. Of course, these issues are not unique to Convex but are limitations of document-based databases.
26 replies
CCConvex Community
•Created by Baris on 7/2/2024 in #support-community
How can I sort a query by a field in the referenced document?
I understand, thank you for the answer, Jamie. I think I need to step away from the SQL logic a bit and adjust my schemas accordingly.
26 replies
CCConvex Community
•Created by Baris on 7/2/2024 in #support-community
How can I sort a query by a field in the referenced document?
I guess you meant to say that you wouldn’t do it this way in SQL? Since table joins can be done in SQL, there is no need to denormalize.
If I understood your suggestion for doing it Convex-style correctly, in a scenario where I have a ‘task’ and ‘assignee’ table:
I should save the assignee to each task as ‘assignee_id’ and ‘assignee_name’ and make mutations in thousands of tasks whenever an assignee’s name is edited.
Is this the standart accepted way of doing it?
26 replies
CCConvex Community
•Created by Baris on 7/2/2024 in #support-community
How can I sort a query by a field in the referenced document?
Does anyone have any other suggestions for this?
Currently, I'm retrieving all the documents from two tables, and I'm combining them with JavaScript like an SQL join. But to display 100 results, I'm querying 10,000 items…
26 replies
CCConvex Community
•Created by Baris on 7/2/2024 in #support-community
Question about query limits
Okay, thank you!
3 replies
CCConvex Community
•Created by Baris on 7/2/2024 in #support-community
How can I sort a query by a field in the referenced document?
Yes, that’s correct. Unfortunately, a user can be referenced by 1000 documents. And I have to change all of them with every name change. Also I need 4-5 other fields as well. I cannot add all of them to every document and keep them updated.
I feel like there must be another solution for a simple problem like this.
Anyway, thanks for the help Tom 🙏
26 replies