The Perl DBI is an object-oriented interface designed, developed, and maintained by Tim Bunce since 1994.
DBI borrows heavily from the ODBC design while remaining as Perl-ish as possible.
Two main objects and associated methods:
- Database handle
- Attributes: AutoCommit, RaiseError, PrintError
- connect(), disconnect()
- do(), prepare(), selectall_*()
- begin_work(), commit(), rollback()
- err(), errstr(), state()
- metadata methods
- Statement handle
- bind_param(), bind_param_inout(), bind_param_array()
- execute(), execute_array()
- fetchrow_*(), fetchall_*()
- bind_col(), bind_columns()
- err, errstr, state
- finish()