I was new to postgresql and have had to use it with both C and PHP.
Having purchased both books, I have found #2 in your list a lot more
useful than #1 (don't let the "beginning" title fool you into
thinking it's just a 'hello world' book). #2 is better organized for
what I'm doing, especially the index. While #1 definitely goes far
more in depth on obscure things, #2 has a much better index. And for
me, a reference book is only as good as its index; if I have thumb
through every page in the book to find something, it's nearly useless
as a reference.
But that's just my opinion and others might vary.
--
Ilan Volow
Implicit code is inherently evil, and here's the reason why:
On Oct 30, 2006, at 9:10 AM, Chander Ganesan wrote:
Ganbold wrote:
Hi,
I'm new to postgresql and I'm looking for references and books. We
are usually coding in php/C.
Can somebody recommend me good books which covers Postgresql 8.x?
Which one is worth from following books?
1. PostgreSQL (2nd Edition) by Korry Douglas (Paperback - Jul 26,
2005)
2. Beginning Databases with PostgreSQL: From Novice to
Professional, Second Edition (Beginning from Novice to
Professional) by Neil Matthew and Richard Stones (Paperback -
April 6, 2005)
3. Beginning PHP and PostgreSQL 8: From Novice to Professional by
W. Jason Gilmore and Robert H. Treat (Paperback - Feb 27, 2006)
4. Beginning PHP and PostgreSQL E-Commerce: From Novice to
Professional (Beginning, from Novice to Professional) by Emilian
Balanescu, Mihai Bucica, and Cristian Darie (Paperback - Dec 25,
2006)
5. Beginning PostgreSQL 8 by Edward Lecky-Thompson and Clive
Gardner (Paperback - Sep 25, 2006)
I'm thinking to buy books published in 2006, but maybe I'm wrong.
I appreciate if somebody can point me to the right direction.
Also I'm thinking to convert our mysql db and application to
postgresql.
Is there any method to convert mysql db/app to postgresql, maybe
at least DB (tables, indexes, queries)?
Are there any tools that can convert php functions and database
from mysql to postgresql?
thanks in advance,
Ganbold
---------------------------(end of
broadcast)---------------------------
TIP 6: explain analyze is your friend