Friday 03 December 2004 6:06:08 am
Oh my. I must have been around economists for too long (who generally don't give you anything useful at all). Of course that information isn't enough. Basically, it's going to be a rather huge product database for an antique dealer. It's gonna be mostly structured text (which ez excels at as we all know) and obviously scans and pics of the stuff offered, so not a lot of binaries all in all.
ez + enhancedojectrelation has all the features I really need to develop a complex data model: As an example, take a book:
author: an object relation to the authors, reverse relation enables it to easily list all the books by him
publication date: date
title: string
genre: relation to proper genres, with the same reason as the authors
publisher: relation to the publisher
This makes for a somewhat slow, but incredibly flexible datamodel (of course I could do it in SQL myself, but it's a PITA to write a decent GUI for it). Performance isn't much of a worry (we have fast servers at hand if need be) and traffic will be light. As for the volume of the data: there's literally tens, maybe hundreds of thousand items but I don't know whether they will all be put online. But I'd estimate somewhere in the lower 5 digits. Essentially I don't need anything else to talk to it, but I need the possibility to get data out of it if need be. I'm guessing it will be some work (more than with plain SQL data model) but using the ez classes, it should be doable. As for MySQL being gone: not much of a problem. MySQL's SQL dialect can be fed easily (meaning little s/r needed) to a whole bunch of RDBMS. Dumping the stuff to XML crossed my mind as well. I wonder if there's already some hidden feature for that?
Visit http://triligon.org
|