hi,
>
> maybe its dead off-topic, but as it's 'offered' as an embperl
> complement, I'd like to know about your experiences in using
> DBIx::Recordset . I'm currently using a DBI with DBD::mysql and Tie::DBI
> for 'quicky' access and pure DBI for real work.
>
> does it offer any advantage? I read the manpage and it looked like a
> Tie::DBI twin, with maybe some magic ties with embperl (that little
> magic that saves the day).
>
Then you should read it a second time! DBIx::Recordset offers much more then
simply tieing a database table to hash or array. It's a database abtraction
layer above DBI and it simplify database access.
Read
http://perl.apache.org/embperl/Intrors.pod.cont.html (or
http://www.heise.de/ix/artikel/1999/09/137/ for the german version) for an
Introduction. I append you the list of the features of DBIx::Recordset, to
get an first impression.
Gerald
The main features of DBIx::Recordset are:
- it has a compact interface, normaly only one function call is necessary
for setup and data retrival/inseration/deletion
- it takes care about type conversion and quoting
- it is able to access/modify tables via arrays and hashs
- it can automaticly create sub-objects for tables which are logical linked
together
- it can automatily create joins based on logical links
- it has input/output filters on a per field/per type basis
- it can create WHERE expression from a hash, which is especially usefull in
a cgi environement, where you can simply pass all paramters posted to your
cgi
script to DBIx::Recordset and DBIx::Recordset creates an corresponding
SELECT.
- it can create previous/next buttons for html output
- it works together with HTML::Embperl for easily genration of HTML output
- it has an own database abtraction class DBIx::Compat which gives all the
necessary information, so that DBIx::Recordset is able to work with
different database systems
- The new class DBIx::Database is able to retrieve and store meta infomation
of the database in a centralised location, which can be used for later
setup. This is also usefull when running under mod_perl, because you can
do
all the setup and configuration work at webserver startup time, speeding
up
your scripts when a actual request is processed.
-------------------------------------------------------------
Gerald Richter ecos electronic communication services gmbh
Internetconnect * Webserver/-design/-datenbanken * Consulting
Post: Tulpenstrasse 5 D-55276 Dienheim b. Mainz
E-Mail: richter@ecos.de Voice: +49 6133 925151
WWW:
http://www.ecos.de Fax: +49 6133 925152
-------------------------------------------------------------