Re: Transactional DataBases

Am 12 Aug 2002 19:09:18 -0500 schrieb William Lovaton <walovaton@yahoo.com.mx>: > Hi, > > I would like to know if there is a way to get advantages from > Transactional DataBases in PEAR (like Oracle). Yes, use their transaction support :-) > I'm not sure if PERA DB can do this but I would like to start the > transaction, executes many queries, then close the transaction. And just > leaving the transactionality problem to the RDBMS. You can do that with PEAR::DB and any supported DBMS that uses transactions. > It's a shame that MySQL doesn't have transactions support... We'll have > to wait until 4.1.x ;-) MySQL has transactions... I wonder why you want to wait until 4.1? Even the 3.x versions have transaction support. You just need to change the table type from ie. MyISAM to innoDB and there you are. Each table type has its own advantages and disadvantages - MyISAM being very fast but without support for transactions. As MyISAM is the default table type used for CREATE TABLE statements if you don´t specify anything else, it´s a common misunderstanding that MySQL has no transaction support. What can I say? Read the docs... in the newest MySQL releases you even have Foreign Key support (full referential integrity) when using innoDB as the table type. Regards, Markus -- *21st Media* | Consulting, Konzeption, Produktion für die Bereiche: Markus Wolff | Internet, Intranet, eCommerce, Content Management, Hamburg,Germany | Softwareentwicklung, 3D-Animation, Videostreaming http://21st.de | Tel. [+49](0)40/6887949-0, Fax: [+49](0)40/6887949-1