Storing an image (gif) in oracle table
Does anyone have any ideas on how to store an image (gif) into an oracle table through Zope. Zope doesn't seem to support BLOB's as an ZSQL Method argument. Thanks, DR
Hi, Why don't you save the URL of the image in the database instead? Do you do relational queries against those images? And store the images somwhere else. They may be served faster that way, instead of a database. Just a suggestion.. Adonis -- Adonis El Fakih, Technical Support, www.ayna.com On Fri, 21 Jan 2000, Daniel G. Rusch wrote:
Does anyone have any ideas on how to store an image (gif) into an oracle table through Zope. Zope doesn't seem to support BLOB's as an ZSQL Method argument.
Thanks,
DR
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
You could presumably create an image object, pickle it, then store it in the database as a text field which could be retrieved at any time. --sam technews@egsx.com wrote:
Hi,
Why don't you save the URL of the image in the database instead? Do you do relational queries against those images? And store the images somwhere else. They may be served faster that way, instead of a database. Just a suggestion..
Adonis
-- Adonis El Fakih, Technical Support, www.ayna.com
On Fri, 21 Jan 2000, Daniel G. Rusch wrote:
Does anyone have any ideas on how to store an image (gif) into an oracle table through Zope. Zope doesn't seem to support BLOB's as an ZSQL Method argument.
Thanks,
DR
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
on 22.01.2000 1:58 Uhr, technews@egsx.com at technews@egsx.com wrote:
Does anyone have any ideas on how to store an image (gif) into an oracle table through Zope. Zope doesn't seem to support BLOB's as an ZSQL Method argument.
Why don't you save the URL of the image in the database instead? Do you do relational queries against those images? And store the images somwhere else. They may be served faster that way, instead of a database. Just a suggestion..
Good advice. But HOW to store an image in the filesystem if it is not already there and the image uploading person is sitting in front of a HTTP client? I saw one HOWTO here: http://www.zope.org/Members/sabaini/externalfiles-howto But - as a real newbie - i do not really understand how to use the second script... (and properly install the first one....) Any hints? Oliver .. Oliver Wrede .. owrede@khm.de .. Academy of Media Arts, Cologne .. Peter-Welter-Platz 2 . 50676 Koeln, Germany .. http://www.khm.de .. ICQ# 6580315 .. PGP 6.0 Fingerprint: .. 922C FFA2 9A07 5B8E CB2A 10A2 C370 6A62 2232 196C
participants (4)
-
Daniel G. Rusch -
Oliver Wrede -
Sam Gendler -
technews＠egsx.com