Forum OpenACS Development: Re: revival of the blobs
2: Re: revival of the blobs (response to 1)
Posted by Gustaf Neumann on 01/08/16 02:36 PM
I should add that i would not recommend writing new applications with blobs in the OpenACS content repository. In most quality dimensions the storage type "file" is better suited. The mentioned changes help admins to make old data again available to users, and to convert data.
I wonder if we should keep the lob interface for the content repository, or to write a conversion script to turn lob-entries into file-entries and drop the interface afterwards. However, i am not sure about the state/necessity of lobs in oracle.
3: Re: revival of the blobs (response to 2)
Posted by Antonio Pisano on 01/08/16 05:00 PM
Lobs have pros and cons, but in my humble personal experience, they are more a pain than a joy.
My 2 cents would be to progressively drop lobs support in content repository, as this would also be more portable between the two DBMSs (and easier to maintain in general).