Re: [GENERAL] Need concrete "Why Postgres not MySQL"

From: Hornyak Laszlo <kocka(at)tigrasoft(dot)hu>
To: Jan Wieck <JanWieck(at)Yahoo(dot)com>
Cc: pgsql-advocacy(at)postgresql(dot)org
Subject: Re: [GENERAL] Need concrete "Why Postgres not MySQL"
Date: 2003-08-23 10:57:36
Message-ID: Pine.LNX.4.21.0308231220120.22590-100000@tiger.tigrasoft.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-general pgsql-hackers

<off>
Yep, I know, but that is not a reason. :)
</off>

Laci

On Fri, 22 Aug 2003, Jan Wieck wrote:

> Hornyak Laszlo wrote:
>
> > Hi all!
> >
> > Can someone explain me why is it usefull if the table created in
> > transaction disapears on rollback?
> > Anyway the progress db supports it, at least the version 9.
> > The other question: why is mysql enemy? Isn`t it just another RDBMS?
>
> Go to http://www.mysql.com, type "postgresql" into the search field (top
> right corner) and read through some of the links. Especially stuff like
> the subsections of
>
> http://www.mysql.com/doc/en/Compare_PostgreSQL.html
>
> Then go to http://www.postgresql.org and try to find similar FUD. You
> will rather find something like this:
>
> http://developer.postgresql.org/~petere/comparison.html
>
> This exercise will tell you who considers whom "enemy" and why some of
> us just "dislike" MySQL and their understanding of "fair".
>
>
> Jan
>
> >
> > Thanks,
> > Laszlo
> >
> > On Thu, 21 Aug 2003, Ian Barwick wrote:
> >
> >> On Thursday 21 August 2003 11:15, Shridhar Daithankar wrote:
> >> > On 21 Aug 2003 at 0:22, Ian Barwick wrote:
> >> > > * DDL
> >> > > - Data definition language (table creation statements etc.) in MySQL
> >> > > are not transaction based and cannot be rolled back.
> >> >
> >> > Just wondering, what other databases has transactable DDLs? oracle seems to
> >> > have autonomous transactions which is arthogonal.
> >>
> >> DB2 8.1 seems to support transaction-capable DDL. At least, a rollback
> >> following a CREATE TABLE causes the table to disappear. Haven't gone
> >> into it in any depth.
> >>
> >>
> >> Ian Barwick
> >> barwick(at)gmx(dot)net
> >>
> >>
> >>
> >>
> >> ---------------------------(end of broadcast)---------------------------
> >> TIP 2: you can get off all lists at once with the unregister command
> >> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
> >>
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>
> --
> #======================================================================#
> # It's easier to get forgiveness for being wrong than for being right. #
> # Let's break this rule - forgive me. #
> #================================================== JanWieck(at)Yahoo(dot)com #
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message Jeff 2003-08-23 13:31:27 Re: Single-file DBs WAS: Need concrete "Why Postgres
Previous Message Andrew Dunstan 2003-08-23 10:33:35 Re: Single-file DBs WAS: Need concrete 'Why Postgres

Browse pgsql-general by date

  From Date Subject
Next Message Jeff 2003-08-23 13:31:27 Re: Single-file DBs WAS: Need concrete "Why Postgres
Previous Message Andrew Dunstan 2003-08-23 10:33:35 Re: Single-file DBs WAS: Need concrete 'Why Postgres

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff 2003-08-23 13:31:27 Re: Single-file DBs WAS: Need concrete "Why Postgres
Previous Message Andrew Dunstan 2003-08-23 10:33:35 Re: Single-file DBs WAS: Need concrete 'Why Postgres