PHP database abstraction driver request poll
| From: | Manuel Lemos | Date: | Wed, 02 Aug 2000 08:00:03 +0000 |
| Subject: | PHP database abstraction driver request poll | ||
| Groups: | php.db php.general | ||
| Request: | Send a blank email to php-general+get-9641@lists.php.net to get a copy of this message | ||
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@acm.org
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--