TTC
Theo's Typesafe Cult•12mo ago
Liam

Counting rows in Drizzle ORM

Hi, I was wondering what the best way to count rows in drizzle is. Thanks for the help!
Solution:
```ts import { sql } from 'drizzle-orm' import { YOUR_TABLE } from 'schema' const { count } = await db.select({...
Jump to solution
3 Replies
Neto
Neto•12mo ago
Solution
Neto
Neto•12mo ago
import { sql } from 'drizzle-orm'
import { __YOUR_TABLE__ } from 'schema'
 
const { count } = await db.select({
    count: sql<number>`count(*)`.mapWith(Number) 
}).from(__YOUR_TABLE__)
import { sql } from 'drizzle-orm'
import { __YOUR_TABLE__ } from 'schema'
 
const { count } = await db.select({
    count: sql<number>`count(*)`.mapWith(Number) 
}).from(__YOUR_TABLE__)
Liam
Liam•12mo ago
Thanks! That seems to be working.
Want results from more Discord servers?
Add your server
More Posts
Does App Router have getStaticPaths? Does it even need that?Hello everybody! 👋 I hope you are well! So I'm looking into App Router. I just recently followed Pull template repositoryI would like to know if it is possible to use a template repository and after the template repo receTypeError: client[procedureType] is not a function weirdnessI'm trying to make an adapter for auth.js and want to call my backend via the adapter with tRPC proxInvalid env variables NextjsHi guys ! It's certainly very dumb but I don't figure it out. I have set everything correctly from wWeird type errors with next.js and drizzle```ts //when I use export const dynamicParams = false; //or export const dynamicParams = true; ``` NMemoize function in typescriptI want to memoize a pure function in ts that's just a static export without class. Typescript-memoizClerk: Is it possible to create custom metadata on signup using Clerk?I need to create a custom metadata "credits" on each new user object, is it possible to achieve thatbest react video playerWhat is your favorite react video player? And why?ct3a update/diff tool URL?I remember someone made a tool where you put in your init version of ct3a and a target version and iHow to properly setup next auth for a discord dashboardContext: - I am setting up a dashboard for a discord bot and I'm using next auth to setup discord oa