The reason for the change is not PHP; it is MySQL. We want some of the advanced functionality
that MySQL will not have until at least version 5 (whatever form it comes in; we keep reading that
some of the version 5 MySQL stuff may be 'basic' (whatever that means)). We need views, triggers,
stored procedures in mature form now.

The reason for the question from me is that we have been hearing that some languages work better
than others with postgres; don't know why, but it could be how tightly coupled it is, how well the
API(?) works with these other languages, etc. In other words, I think I am looking more for any
performance differences that are significant.

-----Original Message-----
From: Oisin Glynn [mailto:me@oisinglynn.com]
Sent: Wed 2/16/2005 7:08 PM
To: Dick Davies; Van Ingen, Lane
Cc: PostgreSQL novices
Subject: Re: [NOVICE] Front End Languages for PostgreSQL



Just curious.

Is the reason for the change based on MySql or PHP or both. We are building
an app on PHP PostgreSQL and I am curious.
We have notr found any issues with PostgreSQL and PHP.

We are using PEAR to abstract the DB from PHP which seems to be worth doing
if we were ever to consider another DB platform.
We have been able to change the underlieing DBMS with no PHP changes other
than connect string used in PEAR though this was only for test purposes.

Oisin
----- Original Message -----
From: "Dick Davies" <rasputnik@hellooperator.net>
To: "Van Ingen, Lane" <lvaningen@ESNCC.com>
Cc: "PostgreSQL novices" <pgsql-novice@postgresql.org>
Sent: Wednesday, February 16, 2005 18:13
Subject: Re: [NOVICE] Front End Languages for PostgreSQL


> * Van Ingen, Lane <lvaningen@ESNCC.com> [0223 20:23]:
> > Does anybody have any solid information that says that one language is
better as a front end to a PostgreSQL
> > database over another, and why ?
> >
> > We are coming out of a PHP / MySQL environment, have adopted PostgreSQL,
and are trying to decide which
> > language would be best to use with PostgreSQL. Since the application has
to be rewritten, we are considering
> > lanuages like PHP and Java. The application is web-based.
>
> Rails is great, if you don't mind learning Ruby.
> Good postgres support too.
>
> --
> 'Good news, everyone! I've taught the toaster to feel love!'
> -- Prof. Farnsworth
> Rasputin :: Jack of All Trades - Master of Nuns
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>





---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend