[Dbix-class] Accessing $dbh for blobs/large-objects

John Napiorkowski jjn1056 at yahoo.com
Tue May 9 11:25:31 CEST 2006


I've only been using this toolkit for about a week,
but I am also running Postgres8.1 and had had no
trouble accessing BLOB type fields using a bytea data
type and the normal DBIx accessors, like
$"result_row->blob".  However I haven't tried to store
megabytes of stuff yet.  So I think it 'just works'
the way you might hope, although I am sure someone
with more experience on the system will have more
informed thoughts than I.


--- Matt S Trout <dbix-class at trout.me.uk> wrote:

> Toby Corkindale wrote:
> > Hi,
> > I'm trying to do some work with large objects
> (blobs) in PostgreSQL, via a
> > DBIx::Class::Schema-based database.
> > Is this the correct way to get at the $dbh to use?
> > my $dbh = $c->model('DB')->schema->storage->_dbh;
> No, ->dbh is the method you'd want.
> More importantly, why do you need to get at the dbh
> for this anyway?
> _______________________________________________
> List:
> Wiki: http://dbix-class.shadowcatsystems.co.uk/
> IRC: irc.perl.org#dbix-class
> SVN:

Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 

More information about the Dbix-class mailing list