Sara Comments - Convex Community

Sara

Posts Comments

CCConvex Community

•Created by Sara on 3/15/2025 in #support-community

Considering convex as a database for a job tracker with background scripts

I'm not trying to copy others, I just need to close the limitations

7 replies

CCConvex Community

•Created by Sara on 3/15/2025 in #support-community

Considering convex as a database for a job tracker with background scripts

I don't want to get sued, but if you search up "- .- .--. / -.-. .- .-. . . .-. ..." you'll find out one of the few I'm talking about

7 replies

CCConvex Community

•Created by Sara on 3/15/2025 in #support-community

Considering convex as a database for a job tracker with background scripts

Mainly keeping things efficient and running without overloading the functions, or over charging the GMAIL API and/or the gemeni ai. I've decided yesterday to use a loop and chunk the calls to match the limits.

7 replies

CCConvex Community

•Created by Sara on 2/9/2025 in #support-community

can I do this type defenition like in typescript with v validator?

update: I created an object that has keys and values and the type seems to resemble what I want.

const newType = v.object({key:textData, value:v.array(v.string())})

const newType = v.object({key:textData, value:v.array(v.string())})

4 replies

CCConvex Community

•Created by Sara on 1/30/2025 in #support-community

while using pagination, I'm failing to sort the elements in the right order of creation

of course, so My initial code looked something like this:

    const results = await ctx.db
      .query('directMessages')
      .withIndex('by_directMessageChannelId', (q) =>
        q.eq('directMessageChannelId', args.channelId),
      )
      .order("desc")
      .paginate(args.paginationOpts)

// on my client after making a copy of the array
    const sortMessages = [...messages].sort((a,b) => a._creationTime-b._creationTime)

    const results = await ctx.db
      .query('directMessages')
      .withIndex('by_directMessageChannelId', (q) =>
        q.eq('directMessageChannelId', args.channelId),
      )
      .order("desc")
      .paginate(args.paginationOpts)

// on my client after making a copy of the array
    const sortMessages = [...messages].sort((a,b) => a._creationTime-b._creationTime)

and I am passing in the paginated query on my client InitialNumberOfItems, I guess it was indeed the use of .sort immediately here, cause after I copied the array it seems to be correct, because now after the second load I don't see the messages in a reversed order. but, is there a way to make this work in my convex query? something like this maybe? https://stack.convex.dev/pagination#jump-to-a-location-and-scroll-up

6 replies

CCConvex Community

•Created by Sara on 1/29/2025 in #support-community

discussing the best approach to add notifications on tables in a chat app.

but now thinking about I would do this on client first 😅

8 replies

CCConvex Community

•Created by Sara on 1/29/2025 in #support-community

discussing the best approach to add notifications on tables in a chat app.

You are correct, when you add a trigger, you need to wrap the mutaion with the trigger to see all the changes :)) you've given me an idea, with adding the isActive to the members table, I remember convex has a usePresence hook that could help with that!

8 replies

CCConvex Community

•Created by Sara on 1/29/2025 in #support-community

discussing the best approach to add notifications on tables in a chat app.

Yeah, I already have a membersInChannel table, this would work, but I need it to work for notifications now

8 replies

CCConvex Community

•Created by Sara on 1/20/2025 in #support-community

How do I search for a value in a table that is related to another table in relationship?

oh totally, I'm thinking of using that to specific filtering method since I have added the channel Id to the schema

9 replies

CCConvex Community

•Created by Sara on 1/20/2025 in #support-community

How do I search for a value in a table that is related to another table in relationship?

Yep, and i didn't want to use filter

9 replies

CCConvex Community

•Created by Sara on 1/20/2025 in #support-community

How do I search for a value in a table that is related to another table in relationship?

That's what i initially wanted to do (to use paginator) , but it some how flopped when i was trying to figure out how to search "every channel for that search query" so i went with using an async map and checking for first 5 that match that search query

9 replies

CCConvex Community

•Created by Sara on 1/6/2025 in #support-community