DBIx-SearchBuilder

Changes for version 1.73 - 2022-12-08

Remove very old CVS headers from files
Standardize whitespace
Remove an unused cache parameter remaining from a previous refactor
Update a test to work around a change in numeric values returned on Postgres starting in version 14
Fix a doc typo
Fix a bind value issue with Limit on Postgres
Disable finding count in searches for older versions of MySQL and MariaDB that don't support window functions (OVER)
Truncate values before checking for changes to fix a bug where values bigger than a column would be inserted even when they were not changed

Changes for version 1.72_01 - 2022-09-20

Simplify count's internal logic to always use the "count_all" key
Fix Count method to always returns count in selected page
Support search and count in same query
Redo search only if ORDER/GROUP BY is really updated
Add bind values support for LIMIT clauses

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

DBIx::SearchBuilder::Util

Utility and convenience functions for DBIx::SearchBuilder

Examples

Other files

To install DBIx::SearchBuilder, copy and paste the appropriate command in to your terminal.

cpanm

cpanm DBIx::SearchBuilder

CPAN shell

perl -MCPAN -e shell
install DBIx::SearchBuilder

For more information on module installation, please visit the detailed CPAN module installation guide.

	Global
`s`	Focus search bar
`?`	Bring up this help dialog

	GitHub
`g` `p`	Go to pull requests
`g` `i`	go to github issues (only if github is preferred repository)

	POD
`g` `a`	Go to author
`g` `c`	Go to changes
`g` `i`	Go to issues
`g` `d`	Go to dist
`g` `r`	Go to repository/SCM
`g` `s`	Go to source
`g` `b`	Go to file browse

	Search terms
module: (e.g. module:Plugin)
distribution: (e.g. distribution:Dancer auth)
author: (e.g. author:SONGMU Redis)
version: (e.g. version:1.00)

Changes for version 1.73 - 2022-12-08

Changes for version 1.72_01 - 2022-09-20

Modules

Examples

Other files

Module Install Instructions