perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tom Schindl <tomatli...@gmx.at>
Subject Re: Database transaction across multiple web requests
Date Fri, 31 Mar 2006 18:07:50 GMT
Jonathan Vanasco wrote:
> Just to add to what other have written-
> 
> if you're writing to anything based on this, you'll need some sort of 
> internal marker to tell if your data has been changed (i don't think 
> you're writing, but you should just be aware of this)

That's why we database vendors have create isolation levels ;-)
depending on what you need you have to use the appropriate. I think
PostgreSQL supports all of them but I personally use MySQL so I might be
wrong.

> 
> often i do one of two things:
>     a- have a 'checkout' table in the db, and have a block for x
> minutes  on similar operations (simple, but messy).  only a var in the
> session  can get the checkout code from the db.
>     b- tie in a record version or some other logic to see if your data 
> set has been changed by someone else since you started your mutli- page
> transaction
> 
> 
> 
> 


Mime
View raw message