Re: Porting MySQL PHP to Postgres - Mailing list pgsql-general

From Shaun Clements
Subject Re: Porting MySQL PHP to Postgres
Date
Msg-id 100F78F2B203444BB161BBA7077FF6131CD723@srldbexc003.relyant.co.za
Whole thread Raw
In response to Porting MySQL PHP to Postgres  (Shaun Clements <ShaunC@relyant.co.za>)
Responses Re: Porting MySQL PHP to Postgres  (Matt Kynaston <matt@kynx.org>)
List pgsql-general

Hi Russel

I assumed as much. I was hoping there was a tool available which someone had used and (or) what kind of stumbling blocks to run into.

Thanks again.

Kind Regards,
Shaun Clements

-----Original Message-----
From: Russell Smith [mailto:mr-russ@pws.com.au]
Sent: 21 February 2005 12:38 PM
To: Shaun Clements
Cc: Postgres general mailing list
Subject: Re: [GENERAL] Porting MySQL PHP to Postgres

On Mon, 21 Feb 2005 08:41 pm, you wrote:
> Hi All
>
> I am going to attempt to move an Intranet Application across from MySQL, to
> Postgres.
> I would like to know is there any best method / tool to do this.
> The application is written in PHP. Perhaps there is someone who is using
> Postgres, who had this problem.
>
I can be simple or it can be hard.

It all depends on the complexity, and setup of the PHP scripts.

You may just need to change mysql_query for pg_query, the open and close
function, and it might just mostly work.  However if you app has mysql specific
code, or you are using some complicated classes to manage it, it may be harder to
port.

Unless the application is known, it difficult to give any real analysis on the difficulty of
the task.

Regards

Russell Smith.

> Thanks in advance.
>
> Kind Regards,
> Shaun Clements
>

pgsql-general by date:

Previous
From: Russell Smith
Date:
Subject: Re: Porting MySQL PHP to Postgres
Next
From: Martín Marqués
Date:
Subject: Re: change user password