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=yes&area=default 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]. > For more options, visit this group at > http://groups.google.com/group/pylons-discuss?hl=en. > > -- Thomas G. Willis -- 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.
