On Fri, Apr 17, 2009 at 10:39 AM, Roland Bouman <[email protected]> wrote: > Hi! > > On Fri, Apr 17, 2009 at 3:56 PM, Baron Schwartz <[email protected]> wrote: >> Why not *actually make it a set of views* instead of "pretending" it's >> a set of views. > > I think it's a great idea, but that'd mean the dictionary would have > to be kept in database tables, no?
Right, and that strikes me as a really good idea. InnoDB already does it, with several benefits. (Hey, InnoDB has transactional DDL! It's only MySQL that doesn't!) There has to be some base-case to the recursion, where at some level *something* is implemented in code, instead of all just being data in tables. Now that I think about it, I think SQL Server 2000's system tables were all implemented this way, too. Speaking of which, this reminds me of InnoDB's internal stored procedures; anyone else on this list ever seen the code where InnoDB writes itself some SQL commands and then executes them to do things like maintain foreign keys? I feel an XKCD comic in here somewhere. _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
