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 <[email protected]> wrote: > 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 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 <[email protected] > > <mailto:[email protected]>> wrote: > > > 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" <[email protected] > > <mailto:[email protected]>> wrote: > > > 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 patient chart in the database along with > > > everything else that is stored. > > > > But I can see where this would be considered misuse of a > > database(when > > > all you have a hammer, everything looks like a nail). I would say > > it's > > > an exotic use of the db for sure. > > > > Not mention it's likely that your code will end up relying on more > > > vendor specific api's for this which makes your code less portable. > > > Nonethless, sqlalchemy has column types for binary data. > > > http://www.sqlalchemy.org/docs/search.html?q=binary&check_keywords=ye. > > > > <http://www.sqlalchemy.org/docs/search.html?q=binary&check_keywords=ye.>.. > > > > On Sun, Feb 21, 2010 at 11:57 AM, gazza <[email protected] > > <mailto:[email protected]>> wrote: > > > > > Why is this wrong? Is it performance? > > > > > Much appreciated, > > > > Garyc > > > > On Feb 20, 6:58 pm, Jonathan Vanasco <[email protected] > > <mailto:[email protected]>> wrote: > > > >> On Feb 20, 4:59 pm, Wyatt Baldwin <[email protected] > > <mailto:[email protected]>> wrote: > > > > >> > I thought this was generally not recommended and that you should > > > >> > instead store the files on the file system with just the > > paths to the > > > >> > files in the database. > > > > >> That would be correct. > > > > > -- > > > > You received this message because you are subscribed to the > > Google Groups "pylons-discuss" group. > > > > To post to this group, send email to > > [email protected] > > <mailto:[email protected]>. > > > > To unsubscribe from this group, send email to > > [email protected] > > <mailto:pylons-discuss%[email protected]>. > > > > For more options, visit this group > > athttp://groups.google.com/group/pylons-discuss?hl=en > > <http://groups.google.com/group/pylons-discuss?hl=en>. > > > > -- > > > Thomas G. Willis- Hide quoted text - > > > > - Show quoted text - > > > -- > > You received this message because you are subscribed to the Google > > Groups "pylons-discuss" group. > > To post to this group, send email to [email protected] > > <mailto:[email protected]>. > > To unsubscribe from this group, send email to > > [email protected] > > <mailto:pylons-discuss%[email protected]>. > > For more options, visit this group at > > http://groups.google.com/group/pylons-discuss?hl=en. > > > -- > > You received this message because you are subscribed to the Google > > Groups "pylons-discuss" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]. > > For more options, visit this group at > >http://groups.google.com/group/pylons-discuss?hl=en. > > -- > Wichert Akkerman <[email protected]> It is simple to make > things.http://www.wiggy.net/ It is hard to make things > simple.- Hide quoted text - > > - Show quoted text - -- You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/pylons-discuss?hl=en.
