NAME

DBX - Perl extension to simplify and enhance the DBI with minimal overhead

SYNOPSIS

            

              
              
 use DBX;
 $conn = DBX->mysql("database=test;host=localhost;", "", "");
 $rs = $conn->query("SELECT * FROM test");
 while($rs)
 {
print $rs->field("client") . "\n";
$rs->field("client", "test");
$rs->move_next;
 }
            
          

ABSTRACT

            

              
              
Abstracts the DBI by providing easy-to-use wrappers.
            
          

DESCRIPTION

The DBX family of modules provides a layer of abstraction over the DBI. The DBX provides a simple cursor system, and a simple field retrieval and updating system.

The DBX module exports no subroutines. To connect to a data source, use the following code:

            

              
              
use DBX;
my $conn = DBX->mysql("database=test;host=localhost;", "", "");
            
          

Simply replace mysql with the name of the DBD driver you want to use. You should not include "dbi:mysql:" in the connection string; DBX specifies this automatically.

In the above code, $conn is a DBX::Connection object, which can be used to issue queries on the data source. DBX queries are handled by DBX::Recordset.

DEPENDENCIES

Requires the DBI module and appropriate DBD drivers.

TODO

Random-access cursors

delete and add functions

Better error-handling

Query caching

SEE ALSO

DBI, DBX::Recordset, DBX::Connection

AUTHOR

Bill Atkins, <dbxNOSPAM@batkins.com>

COPYRIGHT AND LICENSE

Copyright 2003 by Bill Atkins

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.