Tie::DBI is a perl module implementing Tie hash to a DBI handle.
mysql-genocide helps you play with big MySQL processlists. It can filter it
using different criterias like execution time, query type, user or regexp
matching of the SQL query etc. Actions can then be peformed on the result
like killing, sorting or generating statistics.
This module is for reading and writing a common variation of character
separated data.
PEAR::DB is a database abstraction layer providing:
* an OO-style query API
* portability features that make programs written for one DBMS work
with other DBMS's
* a DSN (data source name) format for specifying database servers
* prepare/execute (bind) emulation for databases that don't support
it natively
* a result object for each query response
* portable error codes
* sequence emulation
* sequential and non-sequential row fetching as well as bulk fetching
* formats fetched rows as associative arrays, ordered arrays or objects
* row limit support
* transactions support
* table information interface
* DocBook and phpDocumentor API documentation
Drivers for the following extensions pass the complete test suite and
provide interchangeability when all of DB's portability options are
enabled: fbsql, ibase, informix, msql, mssql, mysql, mysqli, oci8,
odbc, pgsql, sqlite and sybase.
PEAR::DBA is a wrapper for the php DBA functions. It includes a file-based
emulator and provides a uniform, object-based interface for the
Berkeley-style database systems.
Table management extension to DBA
PEAR::DB_DataObject performs 2 tasks:
1. Builds SQL statements based on the objects vars and the builder methods.
2. acts as a datastore for a table row.
The core class is designed to be extended for each of your tables so that you
put the data logic inside the data classes.
included is a Generator to make your configuration files and your base classes.
DB_Pager retrieve and return information of database result sets.
This class handles all the stuff needed for displaying
paginated results from a database query of Pear DB.
including fetching only the needed rows and giving extensive information
for helping build an HTML or GTK query result display.
PEAR::DB_QueryTool is an OO-abstraction to the SQL-Query language, it provides
methods such as setWhere, setOrder, setGroup, setJoin, etc. to easily build
queries.
It also provides an easy to learn interface that interacts nicely with
HTML-forms using arrays that contain the column data, that shall be
updated/added in a DB. This package bases on an SQL-Builder which lets you
easily build SQL-Statements and execute them.
PEAR::DB_Table builds on PEAR DB to abstract datatypes and automate table
creation, data validation, insert, update, delete, and select; combines
these with PEAR::HTML_QuickForm to automatically generate input forms
that match the table column definitions.