[Zope] Storing Data inside Zope
Dennis Allison
allison@sumeru.stanford.EDU
Mon, 2 Jun 2003 14:26:30 -0700 (PDT)
Sorry if this has already been suggested in this thread..
It seems to me that you are really in need of a hybrid system which uses
both Zope and a relational data base. Zope and some specialized
products to manage the front-end and query interfaces, and a
relational database to handle complex queries.
MySQL, at least the recent versions, supports full text indexing as well
as the usual SQL relational queries. I suspect that would be invaluable
for your application.
You might consider (if your budget allows) incorporating a google-style
search engine.
>
> I'm using the Client/Cases/Detail/etc granularity and making each record a
> single object (using File objects for testing) in an appropriate data folder
> (e.g. Case/Data, Client/Data or maybe Data/Client, Data/Case). I create
> properties with field names and assign them the field values. That way I
> can use the ZMI to create/clone/edit/delete 'data records' easily in
> addition to my programs. I'm using Formulator so I can tap the field
> definitions programmatically to get the info needed to define the File data
> object properties appropriately for each field. I thought about making a
> template File data object and cloning it as needed but I haven't figured out
> how to do that yet. Besides the dynamic Formulator approach lets me change
> form AND 'table' definitions in one spot which is nice for development.
>
> Being shiny new to Zope I'm still grasping the building blocks but thought
> ZClasses sounded like what might be useful for this. Thanks for letting me
> know that might not be a good idea. I'll continue to fumble through
> alternate approaches. It's painfully slow but at least it's interesting.
>
> Thanks to all who have contributed help,
> Tom P. Allred, MCSE, RHCE, CCNA
> Allred Data Consulting, Inc.
> 704-633-0311 x826
> www.AllredData.com
> Tom@AllredData.com
>