From: | Hannu Krosing <hannu(at)tm(dot)ee> |
---|---|
To: | Mark Woodward <pgsql(at)mohawksoft(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org, John DeSoi <desoi(at)pgedit(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: [OT] MySQL is bad, but THIS bad? |
Date: | 2006-05-19 20:47:11 |
Message-ID: | 1148071631.3833.33.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-hackers |
Ühel kenal päeval, R, 2006-05-19 kell 11:29, kirjutas Mark Woodward:
> > Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
> >> Mark Woodward wrote:
> >>> Again, there is so much code for MySQL, a MySQL emulation layer, MEL
> >>> for
> >>> short, could allow plug and play compatibility for open source, and
> >>> closed
> >>> source, applications that otherwise would force a PostgreSQL user to
> >>> hold
> >>> his or her nose and use MySQL.
> >>>
> >> If we had infinite resources this might make sense. We don't, so it
> >> doesn't. There is a real cost to producing a compatibility layer, and
> >> the cost will be those spiffy new features.
> >
> > The real problem is that there's a whole lot of stuff, such as mysql's
> > weak error checking, that I don't think a "compatibility layer" could
> > sanely provide.
> >
> I kind of agree with this statement, but while I was playing devils's
> advocate and just grousing a bit about having to use MySQL, there is a
> sort of reality of "openomics" where mind-share is everything.
Maybe we could have a Google SoC project to strip Postgres of all its
useful features (mainly ACID, but also introduce NULL==""==0 and weak
foreign keys) to make it MySQL compatible.
And if we start locking a table on each update, we can get rid of MVCC
altogether and do fast selects, in-place updates and select from indexes
only.
Then that branch (PostgreSQLite) could be pimped to MySQL users as a way
to "support" postgres.
Nah, not really useful, but perhaps we could publicize the list of
things that would have to go to be compatible :P
----------------
Hannu
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2006-05-19 20:53:12 | Re: [OT] MySQL is bad, but THIS bad? |
Previous Message | Bruce Momjian | 2006-05-19 20:41:20 | Re: [OT] MySQL is bad, but THIS bad? |
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Dilger | 2006-05-19 20:52:53 | Re: String Similarity |
Previous Message | Bruce Momjian | 2006-05-19 20:41:20 | Re: [OT] MySQL is bad, but THIS bad? |