Re: [Zope3-Users] Importing Lots of Objects
--On 8. Januar 2006 11:44:06 -0600 David Johnson [EMAIL PROTECTED] wrote: How do I import them (if I use a relational database the answer is easy)?I have answers to these questions, but I would be curious to hear how others have dealt with issue. This depends likely on _your_ usecases. Data can be stored in a RBDMS, in the filesystem, in the ZODB...every storage has its pros and cons..without knowing your usecases there is only guessing what might be best for you. -aj pgpcdGOa9bQfJ.pgp Description: PGP signature ___ Zope3-users mailing list Zope3-users@zope.org http://mail.zope.org/mailman/listinfo/zope3-users
RE: [Zope3-Users] Importing Lots of Objects
--On 8. Januar 2006 11:57:36 -0600 David Johnson [EMAIL PROTECTED] wrote: Thanks. The basic use cases are as follows: Shoppers can browse products by category Shoppers can search for products Shoppers can add products to cart Merchants can import product lists from Excel/Text file Merchants can manually edit products We expect to service 1M purchase transactions a year, and expect to service 1000 merchants. I would go for a RDBMS. -aj pgpZJw75tpCUJ.pgp Description: PGP signature ___ Zope3-users mailing list Zope3-users@zope.org http://mail.zope.org/mailman/listinfo/zope3-users
RE: [Zope3-Users] Importing Lots of Objects
What is the best for merchants to manage the product list and content of their site? I can certainly put in into an RDBMS, but what would be the easiest way for them to manage their offering? Should I create a portal site for them or should I allow them into the ZMI in some way? Based upon the varied needs of the merchants, I would like to let them into the ZMI, and see their products as instances under their site. -Original Message- From: Andreas Jung [mailto:[EMAIL PROTECTED] Sent: Sunday, January 08, 2006 12:02 PM To: David Johnson; 'Andreas Jung'; zope3-users@zope.org Subject: RE: [Zope3-Users] Importing Lots of Objects --On 8. Januar 2006 11:57:36 -0600 David Johnson [EMAIL PROTECTED] wrote: Thanks. The basic use cases are as follows: Shoppers can browse products by category Shoppers can search for products Shoppers can add products to cart Merchants can import product lists from Excel/Text file Merchants can manually edit products We expect to service 1M purchase transactions a year, and expect to service 1000 merchants. I would go for a RDBMS. -aj ___ Zope3-users mailing list Zope3-users@zope.org http://mail.zope.org/mailman/listinfo/zope3-users
Re: [Zope3-Users] Importing Lots of Objects
On 1/8/06, David Johnson [EMAIL PROTECTED] wrote: What is the best for merchants to manage the product list and content of their site? I can certainly put in into an RDBMS, but what would be the easiest way for them to manage their offering? Should I create a portal site for them or should I allow them into the ZMI in some way? Based upon the varied needs of the merchants, I would like to let them into the ZMI, and see their products as instances under their site. It's very easy to design multiple user interfaces in Zope 3 thanks to the skins system. You don't need to give them access to the ZMI. The ZMI in Zope 3 is just a default skin. It exposes a lot of things that are best used by those who understand Zope 3. You could fit custom product management screens into it, but in my experience it's better to build a custom interface. It's not that difficult to do. As far as managing the data in the RDBMS from Zope 3, you can always use SQL Methods / Scripts or just interact with the database adapters directly and do the SQL interaction that way. For a more object-oriented solution you can try using 'sqlos' (SQLObject Support) which integrates the Python SQLObject system with Zope 3. You can still use Zope 3's schema, widgets, and form system - even if you generate the SQL yourself. If you have a product schema like this: class IProductInfo(Interface): name = zope.schema.TextLine( title=uProduct Name, maxlength=255, required=True) price = zope.schema.Float(title=uProduct Cost, required=True) you can still use the form system to get those fields, validate the input against the schema, and if validation succeeds, you can generate SQL from the validated data instead of assigning it to a Python object. You can make a site for the merchants that is specific to their needs. It doesn't need to be the ZMI (it would be a lot of work to integrate into that), but it can be that kind system. All of the tools are there. For the amount of data that you're talking about, an RDBMS is probably better tuned to your requirements. But you can still take full advantage of Zope 3's features even if you're not using the ZODB as your primary storage. ___ Zope3-users mailing list Zope3-users@zope.org http://mail.zope.org/mailman/listinfo/zope3-users
