From:	Iain Truskett	Date:	Wed Aug 28 22:03:12 2002
Subject:	Re: blobs

* Dave Rolsky (autarch@urth.org) [29 Aug 2002 13:53]:
> On 28 Aug 2002, Uri Guttman wrote:
> > no, you must convert it first to a string by using storable (freeze
> > method) or some other module. then you can insert it into a long
> > field of type BLOB.

> This shouldn't be necessary if you are storing raw image data, actually.

That's what I thought, but it didn't appear to be working.

> But I'd strongly recommend just storing filenames in the DB. Why push
> and pull such large chunks of data from the DB? What's the point?

Well, part of the idea is that all that ever changes on the site is the
db. If I'm wanting to write images to disc from my components (since one
of the other ideas is that it's fully maintainable via the web), I'll
need to be able to write to disc.

Which is doable I suppose. It makes things easier in some respects. I'll
confer with Robrt.

In essence: assume that we can't (and don't want to) scp/ftp stuff.


> Better yet, simply generate filenames based on the ISBN or something
> unique like that (id in the db would work too).

Yep. That's the idea.


cheers,
-- 
Iain.