Sara Posts - Convex Community

Sara

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

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

I'm developing a personal job tracker for myself, and I'm basically a bit overwhelmed with what to use here, (why pay 299$ for a job tracker when you can build it yourself) What i want exactly is to have a notion notebook or just web page where i can categorise emails into offer, applied, rejected, and I'm slightly unsure on what to use here, since i want to keep the tracker running when I'm off the web page. And how should i optimize the mutations to be fast while not overloading the server or the email API? I hope i made it clear!

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?

I tried doing:

const textData = literals('x','y','z');
const typeOfTextDataInRecord = v.record(textData, v.array(v.string()))

const textData = literals('x','y','z');
const typeOfTextDataInRecord = v.record(textData, v.array(v.string()))

same as in typescript in my brain as doing this:

 type textData = ['x','y','z'];
 type howWeDoTextData = textData[number]
 type typeOfTextDataInRecord = Record <howWeDoTextData,string[]>

 type textData = ['x','y','z'];
 type howWeDoTextData = textData[number]
 type typeOfTextDataInRecord = Record <howWeDoTextData,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

while using the pagination function with a bunch of messgaes, I'm giving them order("desc") so we can get the last numItems that have been added to the array, when I do so, after the second load, the element are re-ordered bottom up, how can I fix this in the best way possible with convex? I tried sorting with .sort((a,b)=>a._creationTime -b.creationTime) but that resorts them on the second load, (the loadMore function runs at the top of the page when the user scrolls all the way up, and I want to it to act like first 25 elements, second 25 elemnts, in order 🥲 )

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.

So I have a channel with messages and users that I would like to implement notifications on, what I did so far is create a last read messages table to estimate the last message the viewer saw, from that point, what would make more sense to create notifications on the web, to run a table trigger and create a condition that when user x is sending messages and user y is receiving them, and in this case user y is not viewing the channel, we push a notification then? and when user y is viewing we turn that condition off so no notifications are being sent? does anyone have a better way to implement this?

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?

So I have a table called messages and another table called messages members, I'm trying to search for messages that are equal to the search query but at the same time the user is part of? I've tried creating a paginated query:

    const channelsWithUser = await ctx.db.query("members")
    .withIndex("by_userId", q => q.eq("userId",user._id))
    .collect(); // this has the channel id as a coloumn
    
    const allDmsThatMatch = paginator(ctx.db, schema)
    .query("directMessages")
    .withIndex("by_channelId", (q) => q.eq("channelId", /** I want to put the channelId here */))
    .order("desc")
    .paginate({numItems:10, cursor:args.searchQuery});

    const channelsWithUser = await ctx.db.query("members")
    .withIndex("by_userId", q => q.eq("userId",user._id))
    .collect(); // this has the channel id as a coloumn
    
    const allDmsThatMatch = paginator(ctx.db, schema)
    .query("directMessages")
    .withIndex("by_channelId", (q) => q.eq("channelId", /** I want to put the channelId here */))
    .order("desc")
    .paginate({numItems:10, cursor:args.searchQuery});

And I tried to mix and match using asyncMap with search:

    const allDMsThatFit = await asyncMap(channelsWithUser, async (doc) => {
      const findDMsThatMatchInChannel = await ctx.db
        .query('directMessages')
        .withSearchIndex('search_content', (q) =>
          q
            .search('directMessageContent', args_0.searchQuery)
            .eq('directMessageChannelId', doc.directMessageChannelId),
        )
        .take(5);
      return {
        findDMsThatMatchInChannel,
        channelId: doc.directMessageChannelId,
      };
    });

    const allDMsThatFit = await asyncMap(channelsWithUser, async (doc) => {
      const findDMsThatMatchInChannel = await ctx.db
        .query('directMessages')
        .withSearchIndex('search_content', (q) =>
          q
            .search('directMessageContent', args_0.searchQuery)
            .eq('directMessageChannelId', doc.directMessageChannelId),
        )
        .take(5);
      return {
        findDMsThatMatchInChannel,
        channelId: doc.directMessageChannelId,
      };
    });

but got lost on how to handle the channelId side? any advice on how can this be done?

9 replies

CCConvex Community

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

Validate Id<"tableName"> or Doc<"tableName"> on the client or server?

How can we validate the type of Id or Doc in the client with typescript? I've tried instanceOf, and casting the type but it gives me an error that the type passed is of type any, The left-hand side of an 'instanceof' expression must be of type 'any', an object type or a type parameter.ts(2358)

   if(args.Id instanceof Id<"tableName">)

   if(args.Id instanceof Id<"tableName">)

12 replies

CCConvex Community

•Created by Sara on 12/22/2024 in #support-community

Feature Request: return the number the page is on in `.paginate()`

I've hit a use case where I need to know the total page number, Previous page number, and nextPage number, is there something I might be missing with results being returned from the query?

5 replies

CCConvex Community

•Created by Sara on 12/5/2024 in #support-community

How to handle metadata fetching in nextjs(14.2.14) + Convex

If for instance I want to have the some of the user's information as metadata, How do I go by doing this with convex? cause it works just in development for me.

7 replies

CCConvex Community

•Created by Sara on 10/18/2024 in #support-community

Github Authentication issue with React Vite

8 replies

CCConvex Community

•Created by Sara on 8/24/2024 in #support-community

adding rate limits to existing auth functions (store, viewer ..etc)

I just need advice on how I can implement rate limits for pre-existing function that are coming from convex-auth, Is there a way that I can add a certain callback in my auth.ts? Because it's really important especially for anonymous sign up! Thank you for all the advice folks, I really appreciate it ❤️

4 replies

CCConvex Community

•Created by Sara on 8/16/2024 in #support-community

Copy Items in documents as individual or bulk copy

it would be great to be able to copy documents as objects or json from the dashboard, instead of creating functions for it

4 replies

CCConvex Community

•Created by Sara on 8/11/2024 in #support-community

Problem with building @convex-dev/auth@0.0.50 in deployment

33 replies

CCConvex Community

•Created by Sara on 8/1/2024 in #support-community

handling file type, and a small issue with a server package

Issue #1: I was trying to use the file system from google seen here -> google docs, in which I have a file called model.ts that already has some working structure (using async functions and convex built in functions), but when I try importing the GoogleAIFileManager I ran through this error:

⠋ Preparing Convex functions...
X [ERROR] Could not resolve "fs"

    node_modules/.pnpm/@google+generative-ai@0.16.0/node_modules/@google/generative-ai/dist/server/index.mjs:1:29:
      1 │ import { readFileSync } from 'fs';
        ╵                              ~~~~

  The package "fs" wasn't found on the file system but is built into node. Are you trying to bundle
  for node? You can use "platform: 'node'" to do that, which will remove this error.

⠋ Preparing Convex functions...
X [ERROR] Could not resolve "fs"

    node_modules/.pnpm/@google+generative-ai@0.16.0/node_modules/@google/generative-ai/dist/server/index.mjs:1:29:
      1 │ import { readFileSync } from 'fs';
        ╵                              ~~~~

  The package "fs" wasn't found on the file system but is built into node. Are you trying to bundle
  for node? You can use "platform: 'node'" to do that, which will remove this error.

and after further investigation, this could be the possible soultion -> some guy on github threads which I thought I'm already am? I know my code is complaing about the second line here:

const genAI = new GoogleGenerativeAI(apiKey as string);
const fileManager = new GoogleAIFileManager(apiKey as string)

const genAI = new GoogleGenerativeAI(apiKey as string);
const fileManager = new GoogleAIFileManager(apiKey as string)

so what would you suggest in this case? do I wrap it in an action and not use it in another file? Issue #2: I would like to pass my file as a file type to pass it through the google function that handles it for me without having to upload it somewhere or add to my cache history, and the code happend to complain that I used v.any() instead of defining it as a file like i did, what do I do in this case as a suggestion?

Error: File {} is not a supported Convex type (present at path .file in original object {"threadId":"m17a4k298pfydfecht4yevba7x6y1efy","content":"todododooleoeo","file":{}}). To learn about Convex's supported types, see https://docs.convex.dev/using/types.

Error: File {} is not a supported Convex type (present at path .file in original object {"threadId":"m17a4k298pfydfecht4yevba7x6y1efy","content":"todododooleoeo","file":{}}). To learn about Convex's supported types, see https://docs.convex.dev/using/types.

what should I do in this case?

3 replies

CCConvex Community

•Created by Sara on 7/29/2024 in #support-community

Type check help - Passing an Object of type Doc<"table_name"> but has partial values

I'm basically wondering if there's another way of Doing this type here? where the body is supposed to be of type Doc<"settings"> but partially has that type?

export const update = mutation({
  args:{settingsId: v.id("settings"), body:v.any()},
  handler:async(ctx, args_0) => {
    await ctx.db.patch(args_0.settingsId, args_0.body as Partial<Doc<"settings">>)
  },
})

export const update = mutation({
  args:{settingsId: v.id("settings"), body:v.any()},
  handler:async(ctx, args_0) => {
    await ctx.db.patch(args_0.settingsId, args_0.body as Partial<Doc<"settings">>)
  },
})

3 replies

CCConvex Community

•Created by Sara on 7/15/2024 in #support-community

A Bug with adding documents

when I add a new document from the website, about 500 new lines appear in the editing area, it has been Working earlier it is just not working properly now for some reason. it showed me an error with validating schema earlier in the console but I can't seem to reproduce it. my schema for refrence:

const schema = defineSchema({
  ...authTables,
  // Your other tables...
  profiles: defineTable({
    userId: v.id('users'), // one to one
    bio: v.string(),
  }).index('userId', ['userId']),
  // one user has many friends but 1 friend is connected to 1 user, one to many
  friends: defineTable({
    userId: v.id('users'),
    friendId:v.id('users'),
  }).index('userId',['userId'],)
  .index('friendId',['friendId']),
  requests: defineTable({
    senderId: v.id('users'),
    receiverId: v.id('users'),
    status:v.string(),
  }).index('senderId',['senderId'])
  .index('receiverId',['receiverId']),
  chats:defineTable({
    name:v.string(),
  }),
  messages:defineTable({
   chatId: v.id("chats"),
   senderId: v.id('users'),
   message: v.string(),
  })
  .index('senderId',['senderId'])
  .index('chatId',['chatId'])
});
 
export default schema;

const schema = defineSchema({
  ...authTables,
  // Your other tables...
  profiles: defineTable({
    userId: v.id('users'), // one to one
    bio: v.string(),
  }).index('userId', ['userId']),
  // one user has many friends but 1 friend is connected to 1 user, one to many
  friends: defineTable({
    userId: v.id('users'),
    friendId:v.id('users'),
  }).index('userId',['userId'],)
  .index('friendId',['friendId']),
  requests: defineTable({
    senderId: v.id('users'),
    receiverId: v.id('users'),
    status:v.string(),
  }).index('senderId',['senderId'])
  .index('receiverId',['receiverId']),
  chats:defineTable({
    name:v.string(),
  }),
  messages:defineTable({
   chatId: v.id("chats"),
   senderId: v.id('users'),
   message: v.string(),
  })
  .index('senderId',['senderId'])
  .index('chatId',['chatId'])
});
 
export default schema;

I should state it's only occurring for the messages table

22 replies