How do you use batch API with local development

If you use Neon, but do local development using postgres-js in docker, how can you write code that uses batch API? it seems like there should be some sort of shim that runs batches as a transaction under the hood to allow the same drizzle code to run for drivers that don't support batches.

Dan•3/20/24, 1:06 PM

not at the moment, batch is not implemented in all drivers

jakeleventhalOP•3/20/24, 3:26 PM

for postgres-js for instance, wouldnt batch implementation just be something like this:

// user code:
await db.batch(statements satisfies Array<SQL>);

// under the hood code:
await db.execute(sql`
  BEGIN TRANSACTION
  ${statements.join(';\n')}
  COMMIT TRANSACTION
`);

// user code:
await db.batch(statements satisfies Array<SQL>);

// under the hood code:
await db.execute(sql`
  BEGIN TRANSACTION
  ${statements.join(';\n')}
  COMMIT TRANSACTION
`);

How do you use batch API with local development

Similar Threads

Similar Threads

Similar Threads