Hi,
David Fetter wrote:
On Mon, Oct 30, 2006 at 09:10:36AM -0500, 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)
I highly recommend this book. It's a very thorough coverage of
PostgreSQL - the most complete one out there IMHO. We provide this
book as supplemental material with our PostgreSQL courses, and
before choosing it we examined most of the PostgreSQL books on the
market...this one definitely takes the cake.
I heartily second this recommendation.
As lot of people recommend I will definitely buy first book. Also
will consider second book since it seems like easy to read and follow.
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?
If you wrote your PHP code using one of the abstraction libraries
(PEAR::MDB2, PEAR::DB, PDO, ADODB) then it should be relatively easy
to do the conversion. If you did not, then it could be time
consuming (though not overly difficult).
Getting your data into PostgreSQL will not be difficult.
However, one reason that people convert to PostgreSQL is to scale up.
To do this, you will need to re-design your database to use
PostgreSQL's features, and MySQL's non-standard constructs will make
this harder.
Well, this is true. I have to change my "mysql" mind and
start exploring postgresql capabilities and construct everything.
Right now my mysql app only uses a lot of simple select/insert/delete queries,
so I have to change some of those using features like triggers/views/stored
procedures etc. What I'm thinking is first create db and change every PHP mysql functions
into postgresql. Then step by step will try to improve/change queries.
Thanks a lot for all who answered to my questions.
Ganbold
Cheers,
D