On Tue, 10 Aug 2004 23:34:49 +0200
Jochem van Dieten <jochemd@stripped> wrote:
> On Tue, 10 Aug 2004 16:00:12 -0500, Josh Trutwin wrote:
> > One area where MySQL beat Postgres is in Windows installation.
> > Installing postgres on Windohs is like pulling your fingernails
> > off slowly.
> It is more like following the manual. Not hard, you just have to
> take it one step at a time.
I should point out that I haven't used the compile-from-source method that's in the
documentation, which like you said looks pretty simple. I can get postgres running in a
cygwin env pretty easilly, but getting it to automatically start/stop as a service is
usually the painful part. I've used this as a bonus exercise for students in a dbms
course I teach and their conclusion is the same.
I think this complaint will fall away soon though with PG 8.x. FWIW, PG on *nix is just
the opposite, very clean and simple install.
> > MySQL's command line interface and programming API also are nicer
> > for newer users. Why in the world do I need to remember to type
> > "\d" to show my tables?
> Why in the world do I need to remember SHOW TABLES? Why can't the
> standard information schema work?
Ah, because SHOW TABLES and "exit" or "quit" makes sense and is easy to remember vs. \d \q
\whatever. I like the \d because once you know it it's dang quick to type, but it's nice
to have the longer format as well. Whatever, to each their own...
> Command line interface and programming API are pretty much
> irrelevant if you are using ColdFusion. It is all abstracted out
> behind a JDBC API (ColdFusion is still at JDC 2), which in turn is
> behind ColdFusion's API, so unless you go the way of the Java ninja
> you can't even reach it.
Ok. Command line interface and programming API are never truely irrelevent IMHO. :)
I said it before, I like em both, use em both and have rubs with both of em. Is one
"better" than the other? Yes and No.