Drizzle Team•12mo ago

Is this the proper way to do a count query?

rowsCount: (
  await db
    .select({ value: countDistinct(inventoryItems.id) })
    .from(inventoryItems)
    .where(whereFilter)
)[0].value

rowsCount: (
  await db
    .select({ value: countDistinct(inventoryItems.id) })
    .from(inventoryItems)
    .where(whereFilter)
)[0].value

seems kinda weird to index 0 like that

5 Replies

Angelelz•12mo ago

Why do you need a countDistinct?

jakeleventhalOP•12mo ago

wouldnt count distinct be what you want in most cases?

Angelelz•12mo ago

Not if you're counting unique ids It's adding overhead for nothing Anyway, that looks good to me You could use .then() which would be basically the same thing Also, if it's a unique id, you can just do count() because every row will have an id

jakeleventhalOP•12mo ago

does count() implicitly take in the primary key as the arg

Angelelz•12mo ago

count() returns count(*) on the database And that counts every row performantly

Gaming

Programming

Is this the proper way to do a count query?