This module is intended to give easier portability to Perl database application by providing a database independant unique ID generator. This way, an application developer is not bound to use his database's SEQUENCE or auto_increment thus making his ...

DBIx::OracleSequence is an object oriented interface to Oracle Sequences via DBI. A sequence is an Oracle database object from which multiple users may generate unique integers. You might use sequences to automatically generate primary key values. Se...

The "DBIx::MySQLSequence" package implements an emulation layer that provides "real" sequences on MySQL. The module works by creating a "sequence table", a single table where each record represents a single sequence, and performing some "magic" MySQL...

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::Easy is an easy to use DBI interface. Currently the Pg, mSQL, mysql, Sybase, ODBC and XBase drivers are supported....

This package implements class "DBIx::Repgen", which is simple report generator from data received from relational database by some select-statement. Such a report can contain hyerarchical grouping by field values, record counters and cumulative total...

This library makes it easy to spin up a temporary database server for any supported driver. PostgreSQL and MySQL are the initially supported drivers....

The "DBIx::Perlish" module provides the ability to work with databases supported by the "DBI" module using Perl's own syntax for four most common operations: SELECT, UPDATE, DELETE, and INSERT. By using "DBIx::Perlish", you can write most of your dat...

DBIx::Threaded provides a subclass of DBI that provides wrappers for standard DBI objects to permit them to be used by multiple threads. Due to the limitations of threading and tied objects in Perl 5, DBI (as of version 1.48), does not permit DBI-gen...

DBIx::Recordset is a perl module for abstraction and simplification of database access. The goal is to make standard database access (select/insert/update/delete) easier to handle and independend of the underlying DBMS. Special attention is made on w...

DBIx::SQLEngine is the latest generation of a toolkit used by the authors for several years to develop business data applications. Its goal is to simplify dynamic query execution and to minimize cross-RDMS portability issues. Layered Class Framework ...

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...

This is a DBIx::Class component that adds a few methods to your DBIx::Class::Schema object. These methods make it much easier to create data for testing purposes (though, obviously, it's not limited to just test data). Alternately, it can be used as ...

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::Class::Candy" is a simple sugar layer for definition of DBIx::Class results. Note that it may later be expanded to add sugar for more "DBIx::Class" related things. By default "DBIx::Class::Candy": * turns on strict and warnings * sets your par...

See DBIx::IO....

Bulk insert many db rows using a single INSERT INTO statement, e.g. INSERT INTO book (author, publication_date, title) VALUES ( ?, ?, ? ), ( ?, ?, ? ); Restrictions All the hashrefs with row data should be shaped the same, i.e. have the same keys. Yo...

This module implements a "Nested Set" parent/child tree, and is focused (at least in my mind) towards offering methods that make developing web applications easier. It should be generally useful, though. See the "SEE ALSO" section for resources that ...

DBIx::MyParsePP uses the "sql_yacc.yy" grammar from the MySQL source to parse SQL strings. A parse tree is produced which contains one branch for every rule encountered during parsing. This means that very deep trees can be produced where only certai...