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
