RE: [PEAR] Transactions with DB?

> From: Markus Wolff [mailto:wolff@21st.de] > Sent: Tuesday, September 16, 2003 12:32 PM > 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? > > It's the other way round: MySQL supports transactions *only* with > InnoDB tables, so if your tables are not of the type InnoDB, you need > to convert them. This can be painlessly done with a simple ALTER TABLE > statement. > > If you use InnoDB, you can also use Foreign Keys with MySQL. Actually MySQL has had transaction support for quite sometime using the Berkely DB database handler. Aside from BDB and InnoDB there is also Gemini, but since Nusphere and Mysql AB went head to head I think Gemini will not see much attention. Regards, Lukas