Changes for version 0.08116 - 2010-02-05

  • Perl 5.8.1 is now the minimum supported version
  • Massive optimization of the join resolution code - now joins will be removed from the resulting SQL if DBIC can prove they are not referenced by anything
  • Subqueries no longer marked experimental
  • Support for Informix RDBMS (limit/offset and auto-inc columns)
  • Support for Sybase SQLAnywhere, both native and via ODBC
  • might_have/has_one now warn if applied calling class's column has is_nullable set to true.
  • Fixed regression in deploy() with a {sources} table limit applied (RT#52812)
  • Views without a view_definition will throw an exception when parsed by SQL::Translator::Parser::DBIx::Class
  • Stop the SQLT parser from auto-adding indexes identical to the Primary Key
  • InflateColumn::DateTime refactoring to allow fine grained method overloads
  • Fix ResultSetColumn improperly selecting more than the requested column when +columns/+select is present
  • Fix failure when update/delete of resultsets with complex WHERE SQLA structures
  • Fix regression in context sensitiveness of deployment_statements
  • Fix regression resulting in overcomplicated query on search_related from prefetching resultsets
  • Fix regression on all-null returning searches (properly switch LEFT JOIN to JOIN in order to distinguish between both cases)
  • Fix regression in groupedresultset count() used on strict-mode MySQL connections
  • Better isolation of RNO-limited queries from the rest of a prefetching resultset
  • New MSSQL specific resultset attribute to allow hacky ordered subquery support
  • Fix nasty schema/dbhandle leak due to SQL::Translator
  • Initial implementation of a mechanism for Schema::Version to apply multiple step upgrades
  • Fix regression on externally supplied $dbh with AutoCommit=0
  • FAQ "Custom methods in Result classes"
  • Cookbook POD fix for add_drop_table instead of add_drop_tables
  • Schema POD improvement for dclone

Documentation

Index of the Manual
Developing DBIx::Class Components
Miscellaneous recipes
What documentation do we have?
Simple CD database example
Frequently Asked Questions (in theory)
Clarification of terms used.
Introduction to DBIx::Class
Manual on joining tables with DBIx::Class
How to read and write DBIx::Class POD.
Got a problem? Shoot it.
Execute operations upon DBIx::Class objects.

Modules

Extensible and flexible object <-> relational mapper.
See Class::Accessor::Grouped
Class::DBI Compatibility layer.
Emulates Class::DBI::AbstractSearch
Emulates the behavior of Class::DBI where the object can be accessed as a hash of columns.
Emulates Class::DBI->copy($new_id)
Emulates the extra behaviors of the Class::DBI search iterator.
Defines empty methods for object indexing. They do nothing
Emulate the Class::DBI::Relationship object returned from meta_info()
Emulate has_a(), has_many(), might_have() and meta_info()
Core set of DBIx::Class modules
Abstract object representing a query cursor on a resultset.
(DEPRECATED) classdata schema component
Exception objects for DBIx::Class
Automatically create references from column data
Auto-create DateTime objects from date and datetime columns.
map files from the Database to the filesystem.
Modify the position of objects in an ordered list.
Primary Key class
Automatic primary key class
Inter-table relationships
Inter-table relationships
Get raw hashrefs from a resultset
Represents a query used for fetching a set of results.
helpful methods for messing with a single column of the resultset
scheduled for deletion in 09000
Result source object
ResultSource object representing a view
Decouple Rows/ResultSets objects from their Source objects
provides a classdata table object and method proxies
Basic row methods
composable schemas
DBIx::Class::Schema plugin for Schema upgrades
hooks for Storable freeze/thaw
Run environment checks on startup
Generic Storage Handler
DBI storage handler
Support for Microsoft SQL Server via DBD::ADO
Storage component for RDBMS choking on count(*)
Storage component for RDBMS requiring explicit placeholder typing
Object representing a query cursor on a resultset.
Automatic primary key class for DB2
Base Storage Class for INFORMIX Support
Base Class for Microsoft SQL Server support in DBIx::Class
Storage component for RDBMS supporting multicolumn in clauses
Sometime DBDs have poor to no support for bind variables
Base class for ODBC drivers
Support specific to MS Access over ODBC
Support specific to DB2/400 over ODBC
Support specific to Microsoft SQL Server over ODBC
Driver for using Sybase SQL Anywhere through ODBC
Base class for Oracle driver
Oracle Support for DBIx::Class
Oracle joins in WHERE syntax support (instead of ANSI).
Automatic primary key class for PostgreSQL
BETA Replicated database support
Manage a pool of replicants
A replicated DBI Storage Role
A DBI Storage Role with DSN information in trace output
Role to add a query counter
Driver for Sybase SQL Anywhere
Automatic primary key class for SQLite
Base class for drivers using DBD::Sybase
Sybase ASE SQL Server support for DBIx::Class
Storage::DBI subclass for Sybase ASE without placeholder support
(DEPRECATED) Legacy storage class for MSSQL via DBD::Sybase
Support for Microsoft SQL Server via DBD::Sybase
Support for Microsoft SQL Server via DBD::Sybase without placeholders
Storage::DBI class implementing MySQL specifics
Scope-based transaction handling
Force UTF8 (Unicode) flag on columns
Create a SQL::Translator schema from a DBIx::Class::Schema instance

Provides

in lib/DBIx/Class/CDBICompat/Iterator.pm