Storing blobs in a RDB
Hi all. We have a zope/zeo/postgres configuration. We need to store blob on the RDB, which is on a different machine from zope. When the RDB and zope were on the same machine, this was achieved via creating a temporary file, and then submitting the file to postgres, via the lo_import/lo_export interface. Now this can't be done anymore. Is there any viable solution? What I thought to do was to put a zeo on the same machine as postgres, create a file or some object like that on the zeo storage, and then instruct postgres to get the file from there. But is this feasible? I've tried with DirectoryStorage, but it is storing other infos with the file (of course). Any suggestion? Regards Marco
Do you really need your blobs in an RDB or do you just need them out of ZODB? FWIW, I've had pretty good luck with getting blobs out of ZODB with a combination of http://www.plope.com/software/blob and NFS (for sharing a filespace between appservers). - C On Tue, 2005-03-15 at 12:13, Marco Bizzarri wrote:
Hi all.
We have a zope/zeo/postgres configuration. We need to store blob on the RDB, which is on a different machine from zope.
When the RDB and zope were on the same machine, this was achieved via creating a temporary file, and then submitting the file to postgres, via the lo_import/lo_export interface.
Now this can't be done anymore.
Is there any viable solution?
What I thought to do was to put a zeo on the same machine as postgres, create a file or some object like that on the zeo storage, and then instruct postgres to get the file from there. But is this feasible? I've tried with DirectoryStorage, but it is storing other infos with the file (of course).
Any suggestion?
Regards Marco _______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
participants (2)
-
Chris McDonough -
Marco Bizzarri