Vercel Postgres, no transactions?
New Courses Coming Soon
Join the waiting lists
I had problems using Kysely on Vercel Postgres, with the @vercel/postgres
and @vercel/postgres-kysely
adapters.
Basically, transactions are not supported.
I had some code like this:
const data = await db.transaction().execute(async (trx) => {
const somedata = await trx
.selectFrom('table1')
.selectAll()
.where('id', '=', token)
.executeTakeFirst()
if (!somedata) throw new Error('Invalid data')
await trx
.deleteFrom('table2')
.where('id', '=', token)
.executeTakeFirst()
return somedata
})
console.log(data)
and I had to remove the transaction, I just used the queries without the transaction:
const data = await db.selectFrom('table1')
.selectAll()
.where('id', '=', token)
.executeTakeFirst()
if (!data) throw new Error('Invalid data')
await db.deleteFrom('table2')
.where('id', '=', token)
.executeTakeFirst()
console.log(data)
Hopefully transactions will be implemented.
If you absolutely need them you can still use a direct connection to the database using pg
→ Read my SQL Tutorial on
The Valley of Code
Here is how can I help you:
- COURSES where I teach everything I know
- CODING BOOTCAMP cohort course - next edition in 2025
- BOOKS 16 coding ebooks you can download for free on JS Python C PHP and lots more
- Follow me on X