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


DBIx::Class::ResultClass::HashRefInflator - Get raw hashrefs from a resultset


 use DBIx::Class::ResultClass::HashRefInflator;

 my $rs = $schema->resultset('CD');
 while (my $hashref = $rs->next) {

  OR as an attribute:

 my $rs = $schema->resultset('CD')->search({}, {
   result_class => 'DBIx::Class::ResultClass::HashRefInflator',
 while (my $hashref = $rs->next) {


DBIx::Class is faster than older ORMs like Class::DBI but it still isn't designed primarily for speed. Sometimes you need to quickly retrieve the data from a massive resultset, while skipping the creation of fancy result objects. Specifying this class as a result_class for a resultset will change $rs->next to return a plain data hash-ref (or a list of such hash-refs if $rs->all is used).

There are two ways of applying this class to a resultset:

  • Specify $rs->result_class on a specific resultset to affect only that resultset (and any chained off of it); or

  • Specify __PACKAGE__->result_class on your source object to force all uses of that result source to be inflated to hash-refs - this approach is not recommended.



Inflates the result and prefetched data into a hash-ref (invoked by DBIx::Class::ResultSet)


  • This will not work for relationships that have been prefetched. Consider the following:

     my $artist = $artitsts_rs->search({}, {prefetch => 'cds' })->first;
     my $cds = $artist->cds;
     my $first = $cds->first;

    $first will not be a hashref, it will be a normal CD row since HashRefInflator only affects resultsets at inflation time, and prefetch causes relations to be inflated when the master $artist row is inflated.

  • Column value inflation, e.g., using modules like DBIx::Class::InflateColumn::DateTime, is not performed. The returned hash contains the raw database values.


Check the list of additional DBIC resources.


This module is free software copyright by the DBIx::Class (DBIC) authors. You can redistribute it and/or modify it under the same terms as the DBIx::Class library.