If you'd like to head up this list, I'm sure people will answer any
questions you might have. Getting the two communities to agree will be
tricky, for example, you would have to break down the features into
minute detail: support subselects in SELECT clause, supports subselects
in FROM clause, supports subselects in WHERE clause.
then theres also the areas where the two project simply disagree... one
area is (something like) supporting 1 -- 1 = 0 i think, which mysql
supports but we dont. (course neither does the spec...)
and finally you need to work out how your going to define supporting
something. In postgresql we have basically two levels of supported
functionality... coded but not released, and released code. in mysql
they have alpha, beta, gamma... maybe more? and they have "plugins" that
might be needed in some functionality (think innodb for transactions,
and let's gloss over whether their implementation is acid compliant)
so just be prepared if your going to do it. also, if you do do it, i'd
like to see a feature comparison against some more interesting
candidates, like oracle or informix
Robert Treat
On Thu, 2003-11-20 at 11:12, Jeff Kowalczyk wrote:
> It would be helpful to both communities if there was a factual
> feature-by-feature grid comparing the relative capabilities of Postgresql
> 7.4 and MySQL 4.x. It would probably be best to limit it to objective
> measures such as "Supports sub-selects in UPDATE queries". Even features
> that are supported by both should be listed, just so the evaluator can
> make it as a known issue. A separate supplemental section offering
> subjective items such as scalability anecdotes would be useful, too.
>
> An associate starting a project expecting to use MySQL asked me about it.
> I had formed my own unscientific impressions that PostgreSQL was more
> appropriate for his app, but I googled in vain for an updated PostgreSQL
> vs. MySQL table as described above. I only found one from 2001, and many
> of the distinctions no longer applied to current versions.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
