Mailing List Archive: Zope: DB

external ZODB from Zope interface

Index | Next | Previous | View Threaded

gyrof at yahoo

Feb 2, 2006, 4:34 AM

Post #1 of 8 (3247 views)
Permalink

external ZODB from Zope interface

Hi,
I am a Zope newbie with some Python experience. We have a large amount of scientific data that we are planning to load into several ZODBs.
>From the Zope interface, how can I access these 'external'
databases? Are databases other than Data.fs accessible? Must this be done using an external method of some sort?

Thanks for your help.

-g

---------------------------------

What are the most popular cars? Find out at Yahoo! Autos

sgottlieb at optaros

Feb 2, 2006, 7:04 AM

Post #2 of 8 (3107 views)
Permalink

Re: external ZODB from Zope interface [In reply to]

This is a good write up of how to do it.

http://www.zope.org/Documentation/Books/ZopeBook/2_6Edition/RelationalDatabases.stx

--Seth

gyro funch wrote:

> Hi,
> I am a Zope newbie with some Python experience. We have a large amount
> of scientific data that we are planning to load into several ZODBs.
> From the Zope interface, how can I access these 'external'
> databases? Are databases other than Data.fs accessible? Must this be
> done using an external method of some sort?
>
> Thanks for your help.
>
> -g
>
> ------------------------------------------------------------------------
>
> What are the most popular cars? Find out at Yahoo! Autos
> <http://us.rd.yahoo.com/evt=38382/_ylc=X3oDMTEzNWFva2Y2BF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDMmF1dG9z/*http://autos.yahoo.com/newcars/popular/thisweek.html%20>
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>Zope-DB mailing list
>Zope-DB [at] zope
>http://mail.zope.org/mailman/listinfo/zope-db
>
>

--
Seth Gottlieb
Optaros, Inc.
60 Canal Street
Boston, MA 02114
e: sgottlieb [at] optaros
v: 617.227.1855 ext. 107
f: 617.227.1755
m: 617.852.2956
b: http://contenthere.blogspot.com

_______________________________________________
Zope-DB mailing list
Zope-DB [at] zope
http://mail.zope.org/mailman/listinfo/zope-db

gyrof at yahoo

Feb 2, 2006, 7:25 AM

Post #3 of 8 (3089 views)
Permalink

Re: external ZODB from Zope interface [In reply to]

Thanks for the very useful reference.
However, I don't see anything in there about accessing a ZODB. I may have missed something, but I don't see a suitable ZODB adapter that I can add in the Zope interface (similar to what is apparently possible for Gadfly, MySQL, PostgreSQL, and other DBs).

Any other ideas about how to access 'external' ZODBs and make them part of the Zope project?

Thanks.

-g

Seth Gottlieb <sgottlieb [at] optaros> wrote: This is a good write up of how to do it.

http://www.zope.org/Documentation/Books/ZopeBook/2_6Edition/RelationalDatabases.stx

--Seth

gyro funch wrote:

> Hi,
> I am a Zope newbie with some Python experience. We have a large amount
> of scientific data that we are planning to load into several ZODBs.
> From the Zope interface, how can I access these 'external'
> databases? Are databases other than Data.fs accessible? Must this be
> done using an external method of some sort?
>
> Thanks for your help.
>
> -g
>
>_______________________________________________
>Zope-DB mailing list
>Zope-DB [at] zope
>http://mail.zope.org/mailman/listinfo/zope-db
>
>

--
Seth Gottlieb
Optaros, Inc.
60 Canal Street
Boston, MA 02114
e: sgottlieb [at] optaros
v: 617.227.1855 ext. 107
f: 617.227.1755
m: 617.852.2956
b: http://contenthere.blogspot.com

---------------------------------
Yahoo! Autos. Looking for a sweet ride? Get pricing, reviews, & more on new and used cars.

sgottlieb at optaros

Feb 2, 2006, 7:38 AM

Post #4 of 8 (3107 views)
Permalink

Re: external ZODB from Zope interface [In reply to]

Sorry,

I misread your question. One thing that you could do is go to the Zope
instance with the database that you want to export, go to the directory
that you want to export and then use the Zope export utility. This
assumes that your data is sitting in a folder within the database.

Try this:

http://www.faqs.org/docs/ZopeBook/BasicObject.html

--Seth

gyro funch wrote:

> Thanks for the very useful reference.
> However, I don't see anything in there about accessing a ZODB. I may
> have missed something, but I don't see a suitable ZODB adapter that I
> can add in the Zope interface (similar to what is apparently possible
> for Gadfly, MySQL, PostgreSQL, and other DBs).
>
> Any other ideas about how to access 'external' ZODBs and make them
> part of the Zope project?
>
> Thanks.
>
> -g
>
> */Seth Gottlieb <sgottlieb [at] optaros>/* wrote:
>
> This is a good write up of how to do it.
>
> http://www.zope.org/Documentation/Books/ZopeBook/2_6Edition/RelationalDatabases.stx
>
> --Seth
>
> gyro funch wrote:
>
> > Hi,
> > I am a Zope newbie with some Python experience. We have a large
> amount
> > of scientific data that we are planning to load into several ZODBs.
> & gt; From the Zope interface, how can I access these 'external'
> > databases? Are databases other than Data.fs accessible? Must
> this be
> > done using an external method of some sort?
> >
> > Thanks for your help.
> >
> > -g
> >
> >_______________________________________________
> >Zope-DB mailing list
> >Zope-DB [at] zope
> >http://mail.zope.org/mailman/listinfo/zope-db
> > a
> >
>
> --
> Seth Gottlieb
> Optaros, Inc.
> 60 Canal Street
> Boston, MA 02114
> e: sgottlieb [at] optaros
> v: 617.227.1855 ext. 107
> f: 617.227.1755
> m: 617.852.2956
> b: http://contenthere.blogspot.com
>
>
> ------------------------------------------------------------------------
> Yahoo! Autos
> <http://us.rd.yahoo.com/evt=38381/%20ylc=X3oDMTEzcGlrdGY5BF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDMWF1dG9z/*http://autos.yahoo.com/index.html%20>.
> Looking for a sweet ride? Get pricing, reviews, & more on new and used
> cars.

--
Seth Gottlieb
Optaros, Inc.
60 Canal Street
Boston, MA 02114
e: sgottlieb [at] optaros
v: 617.227.1855 ext. 107
f: 617.227.1755
m: 617.852.2956
b: http://contenthere.blogspot.com

_______________________________________________
Zope-DB mailing list
Zope-DB [at] zope
http://mail.zope.org/mailman/listinfo/zope-db

charlie at egenix

Feb 2, 2006, 7:44 AM

Post #5 of 8 (3095 views)
Permalink

Re: external ZODB from Zope interface [In reply to]

On Thu, 02 Feb 2006 16:25:09 +0100, gyro funch <gyrof [at] yahoo> wrote:

> Thanks for the very useful reference.
> However, I don't see anything in there about accessing a ZODB. I may
> have missed something, but I don't see a suitable
> ZODB adapter that I can add in the Zope interface (similar to what is
> apparently possible for Gadfly, MySQL,
> PostgreSQL, and other DBs).
> Any other ideas about how to access 'external' ZODBs and make them part
> of the Zope project?

Interesting question. I don't think is a common request. You might want to
look at how to use standalone ZODB's in Python, although it sounds as if
you're already competent with that. It may indeed be that you do need an
ExternalMethod for what you want to do - shouldn't be much trouble, I
would think. Why do you need several databases? Is it something to do with
the size of your data?

Other than that I'm sure the Timbot will notice the post!

Charlie
_______________________________________________
Zope-DB mailing list
Zope-DB [at] zope
http://mail.zope.org/mailman/listinfo/zope-db

Peter.Frey at haufe

Feb 2, 2006, 9:20 AM

Post #6 of 8 (3101 views)
Permalink

AW: external ZODB from Zope interface [In reply to]

Hi,

depending on what your goals are, maybe the following approach we use at
our site may help:
it is possible to mount "external" ZODB storages from a ZEO server into
the main storage

here an excerpt from our Zope configuration:

<zodb_db main>
mount-point /
cache-size $ZODB_CACHE_SIZE_MAIN
pool-size $ZODB_POOLSIZE
<zeoclient>
server $ZEOSERVER_MAIN
storage main
name zeostorage
cache-size 100000000
</zeoclient>
</zodb_db>

# ----------------------------------------
# mounted ZEO client storages:
# provided by local or remote ZEO server
#

<zodb_db normen>
mount-point $MOUNTPOINT/Data/Normen:/Normen
cache-size $ZODB_CACHE_SIZE_NORMEN
pool-size $ZODB_POOLSIZE
<zeoclient>
server $ZEOSERVER_NORMEN
storage normen
cache-size 200000000
</zeoclient>
</zodb_db>

# and a couple of other storages follow here

the variable MOUNTPOINT (defined ahead) specifies a ZODB Path under that
the storage is mounted
the content of the storage is then accessible through ZODB paths
directly from the main storage

note that it may be also possible to use local file storages (Data.fs
from local folders)
but as we have a not too small multiuser environment with several
servers we have no experience with that
so you may have to experiment on your own

Peter

________________________________

Von: zope-db-bounces [at] zope [mailto:zope-db-bounces [at] zope] Im
Auftrag von gyro funch
Gesendet: Donnerstag, 2. Februar 2006 16:25
An: Seth Gottlieb
Cc: zope-db [at] zope
Betreff: Re: [Zope-DB] external ZODB from Zope interface

Thanks for the very useful reference.
However, I don't see anything in there about accessing a ZODB. I may
have missed something, but I don't see a suitable ZODB adapter that I
can add in the Zope interface (similar to what is apparently possible
for Gadfly, MySQL, PostgreSQL, and other DBs).

Any other ideas about how to access 'external' ZODBs and make them part
of the Zope project?

Thanks.

-g

_______________________________________________
Zope-DB mailing list
Zope-DB [at] zope
http://mail.zope.org/mailman/listinfo/zope-db

dieter at handshake

Feb 2, 2006, 11:36 AM

Post #7 of 8 (3094 views)
Permalink

Re: external ZODB from Zope interface [In reply to]

gyro funch wrote at 2006-2-2 04:34 -0800:
>I am a Zope newbie with some Python experience. We have a large amount of scientific data that we are planning to load into several ZODBs.
>>From the Zope interface, how can I access these 'external'
>databases?

To access additional storages, you use
"Products.ZODBMountPoint.MountedObject.MountedObject" instances.

Mounting is similar to mounting under *nix.

--
Dieter
_______________________________________________
Zope-DB mailing list
Zope-DB [at] zope
http://mail.zope.org/mailman/listinfo/zope-db

gyrof at yahoo

Feb 3, 2006, 5:36 AM

Post #8 of 8 (3100 views)
Permalink

Re: external ZODB from Zope interface [In reply to]

Thank you all for the very helpful suggestions!
I will try several of them and see what works best for my application.

-g

---------------------------------
Brings words and photos together (easily) with
PhotoMail - it's free and works with Yahoo! Mail.

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads