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(a)gmail.com
On Sat, Aug 18, 2012 at 2:20 PM, Daniel Friesen
<lists(a)nadir-seen-fire.com>wrote;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" <lists(a)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_definiti…
--
~Daniel Friesen (Dantman, Nadir-Seen-Fire)
[
http://daniel.friesen.name]
_______________________________________________
Wikitech-l mailing list
Wikitech-l(a)lists.wikimedia.org <mailto:
Wikitech-l(a)lists.wikimedia.org>
_______________________________________________
Wikitech-l mailing list
Wikitech-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikitech-l