Re: Support for MySQL
Hi Nicolai, : Thank you for your suggestions everybody :) MySQL has always been very : limited (no subselect, foreign keys, transaction etc) but I had : positive experiences with it because of it's simplicity. : : Does PostgreSQL support transactions? Last time I used it was back in : 1996, so I'm not up to speed with Stonebraker et Co's baby. : As a matter of fact, it supports subselects, foreign keys, and transactions as well. There's been a -lot- of improvements since 96. Brendan -- Brendan McKennaEmail: [EMAIL PROTECTED] Development Strategist Phone: +353-61-338177 Taringold Ltd. Fax: +353-61-338065
Re: Support for MySQL
BM == Brendan McKenna [EMAIL PROTECTED] writes: BM Hi Nicolai, : Thank you for your suggestions everybody :) MySQL BM has always been very : limited (no subselect, foreign keys, BM transaction etc) but I had : positive experiences with it BM because of it's simplicity. BM : BM : Does PostgreSQL support transactions? Last time I used it was BM back in : 1996, so I'm not up to speed with Stonebraker et Co's BM baby. BM : BM As a matter of fact, it supports subselects, foreign keys, and BM transactions as well. There's been a -lot- of improvements since BM 96. h, interesting. Back then there were no foreign keys only oids and that was painful if you wanted to do some examples from your databases coursework from uni times :) I'll give it a whirl. -- Nicolai P Gubahttp://www.gnu.org http://www.frontwire.com mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] GSM: +44 (0)7909 960 751 DDI: +44 (0)20 7368 9708
Re: Support for MySQL
Yup . . . it sure is. I use it as well as oracle and db2 for cross compliance testing. As far as it being a 'success story', i personally wouldn't use it as a production RDBMS. But that's just MNSHO. peace - scot weber Nicolai P Guba wrote: Hmmm, I've found that PostgreSQL is supported. Has anybody got any success stories with mySQL? (still evaluating). -- Nicolai P Gubahttp://www.gnu.org http://www.frontwire.com mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] GSM: +44 (0)7909 960 751 DDI: +44 (0)20 7368 9708
Re: Support for MySQL
The latest releases (as of 3.23.34a) of MySQL support transactions by using Berkley DB. I'm using MySQL at the moment. The main anoyance I've got is that it doesn't have sub-selects, apart from that, works great. I haven't tried using transactions though as my data is read only. Ray Harrison wrote: Mysql doesn't support transactions (or the last time I checked it didn't) - so it can be limited - but yes, orion interacts with the database just fine. I would suggest another database to try would be SAP DB (www.sapdb.org) which is an open source database delivered by SAP AG - I love it. There is a sap database schema in the orion download. --- Nicolai P Guba [EMAIL PROTECTED] wrote: Hmmm, I've found that PostgreSQL is supported. Has anybody got any success stories with mySQL? (still evaluating). -- Nicolai P Gubahttp://www.gnu.org http://www.frontwire.com mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] GSM: +44 (0)7909 960 751 DDI: +44 (0)20 7368 9708 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/