On Wed, Sep 19, 2012 at 10:32:12AM -0700, gmh wrote: > > First off - thank you for such a cool piece of software. The ruote > workflow has such a rich toolset - it will save us tons of time no doubt. > > (...) > > If there is a possibility for the data in the doc column to be larger than > the 4000 limit, then the CLOB type will need to be supported. We > experimented by calling the '.read' method of the passed back <OCI8::CLOB> > object in storage.rb (extracting the text from the column). This seems to > work, but we are wondering if anyone else has already done this? And is > this really necessary if a simple VARCHAR2 type will be large enough?
Hello Geoff, welcome to the ruote mailing list! Yes, VARCHAR2 might be limited. Ruote-sequel naively encodes as JSON the documents and places them in the "doc" column, those 4000 bytes feel not that far. Maybe I could adapt ruote-sequel so that it calls #read before doing the JSON decode on the doc column (if the resulting object responds to #read). That'd make ruote-sequel adapted to your situation out of the box (though I wonder how one tells Sequel to use CLOB instead of VARCHAR2 when :text => true...) What do you think ? -- John Mettraux - http://lambda.io/jmettraux -- you received this message because you are subscribed to the "ruote users" group. to post : send email to [email protected] to unsubscribe : send email to [email protected] more options : http://groups.google.com/group/openwferu-users?hl=en
