[CLUE-Cert] Anyone using/used PostgreSQL?

[Sean LeBlanc]

On Mon, 13 Aug 2001 18:06:41 -0600
Lynn Danielson <lynn.danielson at clue.denver.co.us> wrote:

> Sean LeBlanc wrote:
> > 
> > If so, any gotchas and books/sites that you care to recommend
> > would be very much appreciated.
> 
> There's only one book out on PostgreSQL than I'm aware of.
> It's pale yellow with a blue elephant on its cover.  It 
> seems pretty good.  There's a free version of it on line
> linked as documentation from the PostgreSQL website.  I'm 
> not sure if the book is more complete then the on-line
> documentation or not.  I just can't stand to read much
> on-line.

Well, you're not the only one. :) I can't stand reading
things on line for very long, either.

> A friend helped me configure my work version.  There were
> a couple of tweaks that he strongly recommend, but I can't
> recall what they were anymore.  I'll try to find out before
> our meeting next week.  

Thanks, that'd be great. After discovering that MySQL doesn't
really support the things you'd expect of a modern database, I'd
rather opt for the PostgreSQL...I don't want to bash MySQL
much, since someone on here might like it for their purposes,
but not having foreign key constraints, and the lack of
transactions, is, to me, simply unacceptable...when digging around
to find information about why they didn't implement foreign
key constraints, I found this:

http://openacs.org/philosophy/why-not-mysql.html

It builds a good case of the reasons to avoid MySQL for
mission-critical data. It also lists other features that
MySQL lacks that I wasn't aware of until I read this page.
It also has some reader's responses to his case, which also
makes for an interesting read if you have the time. 

> You might want to post to the CLUE-Tech list.  Grant is 
> very experienced with PostgreSQL and can probably offer
> you some good advice.  I know he'll strongly recommend
> version 7.1 or higher.

Thanks, I just subscribed to it, and after I gather my thoughts
up, I'll post on there.

Cheers, 
Sean


-- 
============================================================
Sean LeBlanc - seanleblanc at bigfoot.com