Personal tools
You are here: Home Lists ZPUG DC List Archives 2005 2005-10 Design decision - zodb or relational database / David Diskin <david.diskin@verizon.net>
Navigation
Log in


Forgot your password?
New user?
Mailing Lists
You can read our ZPUGDC mailing list archives online.
You can subscribe to our mailing list:
Book Review

The Definitive Guide to Plone

Reviewer: joel
 

Design decision - zodb or relational database / David Diskin <david.diskin@verizon.net>

Design decision - zodb or relational database
David Diskin <david.diskin(at)verizon.net>
2005-10-05 15:26:31 [ FULL ]
I need to do the following:
* use Archetypes to create new types for a library 'subsystem" on my  
plone site - book, author.
* There will be about 3000 books.
* Need to let any member (we have about 1000 members) search, browse  
for a book
* Need to let the librarian update, delete, add new books and review  
some reports - database sorted in different ways, and maybe some others.

Currently the database of books is in MS Access and Access is used to  
create a couple of simple reports which I will move to Plone.

Is this enough information to make a decision?  What would you choose  
for the AT storage?

Thanks,

David
==============================
David Diskin, david.diskin(at)verizon.net

Re: [ZPUGDC] Design decision - zodb or relational database / Joel Burton <joel@joelburton.com>

Re: [ZPUGDC] Design decision - zodb or relational database
Joel Burton <joel(at)joelburton.com>
2005-10-05 15:32:13 [ FULL ]
On Wednesday 05 October 2005 04:30 pm, David Diskin wrote:[...]

Do you need simultaneous editing access from both a relational database 
and Plone? If so, you might have to keep it in a reldb.

If not (& you probably don't), using standard AT, stored in the ZODB, is 
always, hands-down, the easiest and fastest.

And, you might be able to use some of the good work in ATAmazon, which 
lets you enter an ISBN and pull images and data from Amazon's API.

- j.
[...]

Re: [ZPUGDC] Design decision - zodb or relational database / David Diskin <david.diskin@verizon.net>

Re: [ZPUGDC] Design decision - zodb or relational database
David Diskin <david.diskin(at)verizon.net>
2005-10-05 15:40:42 [ FULL ]
Joel -

Thanks much - I do not need simultaneous editing access to both.  In  
fact, if I go the zodb route, i'll just (hopefully) convince the  
librarian to only use our plone site and abandon her stand alone ms  
access database.  Thanks for the tip on ATAmazon.

Best regards,

David

On Oct 5, 2005, at 4:36 PM, Joel Burton wrote:
[...][...][...]
==============================
David Diskin, david.diskin(at)verizon.net

Powered by Plone, the Open Source Content Management System

This site conforms to the following standards: