I believe there's a Blob (I think it's called) binary data type for sql - there was a thread a while ago in this list, someone storing large images in sql using those. personally, I'd use ZODB, or just the file system (LocalFS or ExtImage)
From: "Bryan C. Andregg" <bryan.andregg@duke.edu> Date: Wed, 6 Mar 2002 16:31:42 -0500 To: zope@zope.org Subject: [Zope] storing binary data in an external database
I need to be able to store images and the like in a postgres table. It would seem that <dtml-sqlvar> isn't going to be what I want because there isn't a type definition for what I want (the data isn't exactly a string, right?).
I'm reading in the file contents using REQUEST['file'].read(), which works great for ascii text files, but not binaries.
Any help appreciated. -- Bryan C. Andregg Duke University Medical Center Programmer Dept. of Anesthesiology e <bryan.andregg@duke.edu> p +1 919 684 6201