noahsolomon Comments - Answer Overflow

noahsolomon

Explore posts from servers

RReactiflux TtRPC DTDrizzle Team

Posts Comments

DTDrizzle Team

•Created by noahsolomon on 10/1/2024 in #help

pgvector returning less than it should

any help would be very much appreciated!

3 replies

DTDrizzle Team

•Created by noahsolomon on 10/1/2024 in #help

pgvector returning less than it should

This should be returning 10,000. The table has 1,200,000 entries. However, it is cutting off after 390 for some reason. This is obviously a huge problem I need fixed. I am using neondb for context, and I'm not sure if this is something to take up with them or is it a drizzle thing

3 replies

DTDrizzle Team

•Created by noahsolomon on 6/18/2024 in #help

Where clause dependent on with relation

kinda what im thinking but this isn't the right syntax ^

4 replies

DTDrizzle Team

•Created by noahsolomon on 6/18/2024 in #help

Where clause dependent on with relation

const news = await ctx.db.query.newsTable.findMany({
        limit: 20,
        offset: 20 * input.page,
        orderBy: (newsTable, { desc }) => [desc(newsTable.createdAt)],
        with: {
          tweets: {
            with: { pundit: true },
          },
        },
        where: tweets.length > 0
      });

const news = await ctx.db.query.newsTable.findMany({
        limit: 20,
        offset: 20 * input.page,
        orderBy: (newsTable, { desc }) => [desc(newsTable.createdAt)],
        with: {
          tweets: {
            with: { pundit: true },
          },
        },
        where: tweets.length > 0
      });

4 replies

Gaming

Programming