Thread: Fw: Redhat 7 and PgSQL
I know you had to add the module for mysql for PHP 3, but I thought PHP 4 mysql was a native part. I compiled php 4 ad specifically asked for postgres support, while compiling, it mentioned how mysql APIs were being added any way (even though I did not tell it to). I'm sure it can be extracted, but it looks like the modules are a lot tighter together. So, in the php 4 RPM, you still need to add myql explicitly? Adam Lang Systems Engineer Rutgers Casualty Insurance Company > ----- Original Message ----- > From: "Trond Eivind Glomsrød" <teg@redhat.com> > To: "Adam Lang" <aalang@rutgersinsurance.com> > Cc: <pgsql-general@postgresql.org> > Sent: Friday, September 29, 2000 10:53 AM > Subject: Re: [GENERAL] Redhat 7 and PgSQL > > > > "Adam Lang" <aalang@rutgersinsurance.com> writes: > > > > > Not to mention the fact that PHP 4 installs with MySQL support native. > > > > While we have a MySQL module for PHP, we also have a pgsql module. > > > > > If RedHat did do MySQL by default, technically Apache, PHP, and MySQL > would > > > be a pretty straightforward Web Serving bundle. > > > > So is Postgresql, PHP and Apache - no MySQL necesarry. > > > > -- > > Trond Eivind Glomsrød > > Red Hat, Inc. >
On Fri, 29 Sep 2000, Adam Lang wrote:
> I know you had to add the module for mysql for PHP 3, but I thought PHP 4
> mysql was a native part.
>
> I compiled php 4 ad specifically asked for postgres support, while
> compiling, it mentioned how mysql APIs were being added any way (even
> though
> I did not tell it to).
PHP 4.0 and up compile with MySQL support enabled by default - you have to
specify --without-mysql when you run ./configure.
I won't comment on the whole PHP being in bed with MySQL issue...
--
Dominic J. Eidson
"Baruk Khazad! Khazad ai-menu!" - Gimli
-------------------------------------------------------------------------------
http://www.the-infinite.org/ http://www.the-infinite.org/~dominic/
that's mighty f***** up. I thought the point of compiling the code was that features would not be added unless you TOLD it to? I also heard that mysql is looking to use PHP as its interface language... Not too suprised... 80% of the PHP example code I ever find is involving mysql anyway... Well damnit! I'm not succumbing to bundling! I'm sticking to postgres! :) (As I type this on Win98 using Outlook Express.) Adam Lang Systems Engineer Rutgers Casualty Insurance Company ----- Original Message ----- From: "Dominic J. Eidson" <sauron@the-infinite.org> To: <pgsql-general@postgresql.org>; <aalang@rutgersinsurance.com> Sent: Friday, September 29, 2000 1:24 PM Subject: Re: Fw: [GENERAL] Redhat 7 and PgSQL > On Fri, 29 Sep 2000, Adam Lang wrote: > > > I know you had to add the module for mysql for PHP 3, but I thought PHP 4 > > mysql was a native part. > > > > I compiled php 4 ad specifically asked for postgres support, while > > compiling, it mentioned how mysql APIs were being added any way (even > > though > > I did not tell it to). > > PHP 4.0 and up compile with MySQL support enabled by default - you have to > specify --without-mysql when you run ./configure. > > I won't comment on the whole PHP being in bed with MySQL issue... > > > -- > Dominic J. Eidson > "Baruk Khazad! Khazad ai-menu!" - Gimli > -------------------------------------------------------------------------- ----- > http://www.the-infinite.org/ http://www.the-infinite.org/~dominic/
Yes, it seems that most people think PHP and MySQL were meant for each other (in fact the developers of both have an alliance of sorts) -- PostgreSQL support in PHP is very good though, I use PHP for %95 of the web applications I develop and I have never used MySQL ( I value the data too much to risk it).. The PostgreSQL module for PHP is without a dedicated maintainer though, which could be a problem in the future -- Sascha Schumann is maintaining it now I believe (he's one of the main PHP developers).. Someone from my company has been considering taking it over in order to keep it current as there are some functions not included in the module that could be there.. (As I type this in Windows 2000, Outlook Express!) -Mitch ----- Original Message ----- From: "Adam Lang" <aalang@rutgersinsurance.com> To: "Dominic J. Eidson" <sauron@the-infinite.org>; <pgsql-general@postgresql.org> Sent: Friday, September 29, 2000 10:34 AM Subject: Re: Fw: [GENERAL] Redhat 7 and PgSQL > that's mighty f***** up. I thought the point of compiling the code was that > features would not be added unless you TOLD it to? > > I also heard that mysql is looking to use PHP as its interface language... > > Not too suprised... 80% of the PHP example code I ever find is involving > mysql anyway... > > Well damnit! I'm not succumbing to bundling! I'm sticking to postgres! :) > > (As I type this on Win98 using Outlook Express.) > > Adam Lang > Systems Engineer > Rutgers Casualty Insurance Company > ----- Original Message ----- > From: "Dominic J. Eidson" <sauron@the-infinite.org> > To: <pgsql-general@postgresql.org>; <aalang@rutgersinsurance.com> > Sent: Friday, September 29, 2000 1:24 PM > Subject: Re: Fw: [GENERAL] Redhat 7 and PgSQL > > > > On Fri, 29 Sep 2000, Adam Lang wrote: > > > > > I know you had to add the module for mysql for PHP 3, but I thought PHP > 4 > > > mysql was a native part. > > > > > > I compiled php 4 ad specifically asked for postgres support, while > > > compiling, it mentioned how mysql APIs were being added any way (even > > > though > > > I did not tell it to). > > > > PHP 4.0 and up compile with MySQL support enabled by default - you have to > > specify --without-mysql when you run ./configure. > > > > I won't comment on the whole PHP being in bed with MySQL issue... > > > > > > -- > > Dominic J. Eidson > > "Baruk Khazad! Khazad ai-menu!" - > Gimli > > -------------------------------------------------------------------------- > ----- > > http://www.the-infinite.org/ > http://www.the-infinite.org/~dominic/ > >
On Fri, 29 Sep 2000, Adam Lang wrote:
> that's mighty f***** up. I thought the point of compiling the code was that
> features would not be added unless you TOLD it to?
Complain to Rasmus - not that it'll get you anywhere... *grumble*
> I also heard that mysql is looking to use PHP as its interface language...
No, MySQL is looking into using the Zend scripting engine for their stored
procedures - another move that undermines their viabillity as DB in my
eyes. MySQL is becoming this big (unmanageable) patchwork of third party
software... I hope/predict it will die soon.
> (As I type this on Win98 using Outlook Express.)
[dominic@postgres dominic]$ uname -a
Linux postgres 2.2.14-6.1.1smp #1 SMP Thu Apr 13 19:55:55 EDT 2000 i686 unknown
Yes, the server name _is_ "postgres" :)
--
Dominic J. Eidson
"Baruk Khazad! Khazad ai-menu!" - Gimli
-------------------------------------------------------------------------------
http://www.the-infinite.org/ http://www.the-infinite.org/~dominic/
On Fri, 29 Sep 2000, Mitch Vincent wrote: > Yes, it seems that most people think PHP and MySQL were meant for each other > (in fact the developers of both have an alliance of sorts) -- PostgreSQL > support in PHP is very good though, I use PHP for %95 of the web > applications I develop and I have never used MySQL ( I value the data too > much to risk it).. I do all my web applications with PHP, and use only Postgres and Informix. > The PostgreSQL module for PHP is without a dedicated maintainer though, > which could be a problem in the future -- Sascha Schumann is maintaining it > now I believe (he's one of the main PHP developers).. Someone from my > company has been considering taking it over in order to keep it current as > there are some functions not included in the module that could be there.. I have found lots of things that the mysql anf the informix module for php has, that the postgres doesn't. Especifically, when you walk through a query. In postgres you have to tell the function which row you want. In Informix, you can use the "NEXT" option so it walks through the rows. > (As I type this in Windows 2000, Outlook Express!) I'm using pine on Linux RedHat 6.0 (with some upgrades). "And I'm happy, because you make me feel good, about me." - Melvin Udall ----------------------------------------------------------------- Martín Marqués email: martin@math.unl.edu.ar Santa Fe - Argentina http://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -----------------------------------------------------------------
MySQL was not installed on my server. I compiled php4 --with-pgsql andthat was it (besides what was necessary for Apache). It compiled it with MySQL support anyway. Adam Lang Systems Engineer Rutgers Casualty Insurance Company ----- Original Message ----- From: "Martin A. Marques" <martin@math.unl.edu.ar> To: "Adam Lang" <aalang@rutgersinsurance.com> Cc: "PGSQL General" <pgsql-general@postgresql.org> Sent: Friday, September 29, 2000 4:27 PM Subject: Re: Fw: [GENERAL] Redhat 7 and PgSQL > On Fri, 29 Sep 2000, Adam Lang wrote: > > > I know you had to add the module for mysql for PHP 3, but I thought PHP 4 > > mysql was a native part. > > > > I compiled php 4 ad specifically asked for postgres support, while > > compiling, it mentioned how mysql APIs were being added any way (even > > though > > I did not tell it to). > > I'm not sure about what you're trying to say, but the configure script > trys to look for all the support it can find. If it finds mysql > installed, it adds support for mysql, just like it would add support for > postgres, informix, oracle, etc. if it would have found the distribution > of that application. > > > I'm sure it can be extracted, but it looks like the modules are a lot > > tighter together. > > > > So, in the php 4 RPM, you still need to add myql explicitly? > > I haven't installed rpms of php4, just compiled the tar-balls, but I > guess that yes, you would need to install the php-mysql module after. > > > "And I'm happy, because you make me feel good, about me." - Melvin Udall > ----------------------------------------------------------------- > Martín Marqués email: martin@math.unl.edu.ar > Santa Fe - Argentina http://math.unl.edu.ar/~martin/ > Administrador de sistemas en math.unl.edu.ar > -----------------------------------------------------------------