Re: Pylons and images from database

2010-02-25 Thread Jonathan Vanasco
if you store things on the filesystem, you'll need to use a hashing algorithm to bucket it effectively -- filesystems don't like too many files in a directory. you don't need to rename the file to a hash -- you could just store that in the db -- but I'd advise renaming the file to a hash,

Re: Pylons and images from database

2010-02-24 Thread Matt Feifarek
On Tue, Feb 23, 2010 at 4:08 PM, gazza burslem2...@yahoo.com wrote: I think I've opted to store on disc. I guess there are two camps regarding this. If you're worried about filename integrity (including full path) you can hash the files and store the fingerprints. I've done that before; works

Re: Pylons and images from database

2010-02-23 Thread gazza
I think I've opted to store on disc. I guess there are two camps regarding this. Appreciate the information ,all useful stuff. Cheers, gazza On Feb 21, 2:22 pm, Wichert Akkerman wich...@wiggy.net wrote: There is also transaction aware handling of files involved. Personally I do store images

Re: Pylons and images from database

2010-02-21 Thread gazza
Why is this wrong? Is it performance? Much appreciated, Garyc On Feb 20, 6:58 pm, Jonathan Vanasco jonat...@findmeon.com wrote: On Feb 20, 4:59 pm, Wyatt Baldwin wyatt.lee.bald...@gmail.com wrote: I thought this was generally not recommended and that you should instead store the files on

Re: Pylons and images from database

2010-02-21 Thread Thomas G. Willis
It depends really, if you believe Oracle(or any database vendor), they claim serving file blobs from their database is more efficient then the filesystem and has the benefit of transactional integrity. At least that's how my day job rationalized storing images/pdf's and other things related to a

Re: Pylons and images from database

2010-02-21 Thread gazza
Make sence. I will follow the kiss and keep it on the disc. Much appreciated the anwers. Gazza On Feb 21, 11:08 am, Thomas G. Willis tom.wil...@gmail.com wrote: It depends really, if you believe Oracle(or any database vendor), they claim serving file blobs from their database is more

Re: Pylons and images from database

2010-02-21 Thread Stephan Ellis
There are some advantages to having them in the database. Backups are just a database dump away, which is really easy if you are on mysql. Also, controlling access to files is the same as controlling access to anything else that comes out of the db. On Sun, Feb 21, 2010 at 2:12 PM, gazza

Re: Pylons and images from database

2010-02-21 Thread Wichert Akkerman
There is also transaction aware handling of files involved. Personally I do store images and generated scaled images separately on disk, but using repoze.filesafe for transaction integration. Wichert. On 2010-2-21 21:15, Stephan Ellis wrote: There are some advantages to having them in the