pez Comments - Convex Community

pez

Posts Comments

CCConvex Community

•Created by pez on 3/18/2025 in #support-community

Tips on sending batch notifications to a large group of users at once?

@jamwt super cool stuff. will give it a try!

13 replies

CCConvex Community

•Created by pez on 3/21/2025 in #support-community

Fetching a random subset of documents without having to collect() over the entire set?

hey Jamie, noticing that randomize.count(ctx) is returning 0 for some reason. I did the following:

const randomize = new TableAggregate<{
  DataModel: DataModel;
  TableName: "templateQuestions";
  Key: null;
}>(components.templateQuestions, {
  sortKey: () => null,
});

const randomize = new TableAggregate<{
  DataModel: DataModel;
  TableName: "templateQuestions";
  Key: null;
}>(components.templateQuestions, {
  sortKey: () => null,
});

at the top of my functions file. and added

import { defineApp } from "convex/server";
import aggregate from "@convex-dev/aggregate/convex.config";

const app = defineApp();
app.use(aggregate, { name: "templateQuestions" });

export default app;

import { defineApp } from "convex/server";
import aggregate from "@convex-dev/aggregate/convex.config";

const app = defineApp();
app.use(aggregate, { name: "templateQuestions" });

export default app;

to convex.config.ts

40 replies

CCConvex Community

•Created by pez on 3/21/2025 in #support-community

Fetching a random subset of documents without having to collect() over the entire set?

you're for sure allowed in!!!

40 replies

CCConvex Community

•Created by pez on 3/21/2025 in #support-community

Fetching a random subset of documents without having to collect() over the entire set?

would be a valuable perspective

40 replies

CCConvex Community

•Created by pez on 3/21/2025 in #support-community

Fetching a random subset of documents without having to collect() over the entire set?

havent talked to too many ppl in very long term relationships

40 replies

CCConvex Community

•Created by pez on 3/21/2025 in #support-community

Fetching a random subset of documents without having to collect() over the entire set?

i am in a 2 year one :p but would love feedback from you (seriosuly)

40 replies

CCConvex Community

•Created by pez on 3/21/2025 in #support-community

Fetching a random subset of documents without having to collect() over the entire set?

would love feedback!

40 replies

CCConvex Community

•Created by pez on 3/21/2025 in #support-community

Fetching a random subset of documents without having to collect() over the entire set?

thank you! feel free to download the app too, we just launched

40 replies

CCConvex Community

•Created by pez on 3/21/2025 in #support-community

Fetching a random subset of documents without having to collect() over the entire set?

haha

40 replies

CCConvex Community

•Created by pez on 3/21/2025 in #support-community

Fetching a random subset of documents without having to collect() over the entire set?

but recently pivoted to https://trycandle.app

40 replies

CCConvex Community

•Created by pez on 3/21/2025 in #support-community

Fetching a random subset of documents without having to collect() over the entire set?

we were building www.shopencore.ai during the batch

40 replies

CCConvex Community

•Created by pez on 3/21/2025 in #support-community

Fetching a random subset of documents without having to collect() over the entire set?

thank you for building this

40 replies

CCConvex Community

•Created by pez on 3/21/2025 in #support-community

Fetching a random subset of documents without having to collect() over the entire set?

btw, just applied for the YC deal and have been loving my experience so far

40 replies

CCConvex Community

•Created by pez on 3/21/2025 in #support-community

Fetching a random subset of documents without having to collect() over the entire set?

solid idea! lemme try that sir

40 replies

CCConvex Community

•Created by pez on 3/21/2025 in #support-community

Fetching a random subset of documents without having to collect() over the entire set?

just wanna make sure I'm not sending back and forth the entire list each time :/

40 replies

CCConvex Community

•Created by pez on 3/21/2025 in #support-community

Fetching a random subset of documents without having to collect() over the entire set?

cool, would this random aggregate approach help me limit db bandwidth usage though?

40 replies

CCConvex Community

•Created by pez on 3/21/2025 in #support-community

Fetching a random subset of documents without having to collect() over the entire set?

export const getRandomTemplateQuestionsNew = query({
  args: {
    offset: v.number(),
    quantity: v.number(),
    seed: v.string(),
    exclusionIds: v.optional(v.array(v.id("templateQuestions"))),
  },
  handler: async (ctx, { offset, quantity, seed, exclusionIds }) => {
    const count = await randomize.count(ctx);

    const rand = new Rand(seed);
    const allIndexes = Array.from({ length: count }, (_, i) => i);
    shuffle(allIndexes, rand);
    const indexes = allIndexes.slice(offset, offset + quantity);

    const atIndexes = await Promise.all(
      indexes.map((i) => randomize.at(ctx, i))
    );

    return await Promise.all(
      atIndexes.map(async (atIndex) => {
        const doc = (await ctx.db.get(atIndex.id))!;
        return doc;
      })
    );
  },
});

export const getRandomTemplateQuestionsNew = query({
  args: {
    offset: v.number(),
    quantity: v.number(),
    seed: v.string(),
    exclusionIds: v.optional(v.array(v.id("templateQuestions"))),
  },
  handler: async (ctx, { offset, quantity, seed, exclusionIds }) => {
    const count = await randomize.count(ctx);

    const rand = new Rand(seed);
    const allIndexes = Array.from({ length: count }, (_, i) => i);
    shuffle(allIndexes, rand);
    const indexes = allIndexes.slice(offset, offset + quantity);

    const atIndexes = await Promise.all(
      indexes.map((i) => randomize.at(ctx, i))
    );

    return await Promise.all(
      atIndexes.map(async (atIndex) => {
        const doc = (await ctx.db.get(atIndex.id))!;
        return doc;
      })
    );
  },
});

40 replies

CCConvex Community

•Created by pez on 3/21/2025 in #support-community

Fetching a random subset of documents without having to collect() over the entire set?

ah wait i think i may have miscommunicated. the idea here is that users will have answered questions on previous days (this is a daily question challenge app), and each day we give them a random list of 30 questions they can mouse through (but answer only 3 of them). I just wanna ensure that if a user has answered a question already (I have these ids), I don't show those as an option to the user again. I'm using a list of exclusion ids for this.

40 replies

CCConvex Community

•Created by pez on 3/21/2025 in #support-community

Fetching a random subset of documents without having to collect() over the entire set?

and you'll know you won't show the same question again

how would i know this?

40 replies

CCConvex Community

•Created by pez on 3/21/2025 in #support-community

Fetching a random subset of documents without having to collect() over the entire set?

hmm, the list of questions can change over time (we add more on a weekly basis). they aren't expected to change too often though

40 replies