Community mailing list archives

community@mail.odoo.com

Re: About Attachment File Location (again)

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

LOBs:

- transcationals

but

- 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

but

- 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 <to.garnet@gmail.com> 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
>>database)?
>>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 :
> http://anybox.fr/blog/postgresql-large-object-storage-for-odoo
> 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    :  togarhutabarat@databit.co.id [1]  Mobile   :
>>+62821-3079-8827  YM       :  sherlocx@ymail.com [2]   Skype
>> : togar.hutabarat
>>Twitter  : @togarhutabarat
>>
>>_______________________________________________
>>Mailing-List: https://www.odoo.com/groups/community-59
>>Post to: mailto:community@mail.odoo.com
>>Unsubscribe: https://www.odoo.com/groups?unsubscribe
>>
>>
>>
>>[1] mailto:togarhutabarat@databit.co.id
>>[2] mailto:sherlocx@ymail.com
>
> _______________________________________________
> Mailing-List: https://www.odoo.com/groups/community-59
> Post to: mailto:community@mail.odoo.com
> Unsubscribe: https://www.odoo.com/groups?unsubscribe
>