Enter your vote today!  Check out the new poll for the metabase-dev
group:


Metabase development aims to provide a database abstraction package for all DBMS
supported by PHP.  However it is not possible develop Metabase drivers for all
immediately.  Please indicate which DBMS do you use and would like to see
further support in Metabase. Your vote is secret and your privacy is assured.


   o Informix
   o Interbase
   o Microsoft SQL Server
   o Mini SQL
   o MySQL
   o ODBC
   o Oracle (ora interface)
   o Oracle (oci interface)
   o PostgreSQL
   o Sybase
   o Other (tell it to metabase-dev@egroups.com)


To vote, please visit the following web page:

http://www.egroups.com/polls/metabase-dev

Note: Please do not reply to this message. Poll votes are
not collected via email. To vote, you must go to the eGroups
web site listed above.

Thanks!

Hello,

 Metabase is solid PHP is a database abstraction package that aims to
provide support for all DBMS supported by PHP providing the basis for full
database independent Web applications.

There are several tools and components available that interface with
Metabase and some will be made available soon, like:

- Automatic Forms interface (database_access_class)

   o Load form fields with values resulting from a programmer defined query.
   o Build lists suitable for select form field options
   o Update database table records only with values from fields changed by
     the user.
   o Added new database table records with values taken from form fields.
   o Delete database table records using form field values as search criteria.

- Database table editor (edit_list_class)

   o Query result table wrapper with list entries of one or more tables
     specified by the programmer, eventually limiting the number of entries
     per page with next and previous page links, links to the edit, add and
     delete list entries.
   o (Optional) Edit list entries in a customizable form updating only the
     fields in the database for that correspond to form fields that the user
     has changed.
   o (Optional) Add new list entries using a customizable form to let the
     user define the values of the new entry database records.
   o (Optional) Delete existing list entries by deleting the respective
     database records requesting user confirmation before proceeding.

- Database based form field validation (database_forms_class)

   Sub class of the forms_class that adds more built-in form value
   validation types based on database queries optionally using values taken
   from arbitrary fields of the form submitted by the user.
   o Searching (Record does not exist)
   o Avoiding duplication (Record exists)
   o Counting (too many or too few records).
   o etc...

These components only work with Metabase API and are almost ready to be
release, as they are mostly awaiting to be properly documented first.
Other components and small applications are planned and will be implemented
and announced soon.  All you need to use them is Metabase with a driver for
one of the supported databases.

Many drivers are available now and a few others are under beta testing to
be released soon.  For the others it is not possible develop Metabase
drivers for all immediately, but if there are more requests some drivers
will get priority in the development and subsequent release.

If you would to see the any particular drivers be released sooner, please
go to this page and indicate on ore more DBMS that you use and would like
to see further support in Metabase.  Your vote is secret and your privacy
is assured.

http://www.egroups.com/surveys/metabase-dev?id=263873

Metabase is available here:

http://phpclasses.UpperDesign.com/browse.html/package/20

Here follows the list of available and planned drivers that you may vote on
the poll:

    State
OTHER/BETA  Informix (contributed by Pierre-henri Delaval)
OTHER/BETA  Interbase (contributed by Meir Kriheli)
DONE        Microsoft SQL Server
DONE        Mini SQL
DONE        MySQL
NEEDS WORK  ODBC
N/A         Oracle (ora interface)
DONE        Oracle (oci interface)
DONE        PostgreSQL
N/A         Sybase
             Other (tell it to metabase-dev@egroups.com)

Legend:
DONE       - API completely implemented and fully tested.
OTHER      - being developed by other developer contributing with the code
BETA       - being tested and possibly not fully deployed
NEEDS WORK - API not completely implemented
N/A        - Not yet available, please let me know if you would like to work on
it.

Regards,
Manuel Lemos

Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org
--
E-mail: mlemos@...
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the metabase-dev
group.

   File        : /metabase_pgsql.php
   Uploaded by : mlemos@...
   Description : PostgreSQL driver class fixed problem of the highest fetched row
not be updated when ResultIsNull is called leading to eventual incorrect return
value of EndOfResult call.

You can access this file at the URL

http://www.egroups.com/files/metabase-dev/metabase_pgsql%2Ephp

To learn more about eGroups file sharing, please visit

http://www.egroups.com/help/files.html


Regards,

mlemos@...

I am casting vote for a Perl DBI::Proxy-compatible driver, such that a
PHP Metabase client can hit up a DBI::Proxy server.

The benefits are many: Metabase would be able to talk to *any* server
Perl::DBI could talk to -- much like an ODBC layer!

I mentioned this to Manuel not too long ago, and would be able to devote
*some* time to development of it.  But can we build concensus?

-Brian

To Unsubscribe, send a blank message to: metabase-dev-unsubscribe@eGroups.com
Need other Metabase drivers?
http://www.egroups.com/surveys/metabase-dev?id=263873
Latest beta version: http://www.egroups.com/files/metabase-dev
Vote on Metabase: http://www.zend.com/apps.php?id=122&single=1

------------------------------------------------------------------------

There are 3 messages in this issue.

Topics in this digest:

       1. New poll for metabase-dev
            From: metabase-dev@egroups.com
       2. PHP database abstraction driver request poll
            From: "Manuel Lemos" <mlemos@...>
       3. New file uploaded to metabase-dev
            From: <metabase-dev@egroups.com>


________________________________________________________________________
________________________________________________________________________

Message: 1
    Date: 2 Aug 2000 04:51:24 -0000
    From: metabase-dev@egroups.com
Subject: New poll for metabase-dev


Enter your vote today!  Check out the new poll for the metabase-dev
group:


Metabase development aims to provide a database abstraction package for all DBMS
supported by PHP.  However it is not possible develop Metabase drivers for all
immediately.  Please indicate which DBMS do you use and would like to see
further support in Metabase. Your vote is secret and your privacy is assured.


   o Informix
   o Interbase
   o Microsoft SQL Server
   o Mini SQL
   o MySQL
   o ODBC
   o Oracle (ora interface)
   o Oracle (oci interface)
   o PostgreSQL
   o Sybase
   o Other (tell it to metabase-dev@egroups.com)


To vote, please visit the following web page:

http://www.egroups.com/polls/metabase-dev

Note: Please do not reply to this message. Poll votes are
not collected via email. To vote, you must go to the eGroups
web site listed above.

Thanks!







________________________________________________________________________
________________________________________________________________________

Message: 2
    Date: 2 Aug 2000 5:0:3 -0300
    From: "Manuel Lemos" <mlemos@...>
Subject: PHP database abstraction driver request poll

Hello,
Metabase is solid PHP is a database abstraction package that aims to
provide support for all DBMS supported by PHP providing the basis for full
database independent Web applications.

There are several tools and components available that interface with
Metabase and some will be made available soon, like:

- Automatic Forms interface (database_access_class)

   o Load form fields with values resulting from a programmer defined query.
   o Build lists suitable for select form field options
   o Update database table records only with values from fields changed by
     the user.
   o Added new database table records with values taken from form fields.
   o Delete database table records using form field values as search criteria.

- Database table editor (edit_list_class)

   o Query result table wrapper with list entries of one or more tables
     specified by the programmer, eventually limiting the number of entries
     per page with next and previous page links, links to the edit, add and
     delete list entries.
   o (Optional) Edit list entries in a customizable form updating only the
     fields in the database for that correspond to form fields that the user
     has changed.
   o (Optional) Add new list entries using a customizable form to let the
     user define the values of the new entry database records.
   o (Optional) Delete existing list entries by deleting the respective
     database records requesting user confirmation before proceeding.

- Database based form field validation (database_forms_class)

   Sub class of the forms_class that adds more built-in form value
   validation types based on database queries optionally using values taken
   from arbitrary fields of the form submitted by the user.
   o Searching (Record does not exist)
   o Avoiding duplication (Record exists)
   o Counting (too many or too few records).
   o etc...

These components only work with Metabase API and are almost ready to be
release, as they are mostly awaiting to be properly documented first.
Other components and small applications are planned and will be implemented
and announced soon.  All you need to use them is Metabase with a driver for
one of the supported databases.

Many drivers are available now and a few others are under beta testing to
be released soon.  For the others it is not possible develop Metabase
drivers for all immediately, but if there are more requests some drivers
will get priority in the development and subsequent release.

If you would to see the any particular drivers be released sooner, please
go to this page and indicate on ore more DBMS that you use and would like
to see further support in Metabase.  Your vote is secret and your privacy
is assured.

http://www.egroups.com/surveys/metabase-dev?id=263873

Metabase is available here:

http://phpclasses.UpperDesign.com/browse.html/package/20

Here follows the list of available and planned drivers that you may vote on
the poll:

    State
OTHER/BETA  Informix (contributed by Pierre-henri Delaval)
OTHER/BETA  Interbase (contributed by Meir Kriheli)
DONE        Microsoft SQL Server
DONE        Mini SQL
DONE        MySQL
NEEDS WORK  ODBC
N/A         Oracle (ora interface)
DONE        Oracle (oci interface)
DONE        PostgreSQL
N/A         Sybase
             Other (tell it to metabase-dev@egroups.com)

Legend:
DONE       - API completely implemented and fully tested.
OTHER      - being developed by other developer contributing with the code
BETA       - being tested and possibly not fully deployed
NEEDS WORK - API not completely implemented
N/A        - Not yet available, please let me know if you would like to work on
it.

Regards,
Manuel Lemos

Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org
--
E-mail: mlemos@...
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--



________________________________________________________________________
________________________________________________________________________

Message: 3
    Date: 2 Aug 2000 08:17:16 -0000
    From: <metabase-dev@egroups.com>
Subject: New file uploaded to metabase-dev


Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the metabase-dev
group.

   File        : /metabase_pgsql.php
   Uploaded by : mlemos@...
   Description : PostgreSQL driver class fixed problem of the highest fetched row
not be updated when ResultIsNull is called leading to eventual incorrect return
value of EndOfResult call.

You can access this file at the URL

http://www.egroups.com/files/metabase-dev/metabase_pgsql%2Ephp

To learn more about eGroups file sharing, please visit

http://www.egroups.com/help/files.html


Regards,

mlemos@...






________________________________________________________________________
________________________________________________________________________

Hello Brian,

On 02-Aug-00 11:41:44, you wrote:

>I am casting vote for a Perl DBI::Proxy-compatible driver, such that a
>PHP Metabase client can hit up a DBI::Proxy server.

Yes, that would solve the problems of many people, like the inability to
build PHP in a local machine without the necessary support to access remote
databases, say accessing from Linux to remote Microsoft Access databases or
Microsoft SQL server, IBM DB2, etc...

Another use that is very high on demand is the ability to manage a database
connection pool where database connections would be reused by the proxy
server.


>The benefits are many: Metabase would be able to talk to *any* server
>Perl::DBI could talk to -- much like an ODBC layer!

Yes, actually with ODBC you still need a ODBC-ODBC bridge driver and ODBC
built-in PHP locally.  The advantage of a Metabase database connection
proxy server is that the local client would only need any version of PHP
that supports TCP socket connections, that includes PHP 3.


>I mentioned this to Manuel not too long ago, and would be able to devote
>*some* time to development of it.  But can we build concensus?

I have looked into this to do it myself but I haven't enough worth to
mention as I haven't had enough time to move on.

The good news is that I could talk Chris Haven into integrating his socket
bind/listen code into a PHP 4 extension that is now available, so now you
can run PHP standalone CGI executable (no Web server needed) as a general
purpose TCP/Unix domain socket.  You need to configure PHP with the
--enable-sockets switch.

So, if you would like go ahead and start it.  If you need help just let us
know.  You may want to look into ext/sockets/sockets.c file of PHP source
code, as well into PHP IRCd that Chris developed using PHP and his
extension.  In any case we may ask for further help to Chris.

http://www.legion.f9.co.uk/php-ircd/


Regards,
Manuel Lemos

Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org
--
E-mail: mlemos@...
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the metabase-dev
group.

   File        : /beta/metabase_ifx.php
   Uploaded by : mlemos@...
   Description : Metabase driver class to interface with Informix databases

You can access this file at the URL

http://www.egroups.com/files/metabase-dev/beta/metabase_ifx%2Ephp

To learn more about eGroups file sharing, please visit

http://www.egroups.com/help/files.html


Regards,

mlemos@...

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the metabase-dev
group.

   File        : /beta/driver_test.php
   Uploaded by : mlemos@...
   Description : Metsbase test driver script

You can access this file at the URL

http://www.egroups.com/files/metabase-dev/beta/driver_test%2Ephp

To learn more about eGroups file sharing, please visit

http://www.egroups.com/help/files.html


Regards,

mlemos@...

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the metabase-dev
group.

   File        : /beta/driver_test_configuration.php
   Uploaded by : mlemos@...
   Description : Metabase driver test configuration script

You can access this file at the URL

http://www.egroups.com/files/metabase-dev/beta/driver_test_configuration%2Ephp

To learn more about eGroups file sharing, please visit

http://www.egroups.com/help/files.html


Regards,

mlemos@...

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the metabase-dev
group.

   File        : /beta/metabase_interface.php
   Uploaded by : mlemos@...
   Description : Metabase API file

You can access this file at the URL

http://www.egroups.com/files/metabase-dev/beta/metabase_interface%2Ephp

To learn more about eGroups file sharing, please visit

http://www.egroups.com/help/files.html


Regards,

mlemos@...

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the metabase-dev
group.

   File        : /beta/metabase_manager.php
   Uploaded by : mlemos@...
   Description : Metabase database installation manager class

You can access this file at the URL

http://www.egroups.com/files/metabase-dev/beta/metabase_manager%2Ephp

To learn more about eGroups file sharing, please visit

http://www.egroups.com/help/files.html


Regards,

mlemos@...

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the metabase-dev
group.

   File        : /beta/metabase_mysql.php
   Uploaded by : mlemos@...
   Description : Metabase MySQL driver class

You can access this file at the URL

http://www.egroups.com/files/metabase-dev/beta/metabase_mysql%2Ephp

To learn more about eGroups file sharing, please visit

http://www.egroups.com/help/files.html


Regards,

mlemos@...

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the metabase-dev
group.

   File        : /beta/metabase_oci.php
   Uploaded by : mlemos@...
   Description : Metabase Oracle driver class using OCI

You can access this file at the URL

http://www.egroups.com/files/metabase-dev/beta/metabase_oci%2Ephp

To learn more about eGroups file sharing, please visit

http://www.egroups.com/help/files.html


Regards,

mlemos@...

Sorry but my english is very poor.

Manuel, desculpe por postar a mensagem em português mas meu inglês anda
muito enferrujado. Preferi postar assim do que escrever besteira ;o)

Utilizando o Metabase eu posso criar, através do XML, tabelas com todos os
tipos de campos que o MySQL me permite sem restrições de tamanho de campo?

Há alguma limitação no Metabase que me impossibilite de utilizá-lo para
extrair *todos* os recursos do MySQL?

Aproveito para, novamente, elogiar seu trabalho e parabenizá-lo pelo ótimo
pacote desenvolvido.

Atenciosamente,

Fernando M.

Hello,

It seems that you have completelly redeign the ifx driver ?

Tell me more...

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the metabase-dev
group.

   File        : /beta/metabase_pgsql.php
   Uploaded by : mlemos@...
   Description : Metabase PostgreSQL driver class

You can access this file at the URL

http://www.egroups.com/files/metabase-dev/beta/metabase_pgsql%2Ephp

To learn more about eGroups file sharing, please visit

http://www.egroups.com/help/files.html


Regards,

mlemos@...

Viva Fernando,

No dia 09-Ago-00 06:37:40, escreveu:

>Sorry but my english is very poor.

Exceptionally this message will be answered in Portuguese here.


>Manuel, desculpe por postar a mensagem em português mas meu inglês anda
>muito enferrujado. Preferi postar assim do que escrever besteira ;o)

Não tem problema.  No entanto, para evitar que alguém nesta lista se
chateie por causa de não usar inglês, de futuro faça um esforço mesmo que
escreva em "besteira" em inglês ou então escreva para mim directamente, ok?


>Utilizando o Metabase eu posso criar, através do XML, tabelas com todos os
>tipos de campos que o MySQL me permite sem restrições de tamanho de campo?

Não, se não especificar o tamanho de campo de text, o driver usa um campo tipo
TEXT, mas note que o próprio MySQL impõem um limite e você não pode usar
qualquer tipo de operações em campos TEXT como pode em VARCHAR.


>Há alguma limitação no Metabase que me impossibilite de utilizá-lo para
>extrair *todos* os recursos do MySQL?

Acho que não.  O Metabase ainda não suporta tudo que é comum nas diversas
bases de dados, como chaves primárias e externas.  No entanto, você passa
bem sem isso, porque na prática as chaves primárias são indíces únicos que
já são suportados pelo Metabase e as chaves externas servem apenas para
verificar a consistência das relações entre tabelas.

De momento, o Metabase também não suporta LOB (ficheiros na base de dados).
No futuro o suporte a estas capacidades será também adicionado.



>Aproveito para, novamente, elogiar seu trabalho e parabenizá-lo pelo ótimo
>pacote desenvolvido.

Obrigado.  No entanto se tiver alguma aplicação ou componente interessante
baseado no Metabase que deseje compartilhar com outros utilizadores,
avise-me que dentro do possível divulgarei na própria página do Metabase no
site PHP Classes.  De resto, continue a divulgar o Metabase entre os outros
utilizadores de PHP que conhece.


Um abraço,
Manuel Lemos

Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org
--
E-mail: mlemos@...
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--

Hello Pierre-henri,

On 09-Aug-00 06:48:41, you wrote:

>It seems that you have completelly redeign the ifx driver ?

>Tell me more...

I've been meaning to tell you sooner but I was waiting to solve the most
important problems first. I will update Metabase documentation soon with the
details that are specific of the Informix driver.  Anyway, here follow the
most important details:

- PHP Informix API function are (were) very buggy. The stress tests allowed to
   isolate many of those bugs and make meaningful reports that helped Danny
   (PHP Informix extension) to fix most of them.  Anyway, the fixed version
   was not yet publically released. It will be either 3.0.17 or 4.0.2 .

- Still to be fixed are the problems of not being able to determine for
   sure wether text result value a NULL or not.  The current Metabase
   Informix driver calls ifx_nullformat to make NULLs be returned as text
   string NULL but that still may be a valid non NULL text value.

- Currently PHP Informix extension keeps non-persistent connection opened
   to the end of the script.  This implies that if you use shared memory to
   connect to the server, you won't be able to connect more than once same
   script, eventually to access to different databases or logging as
   different users.


Regards,
Manuel Lemos

Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org
--
E-mail: mlemos@...
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--

Hello Manuel ,

> - PHP Informix API function are (were) very buggy. The stress tests
allowed to
>   isolate many of those bugs and make meaningful reports that helped Danny
>   (PHP Informix extension) to fix most of them.  Anyway, the fixed version
>   was not yet publically released. It will be either 3.0.17 or 4.0.2


forgive me  for my english ,  do  you mean that  informix's php api has many
bugs ?
and you are now figuring them out ? Wow , what a shock , I am now using it
very extensively !!
also you mean that the fixed version is 3.0.17 or 4.0.2 ,
does the "verison" means the php version or  or else ( I guess it is php
version ) .

thanks and one more question , Danny is an engineer of informix ?

Best,
Mars




----- Original Message -----
From: "Manuel Lemos" <mlemos@...>
To: "Pierre-henri Delaval" <metabase-dev@egroups.com>
Sent: Thursday, August 10, 2000 10:57 AM
Subject: Re: [metabase-dev] Ifx ???


> Hello Pierre-henri,
>
> On 09-Aug-00 06:48:41, you wrote:
>
> >It seems that you have completelly redeign the ifx driver ?
>
> >Tell me more...
>
> I've been meaning to tell you sooner but I was waiting to solve the most
> important problems first. I will update Metabase documentation soon with
the
> details that are specific of the Informix driver.  Anyway, here follow the
> most important details:
>
> - PHP Informix API function are (were) very buggy. The stress tests
allowed to
>   isolate many of those bugs and make meaningful reports that helped Danny
>   (PHP Informix extension) to fix most of them.  Anyway, the fixed version
>   was not yet publically released. It will be either 3.0.17 or 4.0.2 .
>
> - Still to be fixed are the problems of not being able to determine for
>   sure wether text result value a NULL or not.  The current Metabase
>   Informix driver calls ifx_nullformat to make NULLs be returned as text
>   string NULL but that still may be a valid non NULL text value.
>
> - Currently PHP Informix extension keeps non-persistent connection opened
>   to the end of the script.  This implies that if you use shared memory to
>   connect to the server, you won't be able to connect more than once same
>   script, eventually to access to different databases or logging as
>   different users.
>
>
> Regards,
> Manuel Lemos
>
> Web Programming Components using PHP Classes.
> Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org
> --
> E-mail: mlemos@...
> URL: http://www.mlemos.e-na.net/
> PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
> --
>
>
>
>
> To Unsubscribe, send a blank message to:
metabase-dev-unsubscribe@eGroups.com
> Need other Metabase drivers?
http://www.egroups.com/surveys/metabase-dev?id=263873
> Latest beta version: http://www.egroups.com/files/metabase-dev
> Vote on Metabase: http://www.zend.com/apps.php?id=122&single=1
>
>
>

Hello Mars,

Before I forget again, I would like to mention this.  The Metabase Informix
driver quest has been crazy, especially for me that I am not quite a
Informix user.  Since Pierre-henri contributed with his initial version of
the driver, I had some much trouble trying to setup a Informix server in my
Linux box, even more than with Oracle (can you believe it, worse than
Oracle?  :-) ).

I requested help and several Informix users contacted me.  In the name of
all Metabase Informix users I would like to publically thank you all, but
in particular to you Mars that managed to make me see what I was missing
that I could not figure from Informix documentation.  Thank you again, and
"shoot" me if you find any problems or bugs in the driver class.  :-)


On 10-Aug-00 02:57:58, you wrote:

>> - PHP Informix API function are (were) very buggy. The stress tests
>allowed to
>>   isolate many of those bugs and make meaningful reports that helped Danny
>>   (PHP Informix extension) to fix most of them.  Anyway, the fixed version
>>   was not yet publically released. It will be either 3.0.17 or 4.0.2

>forgive me  for my english ,  do  you mean that  informix's php api has many
>bugs ?

Things that are making the Metabase driver conformance fail because they
are simply not right in PHP Informix extension.  At least I know it's not
Metabase fault.


>and you are now figuring them out ? Wow , what a shock , I am now using it
>very extensively !!

From all the problems that I found the ones that I remember that you
should be concerned are:

- There is no way to distinguish if a result really NULL or it happens to
as the text NULL in it (or empty string depending on what is the more for
ifx_nullformat). There is no implemented workaround yet.

- There may be some data corruption if you use INT8 or LVARCHAR.

Just go into http://cvs.php.net/ and enter in php4/ext/informix and
look at revision history for ifx.ec .


>also you mean that the fixed version is 3.0.17 or 4.0.2 ,
>does the "verison" means the php version or  or else ( I guess it is php
>version ) .

Yes, those versions are not yet publically released. I don't know if
you can already find them in http://snaps.cvs.net/ .


>thanks and one more question , Danny is an engineer of informix ?

I could not figure that from his address:  Danny Heijl
<danny.heijl@...>.  However, I have been in contact with Jonathan
Leffler <Jonathan.Leffler@...> that is Perl DBD Informix
maintainer and has been rowing for a proper Linux Informix implementation.


Regards,
Manuel Lemos

Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org
--
E-mail: mlemos@...
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--

Hi,

I have used metabase and oracle and liked very much. Now I'm trying
use metabase with mysql but I dont now which parameters I must use ...
I always have got error message "It was not specified a valid
database name to select". I'm using PHP Version 4.0.1pl2, MySQL
3.22.32a and Apache/1.3.12 (Unix).

Sincerely yours,
Jairo

Hello Jairo,

On 14-Aug-00 17:35:30, you wrote:

>I have used metabase and oracle and liked very much. Now I'm trying
>use metabase with mysql but I dont now which parameters I must use ...
>I always have got error message "It was not specified a valid
>database name to select". I'm using PHP Version 4.0.1pl2, MySQL
>3.22.32a and Apache/1.3.12 (Unix).

To query a database you need to specify it's name first.  Use the function
MetabaseSetDatabase to do that.  Answer this message if you still have a
problem.



Regards,
Manuel Lemos

Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org
--
E-mail: mlemos@...
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--

----- Original Message -----

From: Manuel Lemos

To: Jairo Silva

Sent: Tuesday, August 15, 2000 7:00 PM

Subject: Re: [metabase-dev] Metabase and Mysql

Hello Jairo,

On 14-Aug-00 17:35:30, you wrote:

>I have used metabase and oracle and liked very much. Now I'm trying
>use metabase with mysql but I dont now which parameters I must use ...
>I always have got error message "It was not specified a valid
>database name to select". I'm using PHP Version 4.0.1pl2, MySQL
>3.22.32a and Apache/1.3.12 (Unix).

To query a database you need to specify it's name first.  Use the function
MetabaseSetDatabase to do that.  Answer this message if you still have a
problem.



Regards,
Manuel Lemos

Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?user=mlemos@...
--
E-mail: mlemos@...
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--

To Unsubscribe, send a blank message to: metabase-dev-unsubscribe@eGroups.com
Need other Metabase drivers? http://www.egroups.com/surveys/metabase-dev?id=263873
Latest beta version: http://www.egroups.com/files/metabase-dev
Vote on Metabase: http://www.zend.com/apps.php?id=122&single=1

Hello Jairo,

On 16-Aug-00 00:08:16, you wrote:

>Now it works, but when I use update or detete sql commands I get the
>following warning : Unable to save result set ... but the commands are
>executed with sucess. What is this ?

That does not seem to be a Metabase message.  Can you show the code that
you used to get that?

Regards,
Manuel Lemos

Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org
--
E-mail: mlemos@...
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--

----- Original Message -----

From: Manuel Lemos

To: Jairo Marciano Silva

Sent: Wednesday, August 16, 2000 3:49 AM

Subject: Re: [metabase-dev] Metabase and Mysql

Hello Jairo,

On 16-Aug-00 00:08:16, you wrote:

>Now it works, but when I use update or detete sql commands I get the
>following warning : Unable to save result set ... but the commands are
>executed with sucess. What is this ?

That does not seem to be a Metabase message.  Can you show the code that
you used to get that?

Regards,
Manuel Lemos

Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?user=mlemos@...
--
E-mail: mlemos@...
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--

To Unsubscribe, send a blank message to: metabase-dev-unsubscribe@eGroups.com
Need other Metabase drivers? http://www.egroups.com/surveys/metabase-dev?id=263873
Latest beta version: http://www.egroups.com/files/metabase-dev
Vote on Metabase: http://www.zend.com/apps.php?id=122&single=1

Dear all ,

    Until recently , my php4 (php-4.0.1pl2) encountered informix -406 error
sometimes ,
As I notice from "top"  , the httpd processes have  RSS  up to 71M , or 60M,
... ,  if all the RSS are too big , the error -406 happened , all my php
page
using ifx_pconnect to connect informix , and select data to display !!

    The php is compiled as a module of apache 1.3.12 , running in rad hat 6.1
,
esql /c is 9.30.UC1 !!

    another linux has informix's 7.30.uc7x1 engine !!

Notice the following that while used is over Mem , even system process is
out !!

Mem:  517236K av, 514104K used,   3132K free, 1362904K shrd,  16540K buff

In my env , MaxSpareServers is 10 , MinSpareServers is 5 , while I refresh
my php page connecting informix very quickly , the httpd grow very fast ,
let us say ,
150 (MaxClients) !! and then stop for a while , the httpd process die and
die ,
then 10 httpd survive (MaxSpareServers) , notice from top that RSS grow very
fast !!
also notice that RSS always grow  , but never freed (so that one of them is
71MB in my case),
and then you do it over and over again , the RSS grow and grow fast , and
then you
will encounter the memory's problem , stop and restart apache works !!

all my php program use ifx_pconnect because it is much faster than
ifx_connect !!
now , my solution is to modify my httpd.conf  , let
MaxRequestPerChild = 500 !! this ensure that while a httpd process accept
500 request ,
it will die and free any resource it holds !!

the following is from informix : onstat -g seg :

Segment Summary:
id       key        addr     size       ovhd     class blkused  blkfree
0        1381386241 10000000 260710400  4836     R     31818    7
8        1381386249 1f8a2000 32768000   1096     V     933      3067
9        1381386250 217e2000 180224     600      M     16       6
10       1381386251 2180e000 8388608    724      V     161      863
11       1381386252 2200e000 8388608    724      V     197      827
12       1381386253 2280e000 8388608    724      V     64       960
13       1381386254 2300e000 8388608    724      V     92       932
14       1381386255 2380e000 8388608    724      V     21       1003
15       1381386256 2400e000 8388608    724      V     62       962
16       1381386257 2480e000 8388608    724      V     41       983
17       1381386258 2500e000 8388608    724      V     2        1022
18       1381386259 2580e000 8388608    724      V     1        1023
19       1381386260 2600e000 8388608    724      V     1        1023
20       1381386261 2680e000 8388608    724      V     5        1019
21       1381386262 2700e000 8388608    724      V     5        1019
22       1381386263 2780e000 8388608    724      V     14       1010
23       1381386264 2800e000 8388608    724      V     13       1011
24       1381386265 2880e000 8388608    724      V     18       1006
25       1381386266 2900e000 8388608    724      V     7        1017
26       1381386267 2980e000 8388608    724      V     1        1023
27       1381386268 2a00e000 8388608    724      V     1        1023
28       1381386269 2a80e000 8388608    724      V     1        1023
29       1381386270 2b00e000 8388608    724      V     1        1023
30       1381386271 2b80e000 8388608    724      V     2        1022
Total:    -                     -                 469819392  -        -
33477    23874


Any comments are welcome !!

Best,
Mars

Hello ???,

On 28-Aug-00 04:32:42, you wrote:

>   Until recently , my php4 (php-4.0.1pl2) encountered informix -406 error
>sometimes ,
>As I notice from "top"  , the httpd processes have  RSS  up to 71M , or 60M,
>... ,  if all the RSS are too big , the error -406 happened , all my php
>page
>using ifx_pconnect to connect informix , and select data to display !!

This sounds like you are not freeing result queries and therefore the
respective memory is not released until the process that runs them dies.

Since you are using Apache, the longer its processes live to re-run PHP
scripts that make Informix queries, the more memory it will hold if you do
not release query results.


Regards,
Manuel Lemos

Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org
--
E-mail: mlemos@...
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--

Dear All ,

> On 28-Aug-00 04:32:42, you wrote:
>
> >   Until recently , my php4 (php-4.0.1pl2) encountered informix -406
error
> >sometimes ,
> >As I notice from "top"  , the httpd processes have  RSS  up to 71M , or
60M,
> >... ,  if all the RSS are too big , the error -406 happened , all my php
> >page
> >using ifx_pconnect to connect informix , and select data to display !!
>
> This sounds like you are not freeing result queries and therefore the
> respective memory is not released until the process that runs them dies.
>
> Since you are using Apache, the longer its processes live to re-run PHP
> scripts that make Informix queries, the more memory it will hold if you do
> not release query results.

Actually , I do check my source , I do call ifx_free_result whenever needs ,
but still the RSS grow without free !!

Now , my solution is to lower  MaxRequestPerChild in httpd.conf  , so that
the process
will die and release the memory , I do check my source , really , now I am
testing
if I should use ifx_close even I use ifx_pconnect , test if this works to
free resource !!

>
>
> Regards,
> Manuel Lemos
>
> Web Programming Components using PHP Classes.
> Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org
> --
> E-mail: mlemos@...
> URL: http://www.mlemos.e-na.net/
> PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
> --
>
>
> To Unsubscribe, send a blank message to:
metabase-dev-unsubscribe@eGroups.com
> Need other Metabase drivers?
http://www.egroups.com/surveys/metabase-dev?id=263873
> Latest beta version: http://www.egroups.com/files/metabase-dev
> Vote on Metabase: http://www.zend.com/apps.php?id=122&single=1
>
>

Hallo,

I downloaded metabase package and I have to say it seems to be one of
the most usefull public scripts I have seen.
I appreciate proper documentation, tutorials and tests scripts.

I tried to set the test scripts to ODBC. Although I run
driver_test.php as standalone aplication, without success.

I think it worth trying to make some a bit easier way for installing
testing database and metabase for ODBC.

With regards

Bohous Hulka

Hello ???,

On 30-Aug-00 00:57:16, you wrote:

>> This sounds like you are not freeing result queries and therefore the
>> respective memory is not released until the process that runs them dies.
>>
>> Since you are using Apache, the longer its processes live to re-run PHP
>> scripts that make Informix queries, the more memory it will hold if you do
>> not release query results.

>Actually , I do check my source , I do call ifx_free_result whenever needs ,
>but still the RSS grow without free !!

>Now , my solution is to lower  MaxRequestPerChild in httpd.conf  , so that
>the process
>will die and release the memory , I do check my source , really , now I am
>testing
>if I should use ifx_close even I use ifx_pconnect , test if this works to
>free resource !!

Maybe there are other leaks in the PHP Informix API.  Anyway, I suggest you
upgrade to PHP 4.0.2 because a lot of connection issues where fixed.  Still
what you may need to try is to build PHP with debugging support enabled and
look in your Web server error log to check if PHP is dumping and error
messages there that could be clues to the real problem.



Regards,
Manuel Lemos

Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org
--
E-mail: mlemos@...
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--

Hello Bohuslav,

On 30-Aug-00 13:20:18, you wrote:

>I downloaded metabase package and I have to say it seems to be one of
>the most usefull public scripts I have seen.
>I appreciate proper documentation, tutorials and tests scripts.

>I tried to set the test scripts to ODBC. Although I run
>driver_test.php as standalone aplication, without success.

>I think it worth trying to make some a bit easier way for installing
>testing database and metabase for ODBC.

As you may read in Metabase manual, the current status of the ODBC driver
is that it needs work.  The greatest problem is to figure what features the
underlying database supports.

I will be investigating this further with help of the UnixODBC and
Openlinksw developers.  A beta version of the driver will be made available
soon in the Metabase files area of this mailing list. Hang on.


Regards,
Manuel Lemos

Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org
--
E-mail: mlemos@...
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--