[Dbix-class] Large Oracle CLOBs

[Daniel J. Luke]

On Jan 2, 2012, at 6:25 AM, Peter Rabbitson wrote:
> 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


I strongly prefer mailing list discussions (if only because they tend to get archived and show up in future google searches), however I can try to join for a while tomorrow to discuss (I'm not going to turn down free advice ;-) ).

THanks.
--
Daniel J. Luke                                                                   
+========================================================+                        
| *---------------- dluke at geeklair.net ----------------* |                          
| *-------------- http://www.geeklair.net -------------* |                          
+========================================================+                        
|   Opinions expressed are mine and do not necessarily   |                          
|          reflect the opinions of my employer.          |                          
+========================================================+