[Dbix-class] Accessing $dbh for blobs/large-objects
jesper at krogh.cc
Tue May 9 11:33:45 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.
Storing data to BYTEA does _not_ work currently. Retrieving works
flawlessly, since there is not changes to be done. (perldoc DBD::Pg)
For storing BYTEA, I currently add a method to the individual class that
does the magic on the database-handle. Works flawlessly and gives me
of the BYTEA-columns too, which (I think) is generally desireable.
More information about the Dbix-class