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