2 replies

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);

Drizzle Team•2y ago•

2 replies

Ponku

Best way to select 10 random rows from a table?

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);

Best way to select 10 random rows from a table?

Similar Threads

Best way to select 10 random rows from a table?

Similar Threads

Similar Threads

Similar Threads