Replace Transactions with Atomic Operations?

[Legshot]

I've read about it in the Documentation but I'm not sure how I can replace transactions with locks or atomic operations.

I have an app written in PHP which sometimes needs more stuff than just a query done in one script. To be sure that no corrupted data or incomplete data is saved in the db when a users kills the browser while the script is executing I use transactions (right now with postgresql, but I want to change to mysql.

So how can I do it with atomic ops or locks?

Thanks in advance!

 

[swampBoogie]

Mysql supports transactions. Use Innodb/BDB.

http://www.mysql.com/doc/en/ANSI_diff_Transactions.html

 

[Legshot]

Thanks, but I know about that. The documantation says that atomic operations are faster and as good as transactions so I'm curious on how I would solve my problem without transactions.

Is it even possible?

 

[sleipnir214]

It depends on what you're trying to do. Some things can be performed in atomic operations, some can't.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[Legshot]

I want to be sure that no incomplete updates are done because of a user interrupted PHP script (which does some queries, updates, inserts or whatever which all rely on each other)

With transactions I commit the changes permanent when everything went fine and on the end of a script. Is it possible to do this with atomic ops or not?