Night Comments - Convex Community

Thanks for all these possible methods! I'll probably stick with collect for now and if there's a performance problem I'll try out that indexing strategy because it's very unlikely I'd ever need to delete the rows in this table.

19 replies

CCConvex Community

•Created by Night on 1/27/2023 in #general

Table size

So it would be linear either way

19 replies

CCConvex Community

•Created by Night on 1/27/2023 in #general

Table size

So I'd need to query anyway. I'm just wondering if count() would be more optimized than collect().length

19 replies

CCConvex Community

•Created by Night on 1/27/2023 in #general

Table size

I'm trying to select a random row in a table of texts to get a single column. My algorithm is: 1) Query texts and collect 2) Get length 3) Generate random index 4) Return that row

19 replies

CCConvex Community

•Created by Night on 1/27/2023 in #general

Table size

I'm using a Math.random() to generate a random integer between 0 and the length of the table

19 replies

CCConvex Community

•Created by Night on 1/20/2023 in #general

Unique Indexes

Or, perhaps list these "common error messages" in the documentation for Indexes and each page

17 replies

CCConvex Community

•Created by Night on 1/20/2023 in #general

Unique Indexes

Yeah, I think it makes sense because it goes with the ordering of the columns when defining the index, but if the error message could indicate this, that would be very helpful (one of my few complaints with NextJS is that the error messages tell me absolutely nothing about where to start debugging)

17 replies

CCConvex Community

•Created by Night on 1/20/2023 in #general

Unique Indexes

Ah I see, yes, thank you

17 replies

CCConvex Community

•Created by Night on 1/20/2023 in #general

Unique Indexes

But I am querying them in the same order that I indexed them

17 replies

CCConvex Community

•Created by Night on 1/20/2023 in #general

Unique Indexes

This is my code:

export default mutation(withUser(async ({ db, user }, race) => {

  if ((await db.get(new Id('races', race))).ended) {
    return;
  }

  const standingId = await db.query('standings').withIndex('combo', q => q.eq('race', race) && q.eq('user', user)).collect();
  if (standingId) return

  return await db.insert('standings', {
    race: new Id('races', race),
    user: user._id
  })
}));

export default mutation(withUser(async ({ db, user }, race) => {

  if ((await db.get(new Id('races', race))).ended) {
    return;
  }

  const standingId = await db.query('standings').withIndex('combo', q => q.eq('race', race) && q.eq('user', user)).collect();
  if (standingId) return

  return await db.insert('standings', {
    race: new Id('races', race),
    user: user._id
  })
}));

17 replies