Hello,

I have just uploaded a new version of Metabase MySQL driver that supports
the newly added transaction support in MySQL.  I was not able to make
ROLLBACK work despite MySQL does not produce any errors. Look in
Metabase page in PHP Classes site for the new MySQL driver class file.

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'm a newbie to metabase and i'm trying to have it working on my
computer.

What is the correct procedure to install and test it ?
I'm using apache and php3 on linux..that part works fine..

thanks.

emmanuel

Precedence: bulk

Hello Frank,

It has been a while since you sent this message... :-)

On 10-May-00 09:25:18, you wrote:

>> >* Every meta-schema object has a unique identifier that is global
>> >worldwide.
>>
>> In the current schema definition, each object has a unique name within its
>> scope, ie, each table has a unique name among schema tables, each field has
>> a unique name among table fields, each index has a unique name among table
>> indexes and each sequence has a unique name among schema sequences.
>>
>> So, there maybe tables and sequences with the same names but they are
>> different objects.  The same for fields and indexes. Should I prevent
>> this? Why?

>The names of tables, columns, etc are implementation issues, I am
>talking about the meta-schema model elements.

>There are many type ontologies in this world. There are types for
>engineers, marketing, developers, databases, grocery stores, etc., etc.,
>etc.. which are the domains that declare the types. A universal
>identification (DCE UUID for example) leaves the door open for namespace
>and so on in the future. Just a thought.

I see, but the way I see it, there should be an higher level database
schema abstraction that could be mapped to Metabase schema descriptions
because Metabase is meant to only install databases from descriptions
of data and their types that map to the usual data types that are available
in SQL databases.


>> >* Meta-schema objects describe tables, columns, constraints,
>> >relationships, and types
>>
>> There is currently no support for inter-table field relationships like
>> foreign keys and such. Most applications don't need that and many DBMS
>> don't support them, so I didn't bother to add some support for
>> relationships at that level.  I am not sure if that is what you meant and
>> if it wouldn't be something to invest.

>Wheter the underlying database supports it is irrelevant. If it is the
>logical schema for the designer, than it is up to the implementation
>driver to emulate the join criteria (sub-select, recursive) whatever.
>The point is that it is a naturally occuring relationship.

I see, but please understand that is beyond the scope of Metabase.  An
higher level tool could let developers model their database in the way that
you suggest and then could output schema description files that Metabase
could parse and install. I'm afraid that stuffing all that in Metabase
would make it more bloated than most people need.

If you want to start working on such higher level tool, just let me know
if you need any help.

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

Precedence: bulk

Hello Emmanuel,

On 29-Jun-00 11:01:08, you wrote:

>i'm a newbie to metabase and i'm trying to have it working on my
>computer.

>What is the correct procedure to install and test it ?
>I'm using apache and php3 on linux..that part works fine..

Just copy the files metabase_interface.php, metabase_database.php and
metabase_your_database_driver_here.php to your include path.  In your
site PHP scripts include these files in the beginning.  Then read the
tutorial document to learn how access your database.  There are plenty of
examples there to get you started.

If you want to have Metabase to install a database schema for you may want
to start by copying the script setup_test.php and test.schema files and
edit them to design and install your database. It is recommended that you
use PHP as standalone CGI executable version program to execute this script
from shell as you may not be able to install your database as your Web
user.


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

Manuel Lemos wrote:
>
> Precedence: bulk
>
> Hello Frank,
>
> It has been a while since you sent this message... :-)
>
> On 10-May-00 09:25:18, you wrote:
> [snip]
>
> >Wheter the underlying database supports it is irrelevant. If it is the
> >logical schema for the designer, than it is up to the implementation
> >driver to emulate the join criteria (sub-select, recursive) whatever.
> >The point is that it is a naturally occuring relationship.
>
> I see, but please understand that is beyond the scope of Metabase.  An
> higher level tool could let developers model their database in the way that
> you suggest and then could output schema description files that Metabase
> could parse and install. I'm afraid that stuffing all that in Metabase
> would make it more bloated than most people need.
>
> If you want to start working on such higher level tool, just let me know
> if you need any help.

With most modeling tools (including ArgoUML) generating XMI as the
interchange it may be more useful for Metabase to be able to parse that,
or maybe XML Schema.

But I'll keep your offer in mind!

Best,

Frank V. Castellucci

I like the theory behind the design of Metabase, especially the
uniform XML-based representation of data structures.  However, I do
not feel that it is ready for incorporating into my PHP application
mainly because of the lack of more robust database features which I
rely on.

Mainly I am interested in:
1. Foreign key support.  In my experience this is an essential feature
for db integrity assurance.  Also, possibly greater support for more
datatypes, plus support for functions/operators such as time interval
comparisons, date calculations, string operations... all typical stuff
which seems to vary slightly in different databases.

2.  The capability to reverse engineer the database -- basically to
query metadata and rebuild the XML schema from the tables themselves.
For example, a 'cluster' optimization in postgres will re-organize the
physical placement of data in the table according to an index, but
will also destroy all indexes on the table -- Metabase should be able
to detect the missing indexes and re-create them from the XML source.

3.  More adaptive functionality to automate database alterations,
especially within postgres which does not support alter table as well
as mysql.  In the case of Postgres, I think that a proper adaptation
to Metabase, probably with the help of #2 could perform more advanced
table alterations.

Another point of contention is that as a Linux/Postgres/PHP user I am
not really interested in the ultimate cross-database portability.  I
feel this compatibility issue may force Metabase to adapt to the
lowest-common feature set, which kind of makes it pointless to use a
more powerful DBMS like Postgres, Oracle or DB2.

Another point to consider is given my orientation towards using only
Postgres maybe it would be more appropriate to incorporate the
XML-based interface into the Postgres tree itself rather than as an
external PHP application.

I am comfortable with large PHP-based projects and use XML heavily, so
I feel that I could probably help directly in the Metabase project but
I am not sure what the long-term goals of the Metabase are:
compatibility vs features and how that fits in with my needs.

Any comments?

Hello Andrew,

On 07-Jul-00 17:43:36, you wrote:

>I like the theory behind the design of Metabase, especially the
>uniform XML-based representation of data structures.  However, I do
>not feel that it is ready for incorporating into my PHP application
>mainly because of the lack of more robust database features which I
>rely on.

>Mainly I am interested in:
>1. Foreign key support.  In my experience this is an essential feature
>for db integrity assurance.  Also, possibly greater support for more

I haven't add support for table keys because I haven't needed them.
That doesn't mean I won't add them in the future. My problem is more of
time to implement things properly so that they work flawlessly in all
supported DBMS.

What I may do is to add the API hooks that seem to accomodate the
differences between different DBMS and then let other developers to
contribute with the necessary code to support these and other features.
What do you think?


>datatypes, plus support for functions/operators such as time interval
>comparisons, date calculations, string operations... all typical stuff
>which seems to vary slightly in different databases.

Aren't those things supposed to be supported on the server side? How
do you like Metabase to support them on PHP side?


>2.  The capability to reverse engineer the database -- basically to
>query metadata and rebuild the XML schema from the tables themselves.

Yes, I would like to have schema and result set metadata retrieval support
but like many other things I need time to implement them. I might just add
the necessary API calls for now and implement them later.


>For example, a 'cluster' optimization in postgres will re-organize the
>physical placement of data in the table according to an index, but
>will also destroy all indexes on the table -- Metabase should be able
>to detect the missing indexes and re-create them from the XML source.

I'm not sure what you are talking about here.  Why would a cluster
optimization drop indexes on a table without recreating them later?


>3.  More adaptive functionality to automate database alterations,
>especially within postgres which does not support alter table as well
>as mysql.  In the case of Postgres, I think that a proper adaptation
>to Metabase, probably with the help of #2 could perform more advanced
>table alterations.

Yes, I am particularly annoyed by the fact that PostgreSQL is not able to
drop columns.  But what do you suggest that Metabase do here?


>Another point of contention is that as a Linux/Postgres/PHP user I am
>not really interested in the ultimate cross-database portability.  I

Are you sure you will never change DBMS in the future tro overcome
PostgreSQL limitations?  Have you considered for instance Interbase?


>feel this compatibility issue may force Metabase to adapt to the
>lowest-common feature set, which kind of makes it pointless to use a
>more powerful DBMS like Postgres, Oracle or DB2.

That's not the case.  For instance, Metabase supports transactions and
decimal (fixed point) fields while they are not supported by all DBMS.


>Another point to consider is given my orientation towards using only
>Postgres maybe it would be more appropriate to incorporate the
>XML-based interface into the Postgres tree itself rather than as an
>external PHP application.

I'm not sure what would be the advantage of incorporating the anything of
Metabase into a specific DBMS.  Maybe you could explain exactly what is
your point.


>I am comfortable with large PHP-based projects and use XML heavily, so
>I feel that I could probably help directly in the Metabase project but
>I am not sure what the long-term goals of the Metabase are:
>compatibility vs features and how that fits in with my needs.

>Any comments?

The ultimate point of goal Metabase is to minimize the risks of choice
database for PHP applications providing the highest API level portability
so you don't have to rewrite your applications if you switch databases.

For instance, I am about to release a bunch of components that do all sorts
of tasks that many PHP applications can benefit.  All these components can
be used with many different databases but you don't have to change your
application nor the components themselves.

PHP needs a good database abstraction package so applications and
components may interchange backend databases and developers may benefit
more from each other work.

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

On 01-Jul-00 08:57:13, you wrote:

>> >Wheter the underlying database supports it is irrelevant. If it is the
>> >logical schema for the designer, than it is up to the implementation
>> >driver to emulate the join criteria (sub-select, recursive) whatever.
>> >The point is that it is a naturally occuring relationship.
>>
>> I see, but please understand that is beyond the scope of Metabase.  An
>> higher level tool could let developers model their database in the way that
>> you suggest and then could output schema description files that Metabase
>> could parse and install. I'm afraid that stuffing all that in Metabase
>> would make it more bloated than most people need.
>>
>> If you want to start working on such higher level tool, just let me know
>> if you need any help.

>With most modeling tools (including ArgoUML) generating XMI as the
>interchange it may be more useful for Metabase to be able to parse that,
>or maybe XML Schema.

>But I'll keep your offer in mind!

I've been noting down a few other projects announce in Freshmeat that
attempt to achieve similar goals.  Take a look before you start anything.


From: freshd@...
Subject: UML2SQL 0.7.0 - tool to synchronize SQL databases with UML diagrams
Date: 15 Jun 2000 10:29:33 GMT

  application: UML2SQL 0.7.0
       author: Ingo Kegel <kingo@...>
      license: LGPL
     category: Development/Database

     homepage: http://freshmeat.net/redir/homepage/961063613/
     download: http://freshmeat.net/redir/download/961063613/

description:
UML2SQL is a java tool which synchronizes SQL databases with UML
diagrams. UML class diagrams can thus serve as authoritative
definitions of database catalogs. UML2SQL can be used together with a
UML design tool which is capable of producing XML. For the most generic
operations, only a JDBC driver is required for the SQL database. Vendor
specific DDL commands for unsupported databases can be easily
implemented by extending the DatabaseAdapter class.

Changes:
initial release

|> http://freshmeat.net/news/2000/06/15/961065054.html


From: freshd@...
Subject: xplain2sql 0.8.0 - An Xplain to SQL conversion tool.
Date: 1 Jul 2000 18:26:01 GMT

  application: xplain2sql 0.8.0
       author: Berend de Boer <berend@...>
      license: Eiffel Forum Freeware License
     category: Development/Database
      urgency: medium

     homepage: http://freshmeat.net/redir/homepage/950141364/
     download: http://freshmeat.net/redir/download/950141364/

description:
xplain2sql converts files from Xplain to SQL. It supports a very large
subset of Xplain, and it can convert from Xplain to Microsoft SQL
Server, DB/2, Inprise InterBase, PostgreSQL, MySQL, or ANSI-92 SQL. It
can also generate low-level Delphi/ADO middletier code. It compiles
without change on FreeBSD, BeOS, and NT.

Changes:
DB/2 support, fixes for various wrong SQL generation bugs (including an
import one when using extends), a new column rename operator `as',
support for Xplain per operator in get statements (i.e., you can sort
your results now), requirement of the Formatter library to compile, and
compile support with SmallEiffel and VisualEiffel.

|> http://freshmeat.net/news/2000/07/01/962475970.html


From: freshd@...
Subject: Alzabo 0.03a - Perl data modelling tool and RDBMS-OO mapper.
Date: 7 Jul 2000 19:53:05 GMT

  application: Alzabo 0.03a
       author: Dave Rolsky <autarch@...>
      license: GPL
     category: Development/Perl Modules

     homepage: http://freshmeat.net/redir/homepage/962987023/
     download: http://freshmeat.net/redir/download/962987023/

description:
Alzabo is a two-fold program. Its first function is as a data modelling
tool. Through either a schema creation interface or a custom Perl
program, it allows a programmer to create a set of schema, table,
column, etc. objects that represent a data model. Alzabo is also
capable of reverse engineering an existing data model. Its second
function is as a RDBMS to object mapping system. Once you have created
a schema, you can use Alzabo classes to access its data. These classes
offer a low level interface to common operations such as SQL SELECT,
INSERT, DELETE, and UPDATE commands.

Changes:
Initial Freshmeat announcement.

|> http://freshmeat.net/news/2000/07/07/962999611.html


From: freshd@...
Subject: ObjectArtist snapshot20000701 - A development tool to create
OO-Software with UML
Date: 9 Jul 2000 18:48:15 GMT

  application: ObjectArtist snapshot20000701
       author: Sven Daumann <SvenD@...>
      license: GPL
     category: Development/Environments
      urgency: low

     homepage: http://freshmeat.net/redir/homepage/927393111/
     download: http://freshmeat.net/redir/download/927393111/

description:
ObjectArtist is a development tool to create object-oriented software.
It uses UML diagrams for modeling and stores the models in XMI, an XML
based format.

Changes:
A rewrite of the Model-View-Controller architecture resulting in a
better repainting in JDK 1.2, and a change to Ant as the build tool.

|> http://freshmeat.net/news/2000/07/09/963168527.html






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