Re: postgresql books and convertion utilities

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
>