From: Stephan D. <ste...@gm...> - 2002-03-28 15:57:07
|
> Stephan Diehl <ste...@gm...>: > > Hope it's not to late :-) I was thinking for quite a while doing a object > > > > relational wrapper. For me it should work on Mysql and eventually Oracle. > > I've already some ideas, but nothing written yet. Maybe we should > > exchange some ideas. If you think that could be a good idea, just shout > > :-) > > Sure :) Great > > My main idea is that as much of the metadata as possible should be > implicit... I.e. the sql database itself should provide enough > structural information. E.g. by doing > > class Person(Persistent): > table = 'person' > > you'd be all set... (And even the table name could be extracted from > the class name, I guess... ;) It can. I was thinking to have even something more generic in the way, that we don't need different tables for different classes. I was thinking along the following line: Basicly, I'd like to have some object wrapper that is usable with other languages as well (Perl, PHP). This wouldn't really be a requirement, but it has a nice feel to it :-) There are different tables for classes, objects and attributes. Every object has a unique id within the database. The object id contains some class information (just like in MiddleKit: 64bit unsigned int, the first 32 bit are class id and the second 32 bit object id) If I check in an object, the following should happen: Check if class is known, if not, create one (this gives the class id) Create a new object (has reference to class) for every attribute in __dict__, create new attribute row We'd need probably some basetypes like int, real, string, dict, list with special handling for them If this works, it would be extreamly flexible. The downside might be performance since the db consists basicly of two large tables and an object can only be rebuilt with a lot of selects, joins,... hope, I did at least make a little bit sense :-) > > I'm not sure if this is the best way of doing things, but I think it > would be interesting to investigate it. (It's quite close to ZODB in > some ways, I guess... But somehow I think it would be nice to have an > ORDBMS as backend...) yup stephan > > -- > Magnus Lie Hetland The Anygui Project > http://hetland.org http://anygui.org > > _______________________________________________ > Webware-discuss mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/webware-discuss |