Re: Porting Code to Postgresql

From: "Rick Gigger" <rick(at)alpinenetworking(dot)com>
To: <pgsql-general(at)postgresql(dot)org>, "Errol Neal" <sysadmins(at)enhtech(dot)com>
Subject: Re: Porting Code to Postgresql
Date: 2003-10-15 17:56:40
Message-ID: 004901c39345$b06a5150$0700a8c0@trogdor
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I would guess most likely not. There are a few mysql features that postgres
doesn't have (for example mysql_insert_id) but there are still ways to do
them in postgers. I doubt it will be very hard.

----- Original Message -----
From: "Errol Neal" <sysadmins(at)enhtech(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, October 15, 2003 8:16 AM
Subject: [GENERAL] Porting Code to Postgresql

> Hi all,
>
> Not sure if this is a question for a php list or this one, but I'll give
it
> a shot and
> if I am wrong, please do not crucify me. :-)
>
> There is a php based sourceforge project called mailwatch.
> (http://www.sourceforge.net/projects/mailwatch) It logs data from the
excellent
> Mailscanner security product into a mysql database. Now, I am not a php
> programmer,
> and I am barely a Postgres DBA, but I would really like to port the code
to
> Postgresql.
> I have my trust Postgresql Book which covers the API for Postgresql and
the
> PHP statements
> used for Postgresql seem almost identical to those used for Mysql. I
> understand that there are
> some slight differences in the data types supported by Mysql and
> Postgresql, however are the differences
> between the two Databases and API's that great to make task impossible for
> an unexperienced person
> such as myself? We currently use Postgresql in conjunction with sendmail
to
> store our access, mailertable
> and other db's, so it would be very convenient for us to achieve this.
>
>
> Best Regards,
>
> Errol U. Neal
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mark Harrison 2003-10-15 18:00:10 constant time count(*) ?
Previous Message scott.marlowe 2003-10-15 17:54:49 Re: VACUUM degrades performance significantly. Database