Transaction API #137
Replies: 5 comments
-
Hi, I'm fine adding a transaction API, your sketch looks good to me. I have never added transactions because I was thinking savepoints were strictly superior since they allow nesting, but it looks like they don't allow specifying IMMEDIATE or EXCLUSIVE. |
Beta Was this translation helpful? Give feedback.
-
I happen to have a use for Now though I'm concerned about |
Beta Was this translation helpful? Give feedback.
-
After some time and tinkering I feel less sure about I don't have experience with nested transactions so I don't know if there are scenarios where a failed rollback has more impact. Still feel strongly about |
Beta Was this translation helpful? Give feedback.
-
Ugh.. thinking through error conditions hurts my brain. To be fair, it can get complicated. So, if the rollback statement fails with with certain errors the documentation seems to suggest that the transaction can remain open. This could cause similar unwanted database state to commits that didn't actually happen. So... I guess I'm back to wanting to handle the errors.. I think. Apologies for all the noise. |
Beta Was this translation helpful? Give feedback.
-
No worries about the noise. I'm sorry I don't have much input though, right now I don't really have much time or energy to put into this project. |
Beta Was this translation helpful? Give feedback.
-
I'd like to add transaction functionality and ergonomics similar to the savepoint API. Thoughts?
Here's an API sketch:
Beta Was this translation helpful? Give feedback.
All reactions