[rt-users] Attachments table of RT's Mysql database

[Schincke, Keith D. (JSC-IT)[MEI]]

You could do that or just have 'ondisk' be a new encoding type added at
the end of the list. 
The Content field of the data base could store the path to the file
relative to a config option.

I would suggest a file size threshold option if RT starts using the file
system to store attachements. 

The folowing config options could be added:
Set( $AttachmentLocation, 'indb'|'ondisk'|'size' ) ;
Set( $AttachmentDiskStorageThreshhold, 4096 ) ;
Set( $AttachmentDiskPath, '/some/location' ) ;

Keith

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Boris
Lytochkin
Sent: Wednesday, August 08, 2007 9:48 AM
To: Jesse Vincent
Cc: rt-users at lists.bestpractical.com
Subject: Re[4]: [rt-users] Attachments table of RT's Mysql database

Wednesday, August 8, 2007, 6:22:31 PM, you wrote:

> This might be a good place to use the ContentEncoding field to 
> describe an 'ondisk' encoding.

How do you expect to use this filed?
Something like '(ondisk|inDB),(base64|quoted-printable|...)'?


> On Aug 8, 2007, at 5:17 AM, Boris Lytochkin wrote:

>> Wiki would be enough, but there is a problem in current patch state:
>> it uses special constant string inplace of real content to indicate 
>> that file is located out of DB.
>> Right way is to use flag in table. I do not think that changing 
>> scheme  witch patching is a good idea, that is why this patch must be

>> merged into RT.

> This might be a good place to use the ContentEncoding field to 
> describe an 'ondisk' encoding.

> -jesse



--
Best regards,
 Boris Lytochkin
mailto:boris.lytochkin at e-port.ru

_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com Commercial support:
sales at bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com