Convex Community

CC

Convex Community

Join the Convex Discord! Explore Convex, the open-source reactive database for app developers.

Join

support-community

show-and-tell

general

self-hosted

announcements

How to handle pagination with AND/OR filter on a value from another table?

Let's say I have the table post,tag,post_tag (join table). I want to support filtering posts by tags, with either an OR/AND filter on the tags. There could be many posts, so we probably need to paginate. ...

what math does the vector index _score use?

I'm guessing cosin similarity? But I don't see the actual description anywhere in the docs.

How do i do cross subdomain auth in workos and not have the redirect take me to local host

I want to have cross subdomain auth I also have a different host called test rather than localhost and I am running nextjs. so post login i get redirected to http://localhost:5170 instead of http://test:5170 is there any way to fix this...

⚠️ IMPORTANT: This channel is for COMMUNITY support

If you feel that others in the Convex community can help solve a problem that you're facing, feel free to post here. If your issue is related to your account (payments, dashboard access, etc.), please reach out the Convex support team. Pro account users can do so directly from the dashboard. If the dashboard isn't working, or you're not a Pro user, email support@convex.dev Also remember that there are other channels for specific features: Chef, components, Convex auth, etc. If one of those is a better fit for your question/problem, consider posting there before posting here....

Convex Dashboard and project down for my account

https://dashboard.convex.dev/t/sorin-2a17b/lust-f4ac1 the project mentioned above is not working as in the API is down in the app, and my entire team dashboard is stuck in loading....

Trouble importing Password

Hi all! Im having trouble using this module. I already installed @convex-dev/auth
No description

Cron Recover keeps on running all the time

I keep on having crons:recover run every 30 min and I have no clue why I have no crons set. I have crons enabled as a component but not yet configured. There are no crons on the page either. Does anyone know why this happens?...
No description

Within Usage Limit but still Disabled

I upgraded my usage limit last night and it seemed to re-enable my project, but then this morning it was still disabled. My estimated spend sits at 0.44c, well within the $10 limit I have set. I also tried changing my limit to unlimited and the project still didn't re-enable. How is there not a button to re-enable it? What should I do?...
No description

Error for one deployment but not another

Hey all, Another team member of mine is getting a 422 error on their deployment when testing out my PR, we hopped on a call, their branch is up to date, server is restarted, and their environment seems to be set up correctly. Their NEXT_PUBLIC_CONVEX_URL follows the https://<their-deployment-id>.convex.cloud pattern, and their key is their deployment id as well (not a url)....

Python Client: Is set_auth() thread-safe for concurrent requests?

Context: I'm building a FastAPI backend that serves multiple concurrent users. To optimize Convex WebSocket connection overhead (~400-600ms per new connection), I want to reuse a single ConvexClient instance across requests and call set_auth(user_token) per-request. Current Setup:...

Multi users tenant - Issue

we have a developer who has setup and POC convex. Now were using it and i am the admin who would add card details and setup the team. I have an acccount also. Both accounts use our @company.com email suffix. He added me to his account -> got the invite email -> when I login I cannot see the project or see him in members etc.. Any idea how to solve this?...

Unsafe assignment of an `any` value when working with Agents Component

Hey all, I might be doing something stupid here but whenever I USE (eg. return, map, reassign) the query data inside my createTool i get errors all over the place. ```...

huge read bandwidth usage

i have a fairly simple game that i made using convex, and i noticed that it is using a whole lot of read bandwidth. i've tried adding indexes to fix this, but today's usage is not much better. this has been pretty frustrating because i am way below usage on everything but this. all code is open source: https://github.com/saltjsx/quickbuck...
No description

Populate

Can we populate like same in other db like { user: true } in Prisma?

Is Convex a good for for advanced search?

I'm building out a product that is a platform for data analytics on startups. It will contain companies, executives, board members, funding rounds, etc. One of the main features is an advanced search, which will allow to search on companies and people using many filters - names, tags (for industries), funding, etc. An important note is that there will be a lot of many-to-many tables, and we need to be able to efficiently filter based on values in other tables, like tags. So all that to ask, is convex a good fit for this use case? I'm tempted by the DX and all other benefits, but this seems like it might not be the optimal workload for the product....

Static code generation <> WorkflowId

I have a project that is growing in lines of code. I am following all recommended convex practices of keeping all my functions strictly typed to minimise how much type inference typescript needs to make, but it still reached the point where it's becoming just too slow to work comfortably. I found the Static code generation section in the docs (https://docs.convex.dev/production/project-configuration#using-static-code-generation-beta) which looks like exactly what I need. I tried it out and for the most part it works perfectly. There is however an issue when paired with @convex-dev/workflow. Code generation does not work as expected for the vWorkflowId validator. I am typing my schema as follows:...

q.lte() query includes records with null or undefined fields, causing inconsistent filter results

When using q.lte() condition, the query returns documents where the indexed field is null or undefined, in addition to valid numeric values. This results in inconsistent and incorrect query outputs compared to gte(), which behaves as expected. LTE ``` export default query({...
No description

How to deploy when using Expo for mobile app?

Hey there, I am developing a mobile app with React Native Expo and Convex. I am now ready to submit it to TestFlight and start testing it in a real production environment, but I am not sure how to deploy the convex part of things. I do not have a website / webapp version, it is only a mobile app. Any guidance is much appreciated. ...

what is the BEST way to do left-join query like in Convex?

schema: users { userId, name } post { postId, userId, post } relationship:...

Using image with agents

I'm trying to allow my agent to use an image URL I send him and call a tool to describe the image(s). The problem is that by providing it in my content such as : {type: "image", [...]} my agent can't retrieve the URL anymore. So in the following calls, it can't perform actions on my image. I found a solution for it to work but it's to add an other message in my content with the image url (but it's ugly AND, how am I supposed to hide it from the user ?). That way my agent will have the url for further tool called....
Next