Hello,
As you might guess by now, I am exploring zetadb in order to find out
whether it is the right tool for what I need to do.
We have a few fairly large (~ 10 million rows) database tables, which we
do not need to edit, but need to query fairly regularly (exploitation of
census data in a research environment). Some of my colleagues are not at
ease with sql and I, therefore, developed a simple web form interface
with a python script that allows them to chose a few fields, decide on
ways of selecting and regrouping them and the launch a query. When the
database returns the results the user receives an email containing a
link where to get the results in the form a delimited ascii file.
The system works, but does not scale very well when new tables with
different fields are added. Having to add a new table soon, I am looking
for a more "automated" way of doing this. This is how I came about zope
and zetadb.
Currently, my alternatives seem to be:
- stick with the home-grown script
- use zope with Z SQL Methods
- use zope with zetadb
So, in general, does the above scenario sound like a case for zetadb ?
More specifically, the search interface allows to filter the data, but
are there possibilities of easily regrouping and aggregating data ?
Moritz
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
|
