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


DBX documentation  | view source Contained in the DBX distribution.

Index


NAME

Top

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

SYNOPSIS

Top

  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

Top

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

DESCRIPTION

Top

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

Top

Requires the DBI module and appropriate DBD drivers.

TODO

Top

Random-access cursors
delete and add functions
Better error-handling
Query caching

SEE ALSO

Top

DBI, DBX::Recordset, DBX::Connection

AUTHOR

Top

Bill Atkins, <dbxNOSPAM@batkins.com>

COPYRIGHT AND LICENSE

Top


DBX documentation  | view source Contained in the DBX distribution.