Community mailing list archives


Re: About Attachment File Location (again)

Antony Lesuisse (al)
- 01/31/15 07:33:59
 From a theorical point of view i would agree. But not from a pratical point 
of view.


- transcationals


- bloat the replication stream
- bloat the sql dumps
- break the unix file descriptor api open(2) read(2) lseek(2) you have to wrap 
db (pyscopg makes that easy under python with lobject)
- impossible to manipulate with unix tools

filestore as sha1 (git-like):

- non transactionnal


- quickly rsyncable (file are never touched except for unlink)
- space efficient rsnapshots
- esay to browse by a human
- easy to manipulate with unix tools for example you can easily do a:

find filestore/db -type f -exec file -b '{}' ';' | sort | uniq -c | sort -n

At the moment odoo attachments are limited by the worker memory so the main 
raison behind that choice was rsyncablility/rsnapshotability and avoid 
bloating backups dumps.

On 01/31/2015 12:13 PM, Christophe Combelles wrote:
> Le 31 janvier 2015 05:47:44 EET, Togar Hutabarat <> a écrit :
>>Hello Community!
>>Maybe many question similar with my question has been asked by a many
>>people in forums or Stackoverflow. But please allow me to ask again in
>>this community forum. My question: is there any possibility for Odoo to
>>save attachment directly into a file system directory (instead of
>>Another doubt about this: I know that we can configure FTP for Odoo
>>(module document_ftp), so we can browse/copy/open attachment by using
>>file explorer (Linux/Windows/iOS) or using any FTP client. Is that it
>>really store the file into FTP server? Or is Odoo just use FTP as a
>>emulation interface to access attachments? What we want is to make sure
>>Odoo not store attachment data into database that may increase database
>>size when we upload big files.
>   Storing big files in the database really is not a problem, if you use the right storage with a way to dump without attachments if needed :
> Not only it is no problem, but most of the time it's a far better solution to keep your data in a safe place.
> regards,
> Christophe
>>Really appreciate any answer.. Thanks,   *
>>Togar Parnaehan Hutabarat*  *Databit - Odoo Partner Indonesia*
>>Email    : [1]  Mobile   :
>>+62821-3079-8827  YM       : [2]   Skype
>> : togar.hutabarat
>>Twitter  : @togarhutabarat
>>Post to:
> _______________________________________________
> Mailing-List:
> Post to:
> Unsubscribe: