Re: Transactions with DB?
| From: | Jeroen Houben | Date: | Tue, 16 Sep 2003 10:18:22 +0000 |
| Subject: | Re: Transactions with DB? | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-7842@lists.php.net to get a copy of this message | ||
Gerd Terlutter wrote:
Hi all, for a few weeks we decide to change our code and use pear-DB. The reason was independence from a RDBMS. We use MySQL and PGSQL for the same application and it runs fine on both. But now we want to add transactions, and all i know about this is, that MySQL doesn't support Transactions on InnoDB-tables. Must i transform my DB or there are other methods possible? MySql DOES support transactions on InnoDB tables. http://www.mysql.com/products/mysql/index.htmlFull transaction support for InnoDB is available from version 3.23.51 IIRC, but ofcourse you're best of using the latest production 4.x release. It has support for transactions built-in. HTH Jeroen