Kysely•14mo ago

Can you mix kysely with pg transactions?

For example:

try {
  await client.query('BEGIN')
   
  <KYSELY CODE HERE>

  await client.query('COMMIT')
} catch (e) {
  await client.query('ROLLBACK')
  throw e
} finally {
  client.release()
}

try {
  await client.query('BEGIN')
   
  <KYSELY CODE HERE>

  await client.query('COMMIT')
} catch (e) {
  await client.query('ROLLBACK')
  throw e
} finally {
  client.release()
}

3 Replies

koskimas•14mo ago

You can use Kysely only to build the SQL and then exceute that any way you like.

koskimas•14mo ago

https://kysely.dev/docs/recipes/splitting-build-compile-and-execute-code

Splitting build, compile and execute code | Kysely

Kysely is primarily a type-safe sql query builder.

Unknown User•4mo ago

Message Not Public

Gaming

Programming

Can you mix kysely with pg transactions?

Did you find this page helpful?