I think this is an awesome idea and I'd be willing to help on this. I have a few questions about the page linked above though:
- Why don't we use foreign keys in MySQL? - The word "hack" is used three times. That's probably an issue. ;) - Is there a reason we're changing the default from NULL to NOT NULL? Wouldn't it be better to just use a "required" keyword? - We should probably support MySQL's -- comment syntax, just in case. - What's the [ignore] on the insert call do? (It becomes a little confusing since there is also the [tablename] syntax on global indexes.) - The Alter Table syntax looks really weird (with tildas and whatnot). *--* *Tyler Romeo* Stevens Institute of Technology, Class of 2015 Major in Computer Science www.whizkidztech.com | tylerro...@gmail.com On Sat, Aug 18, 2012 at 2:20 PM, Daniel Friesen <li...@nadir-seen-fire.com>wrote: > I see the branch, but I don't see the code: > https://svn.wikimedia.org/viewvc/mediawiki/branches/abstract-schema/phase3/ > It looks like someone just copied phase3 and then never actually changed > any code. I don't even see a syntax idea there. > > ~Daniel Friesen (Dantman, Nadir-Seen-Fire) [http://daniel.friesen.name] > > On 12-08-18 11:10 AM, Chad wrote: > > > > We tried this before, and I'd love to see it happen. Take a look at > > the abstract-schema branch in SVN for what we did. > > > > -Chad > > > > On Aug 18, 2012 1:53 PM, "Daniel Friesen" <li...@nadir-seen-fire.com > > <mailto:li...@nadir-seen-fire.com>> wrote: > > > > We've got a nice abstract query system but our table creation and > > migrations are horrible. We re-write them for multiple database > > engines. And as a result extensions need to do the same and often > > don't. Leading to things being a mess for databases other than MySQL. > > > > While I was doing the sites stuff a syntax for defining tables > > came to mind and I wrote out an RfC for a method of defining our > > database abstractly. > > > > > https://www.mediawiki.org/wiki/Requests_for_comment/Abstract_table_definitions > > > > -- > > ~Daniel Friesen (Dantman, Nadir-Seen-Fire) > > [http://daniel.friesen.name] > > > > _______________________________________________ > > Wikitech-l mailing list > > Wikitech-l@lists.wikimedia.org <mailto: > Wikitech-l@lists.wikimedia.org> > > https://lists.wikimedia.org/mailman/listinfo/wikitech-l > > > > _______________________________________________ > Wikitech-l mailing list > Wikitech-l@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wikitech-l > _______________________________________________ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
