On Fri, May 9, 2014 at 5:08 AM, Andy Bradford <amb-fos...@bradfords.org>wrote:

> Thus said Doug Franklin on Thu, 08 May 2014 23:00:03 -0400:
>
> > Does SQLite support nested transactions? If  so, that would seem to be
> > worth considering.
>
> It does appear to support them:
>
> https://www.sqlite.org/lang_transaction.html


It doesn't directly support them, but fossil/libfossil add a level of
abstraction which simulates them. The notable requirement is that one use
the [lib]fossil C APIs to begin/end transactions, as opposed to using
BEGIN/END directly. Fossil has an assertion in place to catch if COMMIT is
called directly from SQL code while C-initiated transaction is opened.

-- 
----- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
_______________________________________________
fossil-users mailing list
fossil-users@lists.fossil-scm.org
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users

Reply via email to