>-----Oorspronkelijk bericht----- >Van: [EMAIL PROTECTED] >[mailto:owner-developers@;mmbase.org]Namens Pierre van Rooden >Verzonden: vrijdag 4 januari 2002 14:41 >Aan: [EMAIL PROTECTED] >Onderwerp: Blob as File > > >I delved into the code that enables MMBase to store blobs as files, >rather than in the database. >The current implementation only works for MySQL/Hypersonic (nor Oracle, >posrgressQL, and Informix), but that is not really what troubled me. >The problem I had is that I wanted to store blobs as files only for a >certain type of object (pdf files), rather than ALL blobs of ALL types. >So I went about changing code to enable this (fixing a few bugs in the >process, i.e. you couldn't change blob fields). > >It now seems to work: by setting the 'blobdatadir' property in a >builderfile, you indicate to store blobs as files in the indicated >directory. As I wrote, this only works for MySQL and Hypersonic. > >I wonder what people feel about this solution? >It is a bit more complex than the original solution (which stores all >blobs as files), but enables you to add builder which use file-stored >blobs to an existing cloud. Very useful, I thought, if you only want to >store files for certain types of attachments, audio/video, and you can't >be bothered to drop and recreate a cloud holding 1000+ images... > >The source of the new databasesupport class is at: > >http://web.omroep.nl/mmbase/tmp/MMSQL92Node.java > >your opinions please... > >Pierre >
I like the idea but its handy to keep all the changes to the builder file incheck so we know what is needed for apps2.0 also. Maybe we need a maintainer for some of these files ? Daniel.
