db.batch is missing

Hello, so i am trying to send 2 db queries at once to reduce latency by reducing round trips to from the server to the db and for some reason the batch property is missing.

I am using the latest version of drizzle as seen in my package.json.

I have tried restarting my ts server and restarting my vscode but no luck.

I am trying to follow the docs online but have no clue what else to try. Any help would be greatly appreciated, thankyou.

Andrii Sherman•12/18/23, 10:14 AM

what driver are you using?

GeorgeOP•12/20/23, 12:52 AM

@Andrew Sherman I am using the pg driver:

GeorgeOP•12/20/23, 12:53 AM

Andrii Sherman•12/21/23, 4:36 PM

good, as docs mention: https://orm.drizzle.team/docs/batch-api

Drizzle ORM - next gen TypeScript ORM

Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.

Andrii Sherman•12/21/23, 4:36 PM

you can use batch only for libsql and d1

Andrii Sherman•12/21/23, 4:36 PM

which are both sqlite over http

Andrii Sherman•12/21/23, 4:37 PM

Postgres doesn't have batch api itself. But you can use Promise.all if you want to run queries in parallel

GeorgeOP•12/22/23, 2:12 AM

Ohhh ok fair enough. Will this feature eventually be available for postgres. Also are there any differences / downsides for using Promise.all over db.batch. Sorry if this is a noobish question.

db.batch is missing

Similar Threads

Similar Threads

Similar Threads