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]> 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]> 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... > > > > > > > > > > > > On Sun, Feb 21, 2010 at 11:57 AM, gazza <[email protected]> wrote: > > > > > Why is this wrong? Is it performance? > > > > > Much appreciated, > > > Garyc > > > On Feb 20, 6:58 pm, Jonathan Vanasco <[email protected]> wrote: > > >> On Feb 20, 4:59 pm, Wyatt Baldwin <[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]. > > > To unsubscribe from this group, send email to > [email protected]<pylons-discuss%[email protected]> > . > > > For more options, visit this group athttp:// > 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]. > To unsubscribe from this group, send email to > [email protected]<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.
