|Just another Perl shrine|
Nested (sql) transactionsby clueless newbie (Chaplain)
|on Feb 03, 2012 at 22:26 UTC||Need Help??|
clueless newbie has asked for the
wisdom of the Perl Monks concerning the following question:
Nested transactions - thoughts, suggestions and comments requested.
Microsoft's SQL-Server supports nested transactions something that seem "natural" to Perl's notion of modules. Yet many databases do not support nested transactions - MySQL comes to mind. Perhaps the very nature of my being somewhat of a "clueless newbie" incited me to wonder if it's feasible to implement what amounts to nested transactions for those databases that don't support it.
I've been experimenting with "code" that looks like
and implemented transactionalize/using (along the lines of Try::Tiny's try/catch) with
Initial trials give me hope. Much more testing remains.
There are no doubt bugs that remain and enhancements that are needed.
Thoughts, suggestions, comments appreciated.