sqlobject-discuss

Re: [SQLObject] Transaction Implmentation

[deelan <de...@in...>]

Luke Opperman wrote:

 > Hello all -
 >
(...)

 > Well, after finding time, and getting today's CVS, I'm very pleased to
 > announce a test implementation of Python-side Transactions for
 > SQLObject.


somewhat related: new transaction support is working for mysql
too? i've been told that recent mysql versions support
transactions natively, older ones do not. does sqlobject ask
rdbms system for transaction support and act conseguently or mysql trans
support is yet to be written?

BTW, great work. :)

Re: [SQLObject] Transaction Implmentation

[Ian B. <ia...@co...>]

On Tue, 2003-05-13 at 03:00, deelan wrote:
> somewhat related: new transaction support is working for mysql
> too? i've been told that recent mysql versions support
> transactions natively, older ones do not. does sqlobject ask
> rdbms system for transaction support and act conseguently or mysql trans
> support is yet to be written?

The database-level transaction support is pretty thin (and maybe that's
enough... I haven't gotten much feedback on it).  So if your MySQL
database supports transaction (and so does MySQLdb), then SQLObject
should.

That said, my understanding is that MySQL only has transaction support
with a propriety/commercial backend, and I've certainly never seen
anyone using transactions with MySQL in the wild.  IMHO, it's a feature
of MySQL meant to address marketing concerns more than anything, at
least for now.

  Ian