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 +========================================================+ | *---------------- dl...@geeklair.net ----------------* | | *-------------- http://www.geeklair.net -------------* | +========================================================+ | Opinions expressed are mine and do not necessarily | | reflect the opinions of my employer. | +========================================================+ _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk