Re: [Zope] BLOB from PotgreSQL on web page
I am using Zope 2.3 and PSQL 7.1 After installing the adapters Popy and ZPopyDA it has been working very well. But I have one concern and one problem.
Problem
I am storing BLOBs in PSQL using lo_import, and exporting them to the file system using lo_export. But I cannot figure out how to display them directly from the database to the web page.
Concern
What is more efficient? To store files as BLOBs in PSQL or to store the files to Zope and store link to the file in PSQL. Files will be of different format: jpg, gif, pdf, wpd, doc, ...
postgresql 7.1 does not have any limit on row size. just call a python method that squeezes the data into a text column and retrieve it. hope this helps, federico -- Federico Di Gregorio MIXAD LIVE Chief of Research & Technology fog@mixadlive.com Debian GNU/Linux Developer & Italian Press Contact fog@debian.org The number of the beast: vi vi vi. -- Delexa Jones
I am storing BLOBs in PSQL using lo_import, and exporting them to the file system using lo_export. But I cannot figure out how to display them directly from the database to the web page. Files will be of different format: jpg, gif, pdf, wpd, doc, ...
postgresql 7.1 does not have any limit on row size. just call a python method that squeezes the data into a text column and retrieve it.
hope this helps, federico
-- Federico Di Gregorio MIXAD LIVE Chief of Research & Technology fog@mixadlive.com Debian GNU/Linux Developer & Italian Press Contact fog@debian.org The number of the beast: vi vi vi. -- Delexa Jones
Hi Federico, I am glad to hear that python solution for publishing the files (especially images) from database to web pages exists. I found ASP, PHP, Perl solutions, but it did not help me. Can you give me more details how python solution looks like or if you have working example? Thanks Vid __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/
i think i cross posted here from the psycopg ml something on the argument a week ago... looking at the mailing lists... ok. found. you'll find a little example in how to save a jpg image to postgresql here: http://lists.initd.org/pipermail/psycopg/2001-June/000201.html if you need more help, don't esitate to write again, federico On 29 Jun 2001 09:07:48 -0700, Vid B wrote:
I am storing BLOBs in PSQL using lo_import, and exporting them to the file system using lo_export. But I cannot figure out how to display them directly from the database to the web page. Files will be of different format: jpg, gif, pdf, wpd, doc, ...
postgresql 7.1 does not have any limit on row size. just call a python method that squeezes the data into a text column and retrieve it.
hope this helps, federico
-- Federico Di Gregorio MIXAD LIVE Chief of Research & Technology fog@mixadlive.com Debian GNU/Linux Developer & Italian Press Contact fog@debian.org The number of the beast: vi vi vi. -- Delexa Jones
Hi Federico,
I am glad to hear that python solution for publishing the files (especially images) from database to web pages exists. I found ASP, PHP, Perl solutions, but it did not help me. Can you give me more details how python solution looks like or if you have working example?
Thanks
Vid
__________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/
-- Federico Di Gregorio MIXAD LIVE Chief of Research & Technology fog@mixadlive.com Debian GNU/Linux Developer & Italian Press Contact fog@debian.org Try the Joy of TeX [http://www.tug.org] -- brought to you by One Line Spam
participants (2)
-
Federico Di Gregorio -
Vid B