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.
--
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.
