The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.
 / 
DBIx-SearchBuilder-1.57
River stage one • 3 direct dependents • 3 total dependents
++

Changes for version 1.57 - 2010-09-04

  • INCOMPATIBLE CHANGE: NextPage and PrevPage were adding rows from the previous page. Jesse claims that when he wrote this code, he was 20 years old and it seemed like a good idea at the time.
  • When logging queries, include full stack trace
  • support $sb->NewAlias( 'table' => 'LEFT' );
  • allow join to depend on nothing
  • catch cases when there are more closing parens then should be
  • Oracle: Use ROW_NUMBER() to propagate row ordering from inside the DISTINCT
  • Various performance improvements through small internal refactorings
  • Implemented 'sub Fields' on Oracle
  • unify case insensitive characters to avoid using LOWER() in some cases
  • We now RedoSearch when RowsPerPage is changed
  • No longer RedoSearch if FirstRow is called, but is not actually changed
  • Document all paging functions and test them
  • handle LOWER() in redundant LEFT joins optimizer, for Oracle and may be Pg
  • Make debugging problems easier by passing errors back https://rt.cpan.org/Ticket/Display.html?id=55203
  • fix Record->PrimaryKeys, field names in values hash are lc'ed https://rt.cpan.org/Ticket/Display.html?id=18280
  • doc updates and cleanups

Modules

DBIx::SearchBuilder
Encapsulate SQL queries and rows in simple perl objects
DBIx::SearchBuilder::Handle
Perl extension which is a generic DBI handle
DBIx::SearchBuilder::Handle::Informix
An Informix specific Handle object
DBIx::SearchBuilder::Handle::ODBC
An ODBC specific Handle object
DBIx::SearchBuilder::Handle::Oracle
An oracle specific Handle object
DBIx::SearchBuilder::Handle::Pg
A Postgres specific Handle object
DBIx::SearchBuilder::Handle::SQLite
A SQLite specific Handle object
DBIx::SearchBuilder::Handle::Sybase
a Sybase specific Handle object
DBIx::SearchBuilder::Handle::mysql
A mysql specific Handle object
DBIx::SearchBuilder::Handle::mysqlPP
A mysql specific Handle object
DBIx::SearchBuilder::Record
Superclass for records loaded by SearchBuilder
DBIx::SearchBuilder::Record::Cachable
Records with caching behavior
DBIx::SearchBuilder::SchemaGenerator
Generate table schemas from DBIx::SearchBuilder records
DBIx::SearchBuilder::Union
Deal with multiple SearchBuilder result sets as one
DBIx::SearchBuilder::Unique
Ensure uniqueness of records in a collection

Examples

Other files