as a follow up to my previous answer. When i build web sites ( for example www.bazz.co.il ) i need to code much less when working with PG becouse i have transaction and foreigen keys.
MySQL state ( at least 2 years ago ) that you dont need transaction becouse you can always cancel your inserts by initiatin deletes. all true if the code is perfect, if not some will not be deleted, and youll loose the DB integrity. in PG you just write: "rollback" and all you did since the "begin" will droped. -------------------------- Canaan Surfing Ltd. Internet Service Providers Ben-Nes Michael - Manager Tel: 972-4-6991122 Fax: 972-4-6990098 http://www.canaan.net.il -------------------------- ----- Original Message ----- From: "Shachar Shemesh" <[EMAIL PROTECTED]> To: "Ben-Nes Michael" <[EMAIL PROTECTED]> Cc: "IGLU Mailing list" <[EMAIL PROTECTED]> Sent: Thursday, June 17, 2004 1:57 PM Subject: Re: quick MySQL howto, anyone? > Ben-Nes Michael wrote: > > >Dont do my mistake, start with postgresql if you can. > > > >MySQL is a bad DB unless you need one table Web Site. > > > > > Hi Michael, > > Just so you don't feel as if I'm attacking, I'll mention that I didn't > do your mistake to begin with, and started with PostgreSQL (which is the > only database I have thus far seriously worked with). I wrote the OLE DB > provider for it (for Lingnu), and we did several software migrations for > clients to it (from MS-SQL and Oracle). This included extending the > datatype system for it to accommodate types available in MS-SQL and not > in Postgres. The reason we chose PostgreSQL over MySQL are probably the > same you can list. > > Still, though I do believe Postgres to be a better long run decision for > any non-trivial free database system, I did not know MySQL to break in > such an immediate way as you imply in your mail (anecdotes, no personal > experience). I would LOVE to hear from your experience on why you regret > ever going the MySQL path. > > Shachar > > -- > Shachar Shemesh > Lingnu Open Source Consulting ltd. > http://www.lingnu.com/ > > > ================================================================= > To unsubscribe, send mail to [EMAIL PROTECTED] with > the word "unsubscribe" in the message body, e.g., run the command > echo unsubscribe | mail [EMAIL PROTECTED] > > ================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
