From: | Stephen Frost <sfrost(at)snowman(dot)net> |
---|---|
To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
Cc: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>, John DeSoi <desoi(at)pgedit(dot)com>, Mark Woodward <pgsql(at)mohawksoft(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [OT] MySQL is bad, but THIS bad? |
Date: | 2006-05-18 17:51:05 |
Message-ID: | 20060518175104.GT7774@kenobi.snowman.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-hackers |
* Joshua D. Drake (jd(at)commandprompt(dot)com) wrote:
> And to be frank, I don't think we should waste our time on MySQL. It
> isn't a competitor, it just thinks it is. We should focus on our real
> competition which is DB2, MSSQL, and Oracle.
One thing which would be kind of nice would be to have a mapping for the
common commands. A friend of mine did this with a bit of perl so he
could have a single SQL script that could run against both Postgres and
Oracle. His thought was actually just an aliasing ability in psql so
that you could, for example, alias 'desc' to '\d' and '@' to '\i'. This
would have also helped me out with some projects for school- the main
issues I ran into were that Oracle required a cascade-drop to include
the keyword 'constraints' (which Postgres correctly forbids) and that
Oracle uses 'MINUS' instead of 'EXCEPT' (where 'EXCEPT' is the SQL
standard, which Oracle doesn't accept for some reason. :/).
Just some thoughts,
Stephen
From | Date | Subject | |
---|---|---|---|
Next Message | Marc G. Fournier | 2006-05-18 17:56:12 | Re: [OT] MySQL is bad, but THIS bad? |
Previous Message | Josh Berkus | 2006-05-18 17:43:14 | BOF for OSCON? |
From | Date | Subject | |
---|---|---|---|
Next Message | Marc G. Fournier | 2006-05-18 17:56:12 | Re: [OT] MySQL is bad, but THIS bad? |
Previous Message | Bruce Momjian | 2006-05-18 17:50:06 | Re: Compression and on-disk sorting |