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

Re: postgresql books and convertion utilities

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: Ganbold <ganbold(at)micom(dot)mng(dot)net>, David Fetter <david(at)fetter(dot)org>, Chander Ganesan <chander(at)otg-nc(dot)com>
Subject: Re: postgresql books and convertion utilities
Date: 2006-10-31 04:55:38
Message-ID: 200610302355.38565.xzilla@users.sourceforge.net (view raw or flat)
Thread:
Lists: pgsql-general
On Monday 30 October 2006 20:50, Ganbold wrote:
> >>> 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.
>

If you have made use of a lot of built in mysql functions, make sure to check 
out the mysql compat project:  http://pgfoundry.org/projects/mysqlcompat/

-- 
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

In response to

pgsql-general by date

Next:From: Teodor SigaevDate: 2006-10-31 07:55:00
Subject: Re: Index greater than 8k
Previous:From: Robert TreatDate: 2006-10-31 04:53:13
Subject: Re: postgresql books and convertion utilities

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