Skip site navigation (1) Skip section navigation (2)

Re: postgresql book - practical or something newer?

From: Tom Hart <tomhart(at)coopfed(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: vincent <vinny(at)xs4all(dot)nl>, pgsql-general(at)postgresql(dot)org
Subject: Re: postgresql book - practical or something newer?
Date: 2008-01-30 18:20:58
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
Tom Lane wrote:
> "vincent" <vinny(at)xs4all(dot)nl> writes:
>> In the manual yes, but I think there's definately a need for a howto
>> document, something that demonstrates how to handle typical database
>> functionality in PgSQL. Many of the people I've convinced to start using
>> PostgeSQL spend the first week or so asking me questions on how to do
>> basic things in PostgreSQL. When I say that there's a manual, the
>> complaint usually is what I've noticed myself: the manual is great for
>> looking up individual facts, but your problem may consist of 15 facts and
>> it's up to you to connect the dots.
> Surely even a book that's a little out-of-date can serve fine for that
> kind of introduction?
> 			regards, tom lane
I agree that it would be useful as an introduction, but I have 4 years 
of mySQL experience (I know, I'm sorry) and I've been working with 
postgres for the past 3-4 months during which time I've built a data 
mine by hand, and set up a few different web apps running against it 
(drupal, openreports, etc.) so I think I'm past the introduction phase. 
What I was looking for was an intermediate level (call me presumptuous) 
book with more performance tips and advanced techniques/functions. Even 
though this book may have some sort of this information in it, it's 
going to be based on 7.x and the entire thing is available online (as 
well as the docs, which personally I like).

And on the subject of beginner's documentation, I think I learned a lot 
more playing/hacking/reading docs/posting here (of course that's always 
been my preferred learning method) then I would have with a book. 
Everybody has their own learning style and different things work well 
for different people. The key here is that when it's up to you to 
"connect the dots" then you learn what the dots are, how they relate to 
each other, and what each of them is for. That gives you a lot better 
understanding then "Just run SELECT count(*) FROM a LEFT JOIN...".

Of course that's just my opinion, I could be wrong :-)

Tom Hart
IT Specialist
Cooperative Federal
723 Westcott St.
Syracuse, NY 13210
(315) 471-1116 ext. 202
(315) 476-0567 (fax)

In response to


pgsql-general by date

Next:From: Joshua D. DrakeDate: 2008-01-30 18:31:20
Subject: Re: postgresql book - practical or something newer?
Previous:From: Tom LaneDate: 2008-01-30 18:09:27
Subject: Re: postgresql book - practical or something newer?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group