From: Chuck E. <ec...@mi...> - 2001-03-11 06:13:33
|
At 04:39 PM 3/9/2001 -0800, J.J. Dukarm wrote: >I have not had a lot of time to poke around in MiddleKit, but I like what I >have seen already very much. > >My biggest reservations so far are: >(1) The MiddleKit data dictionary does not seem to contain the detail (e.g. >primary key and foreign key constraints) that some apps would need, and The MSSQL adapter guy is working on this. Don't really have a time frame. Maybe the next week or two. >(2) The data dictionary organization is not relational, which makes it a >lot of work to maintain. The way that I have done it in my apps is to make >the data dictionary a relational database consisting of tab-delimited text >files, which - like MiddleKit's csv files - are easily edited in a >spreadsheet. It seems our approach then shares using CSV files. MK's file however is meant to be an object model, not a relational model. And to use Pythonic terminology as much as possible. >It would seem to make sense to have MiddleKit talking to ODBC as soon as >possible. It would also be nice to have it talking to Gadfly. If it does >not entail too much low-level wizardry, and if I can figure out what in >MiddleKit must be hacked, I would be willing try cooking up ODBC and Gadfly >adaptations. MSSQL (which actually needs some fixing) already uses mxODBC which is DB API 2.0 compliant, which is what the SQL adapters are based on. A Gadfly adapter would definitely be interesting. -Chuck |