Search Postgresql Archives

Re: postgresql books and convertion utilities

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

> >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.

Cheers,
D
-- 
David Fetter <david@xxxxxxxxxx> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux