[Dbix-class] Large Oracle CLOBs

Peter Rabbitson rabbit+dbic at rabbit.us
Mon Jan 2 11:25:46 GMT 2012


Daniel J. Luke wrote:
> I've got an existing database that I'm (mostly) successfully using DBIx::Class with. There's a table with large CLOBs, though that's giving me some issues.
> 
> I can set LongReadLen to some huge value and things work (for now), but I know people are going to be pushing bigger files into the DB. I don't really have the option of just using the FS (which is what I would prefer), so I need to be able to handle arbitrarily large CLOBs (or BLOBs).
> 
> It seems like this is something others would have already solved, but perhaps my CPAN searching skills aren't very good. Something like DBIx::BLOB::Handle (but implemented as an InflateColumn or FilterColumn) would probably be perfect. For my needs, it would be fine to use DBD::Oracle-specific calls.
> 
> Ideally, calling code would get a filehandle that underneath is doing (ora_auto_lob = 0) ora_lob_read/ora_lob_write/ora_lob_append operations.
> 
> Any pointers, or thoughts before I start coding? I was pretty surprised I didn't find something that already does this in CPAN.
> 

Any chance you could join us on IRC[1]? There are several approaches,
would go much quicker if we can discuss them "live". I am 'ribasushi'
over there. If not possible - let me know and we'll continue by email

Cheers

[1] http://chat.mibbit.com/#dbix-class@irc.perl.org



More information about the DBIx-Class mailing list