Hi,

I could not download metabase .zip file. I would like you to send me
that file.

Thanks in advance...

-Gunay

I just installed metabase, and I ran the driver_test.php script to
test it out. I got the following errors:

Testing typed field storage and retrieval ... FAILED! the value
retrieved for field "weight" (35.1283) doesn't match what was stored
(35.128336140501) Testing paged queries... FAILED! the value
retrieved from row 2 for field "weight" (1.4142) doesn't match what
was stored (1.4142135623731) Testing sequences... OK. Testing query
affected rows... OK. Transactions are not supported. 2 tests passed,
2 tests failed!

there was a lot more, but that is the basic gist of things. i also
now have a mysql database named "driver_test" with a table called
users, but the table is empty. am i doing something wrong, or do
those strange mathematical errors have something to do with it?


-Phil

Hello Gunay,

On 24-Jul-00 06:54:28, you wrote:

>I could not download metabase .zip file. I would like you to send me
>that file.

Why couldn't you download the file?  Did you subscribe and login before
downloading? That's necessary.

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 philipc,

On 24-Jul-00 13:15:53, you wrote:

>I just installed metabase, and I ran the driver_test.php script to
>test it out. I got the following errors:

>Testing typed field storage and retrieval ... FAILED! the value
>retrieved for field "weight" (35.1283) doesn't match what was stored
>(35.128336140501) Testing paged queries... FAILED! the value
>retrieved from row 2 for field "weight" (1.4142) doesn't match what
>was stored (1.4142135623731) Testing sequences... OK. Testing query
>affected rows... OK. Transactions are not supported. 2 tests passed,
>2 tests failed!

This seems to be a floating point rounding problem either on PHP or on
MySQL side. Can you please tell me the versions that you are using of:

PHP

MySQL

metabase_mysql.php

metabase_database.php

and also if possible a dump of your PHP configuration phpinfo() that can
also be generated by the standalone CGI executable by running php -q from
the shell.


>there was a lot more, but that is the basic gist of things. i also
>now have a mysql database named "driver_test" with a table called
>users, but the table is empty. am i doing something wrong, or do
>those strange mathematical errors have something to do with it?

You may delete that database as well the file driver_test.schema.before.
It is just created for testing purposes.



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
--

now, it's ok. i think it was a downloading problem. because i've received
"bad zip file" error.

thanx manuel...
----- Original Message -----
From: Manuel Lemos
To: Gunay Temizel
Sent: Tuesday, July 25, 2000 1:00 AM
Subject: Re: [metabase-dev] a request


Hello Gunay,

On 24-Jul-00 06:54:28, you wrote:

>I could not download metabase .zip file. I would like you to send me
>that file.

Why couldn't you download the file?  Did you subscribe and login before
downloading? That's necessary.

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 again,

>>Testing typed field storage and retrieval ... FAILED! the value
>>retrieved for field "weight" (35.1283) doesn't match what was stored
>>(35.128336140501) Testing paged queries... FAILED! the value
>>retrieved from row 2 for field "weight" (1.4142) doesn't match what
>>was stored (1.4142135623731) Testing sequences... OK. Testing query
>>affected rows... OK. Transactions are not supported. 2 tests passed,
>>2 tests failed!

>This seems to be a floating point rounding problem either on PHP or on
>MySQL side. Can you please tell me the versions that you are using of:

>PHP
I'm using 4.0.1pl2

>MySQL
3.22.32

>metabase_mysql.php
metabase_mysql.php,v 1.38 2000/07/05

>metabase_database.php
metabase_database.php,v 1.51 2000/04/23

>and also if possible a dump of your PHP configuration phpinfo() that can
>also be generated by the standalone CGI executable by running php -q from
>the shell.
http://dev.latino.com/info.phtml

I hope this helps. I am looking forward to using metabase.


Philip Cohen
---------------
Web Developer
Latino.com
philipc@...
415-357-4487

Hello Philip,

On 27-Jul-00 13:32:48, you wrote:

>>>Testing typed field storage and retrieval ... FAILED! the value
>>>retrieved for field "weight" (35.1283) doesn't match what was stored
>>>(35.128336140501) Testing paged queries... FAILED! the value
>>>retrieved from row 2 for field "weight" (1.4142) doesn't match what
>>>was stored (1.4142135623731) Testing sequences... OK. Testing query
>>>affected rows... OK. Transactions are not supported. 2 tests passed,
>>>2 tests failed!

>>This seems to be a floating point rounding problem either on PHP or on
>>MySQL side. Can you please tell me the versions that you are using of:

>>PHP
>I'm using 4.0.1pl2

>>MySQL
>3.22.32

I tried with version 3.23.6 and there was no problem.  Can you please try
it with a MySQL 3.23.x version?


>>metabase_mysql.php
>metabase_mysql.php,v 1.38 2000/07/05

>>metabase_database.php
>metabase_database.php,v 1.51 2000/04/23

>>and also if possible a dump of your PHP configuration phpinfo() that can
>>also be generated by the standalone CGI executable by running php -q from
>>the shell.
>http://dev.latino.com/info.phtml

I can't seem to reach this page.  It may be behind a firewall as I can
reach www.latino.com. Just get that page yourself and mail me privately.

Also, if you have built PHP from source in a Unix box, can you please send
me your configure command line?




>I hope this helps. I am looking forward to using metabase.


There is no problem for you to use Metabase with MySQL.  The problem that
makes driver fails only causes round-off error problems if you use floating
point fields (rarely needed).


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_mysql.php
   Uploaded by : mlemos@...
   Description : MySQL driver class with workaround for limitation in MySQL
versions earlier than 3.23.6 that make double fields be created with only 4
decimal places by default.

You can access this file at the URL

http://www.egroups.com/files/metabase-dev/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        : /driver_test.php
   Uploaded by : mlemos@...
   Description : Latest version of the Metabase driver test script.

You can access this file at the URL

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

To learn more about eGroups file sharing, please visit

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


Regards,

mlemos@...

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
--