sonandmjy Comments - Convex Community

sonandmjy

Posts Comments

CCConvex Community

•Created by atadan on 4/3/2025 in #support-community

r2/actionRetrier cleanupExpiredRuns cron job stuck at loop

29 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

I'm did something similar before and it worked for me, mostly trusted convex to do the ordering for me but i did do some grouping in client side. This is my code if it helps

// client side
export function groupMessagesByDate(messages: TMessage[]) {
  const groupMessages = messages.reduce(
    (acc, message) => {
      const date = dayjs(message._creationTime).format("YYYY-MM-DD");
      if (!acc[date]) {
        acc[date] = [];
      }
      acc[date].push(message);
      return acc;
    },
    {} as Record<string, TMessage[]>,
  );

  const flattenedMessages = [];
  const stickyIndexes = new Set<number>();
  let currentIndex = 0;

  for (const [date, msgs] of Object.entries(groupMessages).reverse()) {
    stickyIndexes.add(currentIndex);
    flattenedMessages.push(date);
    currentIndex += 1;
    flattenedMessages.push(...msgs.reverse());
    currentIndex += msgs.length;
  }

  return { flattenedMessages, stickyIndexes };
}

function MyComponent() {
  const { results, status, loadMore } = usePaginatedQuery(
  api.messages.getMessagesByDestinationAndChannelId,
    {
      destinationId,
      channelId,
      order: "desc",
    },
    {
      initialNumItems: 20,
    },
  );

  const groupedMessages = useMemo(() => {
    return results ? groupMessagesByDate(results) : undefined;
  }, [results]);
...
}



// convex
...
  ctx.db
    .query("messages")
    .withIndex("by_organizationId", (q) =>
      q.eq("organizationId", ctx.user.defaultOrganizationId!),
    )
    .filter((q) => {
      return q.and(
        q.or(
          ...args.destinationIds.map((d) =>
            q.eq(q.field("destinationId"), d),
          ),
        ),
        q.neq(q.field("status.statusId"), messageStatusIds.scheduled),
      );
    })
    .order(order)
    .paginate(args.paginationOpts)
...

// client side
export function groupMessagesByDate(messages: TMessage[]) {
  const groupMessages = messages.reduce(
    (acc, message) => {
      const date = dayjs(message._creationTime).format("YYYY-MM-DD");
      if (!acc[date]) {
        acc[date] = [];
      }
      acc[date].push(message);
      return acc;
    },
    {} as Record<string, TMessage[]>,
  );

  const flattenedMessages = [];
  const stickyIndexes = new Set<number>();
  let currentIndex = 0;

  for (const [date, msgs] of Object.entries(groupMessages).reverse()) {
    stickyIndexes.add(currentIndex);
    flattenedMessages.push(date);
    currentIndex += 1;
    flattenedMessages.push(...msgs.reverse());
    currentIndex += msgs.length;
  }

  return { flattenedMessages, stickyIndexes };
}

function MyComponent() {
  const { results, status, loadMore } = usePaginatedQuery(
  api.messages.getMessagesByDestinationAndChannelId,
    {
      destinationId,
      channelId,
      order: "desc",
    },
    {
      initialNumItems: 20,
    },
  );

  const groupedMessages = useMemo(() => {
    return results ? groupMessagesByDate(results) : undefined;
  }, [results]);
...
}



// convex
...
  ctx.db
    .query("messages")
    .withIndex("by_organizationId", (q) =>
      q.eq("organizationId", ctx.user.defaultOrganizationId!),
    )
    .filter((q) => {
      return q.and(
        q.or(
          ...args.destinationIds.map((d) =>
            q.eq(q.field("destinationId"), d),
          ),
        ),
        q.neq(q.field("status.statusId"), messageStatusIds.scheduled),
      );
    })
    .order(order)
    .paginate(args.paginationOpts)
...

6 replies

CCConvex Community

•Created by too_easy on 2/7/2025 in #support-community

Could not load the "sharp" module using the linux-arm64 runtime

I’ve tried it with npm before and it works but i believe u have to use the node runtime and u have to externalise the module node runtime https://docs.convex.dev/functions/runtimes externalise https://docs.convex.dev/functions/bundling#external-packages

5 replies

CCConvex Community

•Created by sonandmjy on 2/4/2025 in #support-community