Is there a way to use transactions without pgx?

[mrkaspa]

I have a project with bun sql and I would like to insert a job as part of a transaction, but I can only use pgx.Tx transactions. Also I can use sql.Tx but the driver does not support this

[brandur]

Not currently — I have a branch where this almost works, but it's going to take a little more work still. I think I'll get this sooner than later.

[mrkaspa]

@brandur great to hear that, hope to use that feature soon

[hypnoglow]

We also use bun and would love to see support for bun.Tx and/or sql.Tx. Otherwise it seems impossible to integrate with existing transactions.

[brandur]

Okay, good to know. Going to try and get to this pretty soon.

[mrkaspa]

I think with bun you can use the sql.Tx transactions since bun.Tx is a wrapper for sql.Tx, btw I am using bun as well

[brandur]

Hey guys, could you tell me what underlying driver you're using to power database/sql in general? Do you use lib/pq or is it database/sql + Pgx, or something else like Bun's Postgres driver?

[hypnoglow]

Hey @brandur

Currently, we consider only pgx to be a viable driver. We switch old apps from lib/pq. And bun native driver has some problems that we don't have using pgx.

[brandur]

Excellent, that's helpful. Thanks Igor.

[dhermes]

Chiming in here! We are currently using database/sql with github.com/jackc/pgx/v5/stdlib as the actual driver.

[brandur]

Opened #351. We'll need some additional docs, but it make use of River with Bun possible.