[sqlalchemy] Re: DB Error handling in SQLAlchemy

2008-05-13 Thread Michael Bayer
On May 13, 2008, at 5:15 PM, Randall Nortman wrote: handling. I'm curious how SA handles this, especially transient errors where a retry is the right thing to do. For example, in several of my current sqlite apps (using bare DB-API), I get occasional locking errors (Database is locked),

[sqlalchemy] Re: DB Error handling in SQLAlchemy

2008-05-13 Thread Michael Bayer
What I forgot to mention in all that, is that SQLA also supports SAVEPOINT very strongly. Using a SAVEPOINT-capable database opens up your choices for being able to flush(), hit an error, and then retry what you were doing, without a rollback of the overarching transaction needed. We