/ 
DBIx-Class-0.08250
River stage three • 349 direct dependents • 459 total dependents

Changes for version 0.08250 - 2013-04-29

  • New Features / Changes
    • Rewrite from scratch the result constructor codepath - many bugfixes and performance improvements (the current codebase is now capable of outperforming both DBIx::DataModel and Rose::DB::Object on some workloads). Some notable benefits:
      • Multiple has_many prefetch
      • Partial prefetch - you now can select only columns you are interested in, while preserving the collapse functionality (collapse is now exposed as a first-class API attribute)
      • Prefetch of resultsets with arbitrary order (RT#54949, RT#74024, RT#74584)
      • Prefetch no longer inserts right-side table order_by clauses (massively helps the deficient MySQL optimizer)
      • Prefetch with limit on right-side ordered resultsets now works correctly (via aggregated grouping)
      • No longer order the insides of a complex prefetch subquery, unless required to satisfy a limit
      • Stop erroneously considering order_by criteria from a join under distinct => 1 (the distinct should apply to the main source only)
    • Massively optimize codepath around ->cursor(), over 10x speedup on some iterating workloads.
    • Support standalone \[ $sql, $value ] in literal SQL with bind specifications: \[ '? + ?', 42, 69 ] is now equivalent to \[ '? + ?', [ {} => 42 ], [ {} => 69 ] ]
    • Changing the result_class of a ResultSet in progress is now explicitly forbidden. The behavior was undefined before, and would result in wildly differing outcomes depending on $rs attributes.
    • Deprecate returning of prefetched 'filter' rels as part of get_columns() and get_inflated_columns() data
    • Invoking get_inflated_columns() no longer fires get_columns() but instead retrieves data from individual non-inflatable columns via get_column()
    • Emit a warning on incorrect use of nullable columns within a primary key
    • Limited checks are performed on whether columns without declared is_nullable => 1 metadata do in fact sometimes fetch NULLs from the database (the check is currently very limited and is performed only on resultset collapse when the alternative is rather worse)
  • Fixes
    • Fix _dbi_attrs_for_bind() being called befor DBI has been loaded (regression in 0.08210)
    • Fix update/delete operations on resultsets *joining* the updated table failing on MySQL. Resolves oversights in the fixes for RT#81378 and RT#81897
    • Fix open cursors silently resetting when inherited across a fork or a thread
    • Properly support "MySQL-style" left-side group_by with prefetch
    • Fix $grouped_rs->get_column($col)->func($func) producing incorrect SQL (RT#81127)
    • Stop Sybase ASE storage from generating invalid SQL in subselects when a limit without offset is encountered
    • Even more robust behavior of GenericSubQuery limit dialect
    • Make sure deployment_statements() and cursor_class() are called on a resolved storage subclass
  • Misc
    • Fix tests failing due to unspecified resultset retrieval order (test suite now will pass with newest SQLite libs)

Documentation

DBIx::Class::Manual
Index of the Manual
DBIx::Class::Manual::Component
Developing DBIx::Class Components
DBIx::Class::Manual::Cookbook
Miscellaneous recipes
DBIx::Class::Manual::DocMap
What documentation do we have?
DBIx::Class::Manual::Example
Simple CD database example
DBIx::Class::Manual::FAQ
Frequently Asked Questions (in theory)
DBIx::Class::Manual::Features
A boatload of DBIx::Class features with links to respective documentation
DBIx::Class::Manual::Glossary
Clarification of terms used.
DBIx::Class::Manual::Intro
Introduction to DBIx::Class
DBIx::Class::Manual::Joining
Manual on joining tables with DBIx::Class
DBIx::Class::Manual::Reading
How to read and write DBIx::Class POD.
DBIx::Class::Manual::ResultClass
Representing a single result (row) from a DB query
DBIx::Class::Manual::Troubleshooting
Got a problem? Shoot it.
DBIx::Class::Storage::DBI::Replicated::Introduction
Minimum Need to Know
dbicadmin
utility for administrating DBIx::Class schemata

Modules

DBIx::Class
Extensible and flexible object <-> relational mapper.
DBIx::Class::AccessorGroup
See Class::Accessor::Grouped
DBIx::Class::Admin
Administration object for schemas
DBIx::Class::CDBICompat
Class::DBI Compatibility layer.
DBIx::Class::Carp
Provides advanced Carp::Clan-like warning functions for DBIx::Class internals
DBIx::Class::Core
Core set of DBIx::Class modules
DBIx::Class::Cursor
Abstract object representing a query cursor on a resultset.
DBIx::Class::DB
(DEPRECATED) classdata schema component
DBIx::Class::Exception
Exception objects for DBIx::Class
DBIx::Class::FilterColumn
Automatically convert column data
DBIx::Class::InflateColumn
Automatically create references from column data
DBIx::Class::InflateColumn::DateTime
Auto-create DateTime objects from date and datetime columns.
DBIx::Class::InflateColumn::File
DEPRECATED (superseded by DBIx::Class::InflateColumn::FS)
DBIx::Class::Optional::Dependencies
Optional module dependency specifications (for module authors)
DBIx::Class::Ordered
Modify the position of objects in an ordered list.
DBIx::Class::PK
Primary Key class
DBIx::Class::PK::Auto
Automatic primary key class
DBIx::Class::Relationship
Inter-table relationships
DBIx::Class::Relationship::Base
Inter-table relationships
DBIx::Class::ResultClass::HashRefInflator
Get raw hashrefs from a resultset
DBIx::Class::ResultSet
Represents a query used for fetching a set of results.
DBIx::Class::ResultSetColumn
helpful methods for messing with a single column of the resultset
DBIx::Class::ResultSetManager
scheduled for deletion in 09000
DBIx::Class::ResultSource
Result source object
DBIx::Class::ResultSource::Table
Table object
DBIx::Class::ResultSource::View
ResultSource object representing a view
DBIx::Class::ResultSourceHandle
Serializable pointers to ResultSource instances
DBIx::Class::ResultSourceProxy::Table
provides a classdata table object and method proxies
DBIx::Class::Row
Basic row methods
DBIx::Class::SQLMaker
An SQL::Abstract-based SQL maker class
DBIx::Class::SQLMaker::LimitDialects
SQL::Abstract::Limit-like functionality for DBIx::Class::SQLMaker
DBIx::Class::SQLMaker::OracleJoins
Pre-ANSI Joins-via-Where-Clause Syntax
DBIx::Class::Schema
composable schemas
DBIx::Class::Schema::Versioned
DBIx::Class::Schema plugin for Schema upgrades
DBIx::Class::Serialize::Storable
hooks for Storable nfreeze/thaw
DBIx::Class::StartupCheck
Run environment checks on startup
DBIx::Class::Storage
Generic Storage Handler
DBIx::Class::Storage::BlockRunner
Try running a block of code until success with a configurable retry logic
DBIx::Class::Storage::DBI
DBI storage handler
DBIx::Class::Storage::DBI::ACCESS
Support specific to MS Access
DBIx::Class::Storage::DBI::ADO
Support for DBD::ADO
DBIx::Class::Storage::DBI::ADO::MS_Jet
Support for MS Access over ADO
DBIx::Class::Storage::DBI::ADO::MS_Jet::Cursor
GUID Support for MS Access over ADO
DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server
Support for Microsoft SQL Server via DBD::ADO
DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server::Cursor
Remove trailing NULLs in binary data and normalize GUIDs for MSSQL over ADO
DBIx::Class::Storage::DBI::AutoCast
Storage component for RDBMS requiring explicit placeholder typing
DBIx::Class::Storage::DBI::Cursor
Object representing a query cursor on a resultset.
DBIx::Class::Storage::DBI::DB2
IBM DB2 support for DBIx::Class
DBIx::Class::Storage::DBI::Firebird
Driver for the Firebird RDBMS via DBD::Firebird
DBIx::Class::Storage::DBI::Firebird::Common
Driver Base Class for the Firebird RDBMS
DBIx::Class::Storage::DBI::IdentityInsert
Storage Component for Sybase ASE and MSSQL for Identity Inserts / Updates
DBIx::Class::Storage::DBI::Informix
Base Storage Class for Informix Support
DBIx::Class::Storage::DBI::InterBase
Driver for the Firebird RDBMS via DBD::InterBase
DBIx::Class::Storage::DBI::MSSQL
Base Class for Microsoft SQL Server support in DBIx::Class
DBIx::Class::Storage::DBI::NoBindVars
Sometime DBDs have poor to no support for bind variables
DBIx::Class::Storage::DBI::ODBC
Base class for ODBC drivers
DBIx::Class::Storage::DBI::ODBC::ACCESS
Support specific to MS Access over ODBC
DBIx::Class::Storage::DBI::ODBC::DB2_400_SQL
Support specific to DB2/400 over ODBC
DBIx::Class::Storage::DBI::ODBC::Firebird
Driver for using the Firebird RDBMS through ODBC
DBIx::Class::Storage::DBI::ODBC::Microsoft_SQL_Server
Support specific to Microsoft SQL Server over ODBC
DBIx::Class::Storage::DBI::ODBC::SQL_Anywhere
Driver for using Sybase SQL Anywhere through ODBC
DBIx::Class::Storage::DBI::Oracle
Base class for Oracle driver
DBIx::Class::Storage::DBI::Oracle::Generic
Oracle Support for DBIx::Class
DBIx::Class::Storage::DBI::Oracle::WhereJoins
Oracle joins in WHERE syntax support (instead of ANSI).
DBIx::Class::Storage::DBI::Pg
Automatic primary key class for PostgreSQL
DBIx::Class::Storage::DBI::Replicated
BETA Replicated database support
DBIx::Class::Storage::DBI::Replicated::Balancer
A Software Load Balancer
DBIx::Class::Storage::DBI::Replicated::Balancer::First
Just get the First Balancer
DBIx::Class::Storage::DBI::Replicated::Balancer::Random
A 'random' Balancer
DBIx::Class::Storage::DBI::Replicated::Pool
Manage a pool of replicants
DBIx::Class::Storage::DBI::Replicated::Replicant
A replicated DBI Storage Role
DBIx::Class::Storage::DBI::Replicated::WithDSN
A DBI Storage Role with DSN information in trace output
DBIx::Class::Storage::DBI::SQLAnywhere
Driver for SQL Anywhere
DBIx::Class::Storage::DBI::SQLAnywhere::Cursor
GUID Support for SQL Anywhere over DBD::SQLAnywhere
DBIx::Class::Storage::DBI::SQLite
Automatic primary key class for SQLite
DBIx::Class::Storage::DBI::Sybase
Base class for drivers using DBD::Sybase
DBIx::Class::Storage::DBI::Sybase::ASE
Sybase ASE SQL Server support for DBIx::Class
DBIx::Class::Storage::DBI::Sybase::ASE::NoBindVars
Storage::DBI subclass for Sybase ASE without placeholder support
DBIx::Class::Storage::DBI::Sybase::FreeTDS
Base class for drivers using DBD::Sybase over FreeTDS.
DBIx::Class::Storage::DBI::Sybase::MSSQL
(DEPRECATED) Legacy storage class for MSSQL via DBD::Sybase
DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server
Support for Microsoft SQL Server via DBD::Sybase
DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server::NoBindVars
Support for Microsoft SQL Server via DBD::Sybase without placeholders
DBIx::Class::Storage::DBI::UniqueIdentifier
Storage component for RDBMSes supporting GUID types
DBIx::Class::Storage::DBI::mysql
Storage::DBI class implementing MySQL specifics
DBIx::Class::Storage::Statistics
SQL Statistics
DBIx::Class::Storage::TxnScopeGuard
Scope-based transaction handling
DBIx::Class::UTF8Columns
Force UTF8 (Unicode) flag on columns (DEPRECATED)
SQL::Translator::Parser::DBIx::Class
Create a SQL::Translator schema from a DBIx::Class::Schema instance
SQL::Translator::Producer::DBIx::Class::File
DBIx::Class file producer

Examples

Other files