Introduction "DBIx::DataModel" is a framework for building Perl abstractions (classes, objects and methods) that interact with relational database management systems (RDBMS). Of course the ubiquitous DBI module is used as a basic layer for communicat...

• DBIx::DataModel::Meta - meta-information for DBIx::DataModel
• DBIx::DataModel::Source - Abstract parent for Table and Join
• DBIx::DataModel::Statement - DBIx::DataModel statement objects
• 26 more results from DBIx-DataModel »

DBIx::Replicate is a perl module that incrementally copies SQL tables using "DBI" connections. The granuality and speed of the copy can be controlled....

• DBIx::Replicate - Synchornizes an SQL table to anther table
• DBIx-Replicate-0.04/lib/DBIx/Replicate/Strategy/CopyBy.pm
• lib/DBIx/Replicate/Node.pm
• 11 more results from DBIx-Replicate »

A Lazy (and easily replaceable) DB abstraction layer. In no way a new approach, rather an easy one. You should probably use DBIx::Class anyway. Heh. What does that mean? DBIx::LazyMethod uses AUTOLOAD to create methods and statement handles based on ...

• SomeDB - DBIx::LazyMethod inheritance example

This module implements create_database and drop_database functions for databases. It aims to provide a common interface to database creation and deletion regardless of the actual database being used. Currently supported databases are MySQL and Postgr...

• DBIx::DataSource::Pg - PostgreSQL driver for DBIx::DataSource
• DBIx::DataSource::mysql - MySQL driver for DBIx::DataSource
• DBIx::DataSource::Driver - Driver Writer's Guide and base class

This module can be used instead of the DBI module. For each SQL command that is prepared (both using $dbh->prepare and via do, selectall_* and the like) it prepends a /* */ style comment containing information about file and line that called that pre...

The module DBIx::FileSystem offers you a filesystem like view to database tables. To interact with the database tables, FileSystem implements: - An access class to read the data edited by the shell. - A user interface as a command line shell which of...

Represents a database connection handler. It provides simple interface to managing database connections with the all related operations wrapped in the different sql handlers. $connection = DBIx::Connection->connection('my_connection_name'); eval { $c...

• DBIx::SQLHandler - Sql statement handler.
• DBIx::PLSQLHandler - PL/SQL procedural language handler.
• DBIx::QueryCursor - Database cursor handler
• 6 more results from DBIx-Connection »

"DBIx::Table2Hash" is a pure Perl module. This module reads a database table and stores keys and values in a hash. The aim is to create a hash which is a simple look-up table. To this end, the module allows the key_column to point to an SQL expressio...

"DBIx::Hash2Table" is a pure Perl module. This module saves a hash ref into an existing database table of at least 3 columns. Each row in the table will consist of these 3 columns, at least: id (row number), parent's id, and the value of a hash key. ...

This module can copy record(s) while maintaining referential integrity within a database. The "copy" method is all that's needed. It's useful for copying related record(s) and assigning a new key value to the new record(s). You can define all of the ...

DBIx::SQLCrosstab produces a SQL query to interrogate a database and generate a cross-tabulation report. The amount of parameters needed to achieve the result is kept to a minimum. You need to indicate which columns and rows to cross and from which t...

• DBIx::SQLCrosstab::Format - Formats results created by DBIx::SQLCrosstab

"DBIx::Transaction" is a wrapper around DBI that helps you manage your database transactions. It pays attention to nested transactions (having a begin_work/commit..rollback inside if another begin_work/commit..rollback) and the AutoCommit attribute o...

• DBIx::Transaction::st - Statement handle when running under DBIx::Transaction
• DBIx::Transaction::db - Database handle that is aware of nested transactions
• lib/DBIx/Transaction.pm

This module helps you to make factory method for inserting data into database. You can use this as fixture replacement....

• DBIx::DataFactory::Type - the class for defining the rule of inserting data.
• lib/DBIx/DataFactory/Type/Str.pm
• lib/DBIx/DataFactory/Type/Set.pm
• 2 more results from DBIx-DataFactory »

DBIx::AssertIndex is run explain with SELECT SQL and detect query without any index. Works only DBD::mysql....

This module tries to provide a fast and simple (but very configurable) interface for taking a set of data and loading it into a database table. Common uses would be to take data from a file (like a CSV) and load it into a SQLite table. (For that spec...

DBIx::XHTML_Table is a DBI extension that creates an HTML table from a database query result set. It was created to fill the gap between fetching data from a database and transforming that data into a web browser renderable table. DBIx::XHTML_Table i...

This module is based on DBIx::Abstract, but is much simpler. It also doesn't deviate from the DBI interface as much as DBIx::Abstract does. The main similarity between DBIx::AbstractLite and DBIx::Abstract is in the select method. Unlike Abstract, Ab...

"DBIx::HA" is a High Availability module for "DBI". It is implemented by overloading the DBI "connect", "prepare" and "execute" methods and can be seamlessly used without code modification except for initialization. "DBIx::HA" also works seamlessly w...

Methods are provided to perform basic database I/O via DBI without having to embed SQL in your programs. Records are normally passed in and out in the form of hash references where keys of the hash represent columns (ALWAYS UPPER CASE), and the value...

• DBIx::IO::mysqlIO - DBIx::IO driver for MySQL
• DBIx::IO::OracleIO - DBIx::IO driver for Oracle
• DBIx::IO::OracleLib - General helper functions and constants to support the DBIx::IO Oracle driver
• 5 more results from DBIx-IO »