The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.

Changes for version 0.742

  • Added support for a more efficient subselect-based limit/offset implementation for queries that would otherwise have to be scanned through manually.
  • Added a column class for PostgreSQL's BYTEA column type.
  • Added support for DBI bind_param() attributes for all column types.
  • Fixed a bug in the test suite that could cause the TIME(9) column type test to fail in Postgres.
  • Fixed some POD formatting errors.

Documentation

A guided tour of the basics of Rose::DB::Object

Modules

Extensible, high performance RDBMS-OO mapper.
Memory cached object representation of a single row in a database table.
Provide missing metadata by convention.
A singleton convention manager that does nothing.
A mix-in class containing convenience methods for Rose::DB::Object.
Iterate over a series of Rose::DB::Objects.
Automatically create Rose::DB::Object subclasses for all the tables in a database.
Create object methods for arbitrary-precision numeric attributes for Rose::DB::Object-derived objects.
Create date-related methods for Rose::DB::Object-derived objects.
Create generic object methods for Rose::DB::Object-derived objects.
Create PostgreSQL-specific object methods for Rose::DB::Object-derived objects.
Create object methods related to Rose::DB::Object::Std-derived objects.
Create time-related methods for Rose::DB::Object-derived objects.
Fetch multiple Rose::DB::Object-derived objects from the database using complex queries.
Database object metadata.
Base class for database column metadata objects.
Big integer column metadata.
Big serial column metadata.
Binary large object column metadata.
Datetime year to fraction column metadata.
Datetime year to fraction(1) column metadata.
Datetime year to fraction(2) column metadata.
Datetime year to fraction(3) column metadata.
Datetime year to fraction(4) column metadata.
Datetime year to fraction(5) column metadata.
Datetime year to minute column metadata.
Datetime year to second column metadata.
Enumerated column metadata.
Seconds since the epoch column metadata.
Fractional seconds since the epoch column metadata.
Floating-point column metadata.
PostgreSQL BYTEA column metadata.
PostgreSQL CHKPASS column metadata.
Variable-length character column metadata.
Base class for table relationship metadata objects.
One to many table relationship metadata object.
Many to one table relationship metadata object.
One to many table relationship metadata object.
One to one table relationship metadata object.
A base class for mix-ins.
Build SQL queries on behalf of Rose::DB::Object::Manager.
Standardized object representation of a single row in a database table.
Memory cached standardized object representation of a single row in a database table.
Standardized database object metadata.
Utility functions for use in Rose::DB::Object subclasses and method makers.

Provides

in lib/Rose/DB/Object/Constants.pm
in lib/Rose/DB/Object/Metadata/Auto.pm
in lib/Rose/DB/Object/Metadata/Auto/Generic.pm
in lib/Rose/DB/Object/Metadata/Auto/Informix.pm
in lib/Rose/DB/Object/Metadata/Auto/MySQL.pm
in lib/Rose/DB/Object/Metadata/Auto/Pg.pm
in lib/Rose/DB/Object/Metadata/Auto/SQLite.pm
in lib/Rose/DB/Object/Metadata/ColumnList.pm
in lib/Rose/DB/Object/Metadata/MethodMaker.pm
in lib/Rose/DB/Object/Metadata/Object.pm
in lib/Rose/DB/Object/Metadata/Util.pm