Ponku Posts - Answer Overflow

Ponku

Explore posts from servers

•Created by Ponku on 8/11/2024 in #help

Best way to select 10 random rows from a table?

Hey, I have a need to select 10 random rows from a table in my postgres db. One option I've been looking at is the tsm_system_rows extension, but I'm not 100% sure what the best way to to install an postgres extension w/drizzle is (the docs say there is no specific way) This the best answer I've gotten so far, but it seems like it might not be the most performant as the table gets larger

db.select({ id: item.id })
  .from(item)
  .where(eq(item.isRandomizable, false))
  .orderBy(sql`RANDOM()`)
  .limit(10);

db.select({ id: item.id })
  .from(item)
  .where(eq(item.isRandomizable, false))
  .orderBy(sql`RANDOM()`)
  .limit(10);

3 replies

Gaming

Programming