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 | tylerromeo@gmail.com
On Sat, Aug 18, 2012 at 2:20 PM, Daniel Friesen lists@nadir-seen-fire.comwrote:
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" <lists@nadir-seen-fire.com mailto:lists@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_definitio...
-- ~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