Sub-transactions about aura.sql HOT 5 CLOSED

You ever look at this? Just wondering.

from aura.sql.

(/me furrows brow) I recall looking at it, and thought I commented on closing it. I recall my comment being along the lines of, "Do the underlying engine support nested transaction natively? Do they permit rolling back to the last sub-transaction?" (I recall having other notes, but not what they were.)

from aura.sql.

Do the underlying engine support nested transaction natively?

They don't, or at least MySQL doesn't - that's sort of the point; it counts the transaction level, so that calls to transact(), during a previous call to transact(), does not lead to early commits. All nested calls to transact() need to succeed (return true) in order for the transaction to commit.

The main point though, is to achieve transaction semantics - as opposed to manually having to check conditions and call commit or rollback, potentially breaking semantics (by forgetting to commit or rollback) or forgetting to manually check inTransaction(), etc... That stuff gets wonky.

I've been doing it this way for a long time, on lots of projects, and it saved me a lot of headache.

from aura.sql.

They don't, or at least MySQL doesn't

(/me nods)

So SAVEPOINT and RELEASE (etc) don't quite do the trick for you? A brief googling revealed support in mysql, sqlite, pgsql, and sql server, though I don't know how recently.

from aura.sql.

AFAIK, in MySql this is supported by INNO only, but yes - you could use
that for sub transactions where available maybe, though that would give it
a very different meaning depending on the database.

I've never personally needed savepoints. I need transactions all the time,
and I don't like the non-transactional API most database APIs provide, so I
usually add in something like this. YMMV.
On Jun 2, 2015 11:19 PM, "Paul M. Jones" [email protected] wrote:

They don't, or at least MySQL doesn't

(/me nods)

So SAVEPOINT and RELEASE (etc) don't quite do the trick for you? A brief
googling revealed support in mysql, sqlite, pgsql, and sql server, though I
don't know how recently.

—
Reply to this email directly or view it on GitHub
#66 (comment).

from aura.sql.