Re: [Wikitech-l] [RFC] Abstract table definitions

2012-08-20 Thread Tyler Romeo
Makes sense. IMHO most of the stuff I mentioned is just minor qualms. The overall syntax is pretty nice, and I think it'd be a great idea to have something like this. *--* *Tyler Romeo* Stevens Institute of Technology, Class of 2015 Major in Computer Science www.whizkidztech.com |

Re: [Wikitech-l] [RFC] Abstract table definitions

2012-08-19 Thread Daniel Friesen
On 12-08-18 10:37 PM, Tyler Romeo wrote: 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? We don't use them now so I didn't use them in the abstract table schema types.

[Wikitech-l] [RFC] Abstract table definitions

2012-08-18 Thread Daniel Friesen
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

Re: [Wikitech-l] [RFC] Abstract table definitions

2012-08-18 Thread Siebrand Mazeland (WMF)
Hey Daniel, As far as I know this is something lying on a shelve somewhere (ie probably a branch in core's svn, as, IIRC, Chad, was close I completing this once a year or two ago. -- Siebrand Mazeland M: +31 6 50 69 1239 Skype: siebrand Op 18 aug. 2012 om 19:52 heeft Daniel Friesen

Re: [Wikitech-l] [RFC] Abstract table definitions

2012-08-18 Thread Chad
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 wrote: We've got a nice abstract query system but our table creation and migrations are horrible. We

Re: [Wikitech-l] [RFC] Abstract table definitions

2012-08-18 Thread Daniel Friesen
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)

Re: [Wikitech-l] [RFC] Abstract table definitions

2012-08-18 Thread Tyler Romeo
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