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.
--
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
