Richard,
I too use PHP/MYSQL/Apache to run several eComms sites. The bank system
I use requires you send a unique identifier to it before it will do the
transaction, the way i achieve this is to insert a record into the db
with a "passed" flag set to false. When the transaction comes back from
the bank and it passed i change it to true.
Now, from what i understand, if you used prostgres you could prepare a
transaction and therefore "rerserve" an ID number to send to the bank
and if the transactrion passes you could then "commit" the transaction
and actually insert the record into the DB, if it fails you "roll back"
the transaction.
I personally dont think that this system is really needed in the
situation that you and I use it in, i guess the difference is that MySQL
will have records that say "passed=false" where PostGres will have all
passed records but there will be missing ID from the auto_increment
field where a transaction failed then rolled-back but in the mean time
another transaction took the next ID.
This might casue issues with the bank becasue if you send them to ID's
that are the same, even if the previous trans failed it will have a
spew.
HTH
Matt Allen
LinuxWorx.
Richard Hayes wrote:
>
> Dear Sluggers,
>
> I have used Apache/PHP/MySQL on a number of site and this it is great
> but last week I was advised that Postgres has *real transactions* ie it
> can do roll backs etc.
>
> Considering http is a stateless protcol
>
> How can you use the transaction monitor if the middleware does not
> understand transactions?
>
> Is there any advantages?
>
> Any comments / web sites would be appreciated.
> --
> Richard Hayes
> Nada Marketing - 113-115 Oxford St Sydney Australia 2010
> phone: +(61-2) 9360 5555 fax:+(61-2) 9361 0094 mobile 0414 618 425
> http://www.nada.com.au
>
> --
> SLUG - Sydney Linux Users Group Mailing List - http://www.slug.org.au
> To unsubscribe send email to [EMAIL PROTECTED] with
> unsubscribe in the text
--
Matt Allen Linux/PHP eCommerce Solutions
Linux Worx Linux Networking
www.linuxworx.com.au Consulting
[EMAIL PROTECTED]
0413 777 771 "must kill Moe, Weeeeeeeeeeeee !!!"
--
SLUG - Sydney Linux Users Group Mailing List - http://www.slug.org.au
To unsubscribe send email to [EMAIL PROTECTED] with
unsubscribe in the text
