Which for small table: ZODB, TinyTable, Gadfly, MySQL?
Hi, I've got a static table of 60 rows consisting of: firstname, lastname, department, email, telephone and I'd like to display this list in a table that can be sorted by clicking on the column headings. Considering the size, what would be the 'best practices' way of doing this? a) creating objects and searching through ZODB, b) TinyTablePlus product c) Gadfly database d) MySQL database (seems like overkill) e) something else?? David --- David Elfstrom, P.Eng elfstrom@sten.sunnybrook.utoronto.ca Systems Engineer, Research Computing Sunnybrook & Women's College Health Sciences Centre Rm#S6-20, 2075 Bayview Avenue, Toronto, Canada M4N 3M5 phone: 416-480-6100 x3416 fax: 416-480-5714 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.377 / Virus Database: 211 - Release Date: 7/15/2002
On Wednesday 31 July 2002 12:54 pm, you wrote:
I've got a static table of 60 rows consisting of: firstname, lastname, department, email, telephone and I'd like to display this list in a table that can be sorted by clicking on the column headings.
Considering the size, what would be the 'best practices' way of doing this? a) creating objects and searching through ZODB, b) TinyTablePlus product c) Gadfly database d) MySQL database (seems like overkill)
e) something else??
if it doesn't bother you, javascript can do this fairly easily. there several are sortable javascript table scripts on the net. -kapil
On Wed, 31 Jul 2002, David Elfstrom wrote:
Hi,
I've got a static table of 60 rows consisting of: firstname, lastname, department, email, telephone and I'd like to display this list in a table that can be sorted by clicking on the column headings.
Considering the size, what would be the 'best practices' way of doing this? a) creating objects and searching through ZODB, b) TinyTablePlus product c) Gadfly database d) MySQL database (seems like overkill) e) something else??
If people will click on a name and go to more information about that person (a picture, full description, whatever), you'd probably want to create the people as custom objects, and have the list be displayed by a ZCatalog query over these objects. To just present a list, I'd use TinyTable. It does not scale well for anything even medium-sized, but it's a snap to install and you'll get its editing views and simple querying for free. With Gadfly or MySQL, you'd have to write the insert,update,delete views (tho' there are some Products that can generate these for you.) Beehive's MetaPublisher might also be a good solution, especially if you want to store more information about the person (like an image or description or such) HTH. -- Joel BURTON | joel@joelburton.com | joelburton.com | aim: wjoelburton Independent Knowledge Management Consultant
participants (3)
-
David Elfstrom -
Joel Burton -
kapil thangavelu