Retrieving many-to-many joins
Hey, is there a way to just select so fields to retrieve? Because I querying a table taht contains the userId and the teamId, and I would like to just get the teamId's in order to then query the data of those ID and return it. (In order to show the user all the teams where its a member).
How would you perform a "contains" query
How would you perform a "contains" query as opposed to querying by a single id, meaning that the classic query will filter by a single id with the
eq
operator, for example:
```ts
export const findItemsByCategory = query({
args: { catgoryId: v.id('category') },
handler: async ({ db }, { catgoryId }) => {...I can see some queries in my convex logs
I can see some queries in my convex logs invocated at mid-night (GMT). I'm sleeping at that time and I'm pretty sure there is no one other than me who have access to the project. Is logs working alright?

Exposing cron jobs metadata
Hello, I have a question. Is there a way to fetch and display the status of a cron job on the front end so a user will know when the next cron job execution is scheduled? Thanks.
Can convex deploy python
I'm new to this, can Convex itself not deploy node.js or Python projects? Do I need to use third-party tools to deploy on Convex?
npx convex dev fails
Not sure if this is the right place to ask. But I cannot my device to convex after running
npx convex dev
. I have tried about 10 times, and it throws 'socket timeout' or 'TypeError: fetch failed' error.
Rate limiting in Convex
is there a recommended approach for rate limiting http endpoints with Convex? Or do I have to build my own solution
exporting data from dev to prod
I cant seem to find it or im just dumb but do yall know any resources on migrating data from dev to prod? Specially when theres multiple relationships. It doesn't let me add a snapshot with the id it changes the id of a document all the time. Do I have to write my own script to deal with this?
Convex query best practices
I didn't really index the invite codes but i did it with posts. Is it best practice to index everything?
Groupby with Convex
Hey guys, just playing with convex here for a project. Still trying to understand the way to deal with queries. I saw the group by example at the documentation. It looks like it returns all the elements and and to a reduce to group by.
I have a table with over 800 items, I just need to get the a group by list of one field. ex:
exercises: { name: "squat", muscleGroup: "hamstrings" ... } I need to get all the different values of muscleGroup. Is there any easier way so I dont send off the exercise data over the wire?...
Sending a function as an argument to a function
yeah, I have these helpers in javascript, mainly generated to make it less syntactically heavy to generate backend functions.
The above is a little bit more different. Essentially, I want to be writing all my database functions on the front end so I (theoritically) dont need to design custom calls for each new query I want to make. So the idea was to pass down a custom function that has the filtering and ordering built out on the front end already as a function that takes in a ctx and have it run that function on the back end. I assumed this was very security prone and Im wondering if thats correct.
Regardless, my current system does things more traditionally and creates the backend query endpoints separately for each use case....
Convex tsconfig no inputs found
This one: No inputs were found in config file [file path]. Specified 'include' paths were ["./*/"]' and 'exclude' paths were '["./_generated"] .
What's the url being requested here? You
What's the url being requested here? You can probably see it in the network tab of your browser. Sometimes this is cause by loading a script that doesn't exist. Sometimes it's actually caused by the wrong mime type.
lazy query
hey all, I was working on a project yesterday and I needed a "lazy" query to happen when I clicked a search button. I realized I could use a mutation for this, and still just query data within the handler. I realize this is probably well-known, but I tried to find it mentioned in the docs as a "tip" or something. I couldn't find it. Is this in the docs somewhere? Are there any other useful tips like this?
Debugging in local dev
Hello community. How do I test/debug my
http actions
as I'm developing locally? When I run npx convex dev
, are these http actions
exposed at http://localhost:port
?