Adam Posts - Answer Overflow

Adam

•Created by Adam on 7/7/2024 in #help

Are requests memoized in Nextjs 14?

Are Drizzle requests memoized like fetch requests in Nextjs 14? In other words, can you call the same query in all components that need it without making a ton of requests for the same data?

3 replies

DTDrizzle Team

•Created by Adam on 7/24/2023 in #help

Duplicate rows from distinct query

This query returns duplicate rows. Are there any things on the surface of this query that points to what the problem is?

export async function getAllDynamicPrompts(limit: number = 10) {
    const res = await db
        .selectDistinct()
        .from(dynamicPrompts)
        .leftJoin(dynamicPromptTags, eq(dynamicPrompts.id, dynamicPromptTags.promptId))
        .leftJoin(tags, eq(dynamicPromptTags.tagId, tags.id))
        .limit(limit)

    return res
}

export async function getAllDynamicPrompts(limit: number = 10) {
    const res = await db
        .selectDistinct()
        .from(dynamicPrompts)
        .leftJoin(dynamicPromptTags, eq(dynamicPrompts.id, dynamicPromptTags.promptId))
        .leftJoin(tags, eq(dynamicPromptTags.tagId, tags.id))
        .limit(limit)

    return res
}

1 replies

Gaming

Programming