From: Ben-Nes Michael (miki_at_nonexisting.hamakor.org.il)
Date: Thu 17 Jun 2004 - 14:44:44 IDT
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" <linux-il_at_shemesh.biz>
To: "Ben-Nes Michael" <admin_at_canaan.co.il>
Cc: "IGLU Mailing list" <linux-il_at_cs.huji.ac.il>
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 linux-il-request_at_linux.org.il with
> the word "unsubscribe" in the message body, e.g., run the command
> echo unsubscribe | mail linux-il-request_at_linux.org.il
>
>
=================================================================
To unsubscribe, send mail to linux-il-request_at_linux.org.il with
the word "unsubscribe" in the message body, e.g., run the command
echo unsubscribe | mail linux-il-request_at_linux.org.il
This archive was generated by hypermail 2.1.7 : Thu 17 Jun 2004 - 14:56:56 IDT