Doesnt oracle offer a free "express" eddition? -bawolff

On Mon, Feb 25, 2013 at 7:48 AM, Mark A. Hershberger <mah(a)everybody.org> wrote: https://gerrit.wikimedia.org/r/#/c/50764/ -Chad

On 02/25/2013 10:52 AM, Danny Joe Bauch wrote: Have you tried to run MediaWiki's latest from git against MSSQL? -- http://hexmode.com/ There is no path to peace. Peace is the path. -- Mahatma Gandhi, "Non-Violence in Peace and War"

It would be best to have automated environment for this, either on labs or somewhere else. Problem is that it's not possible to install MSSQL and such on wikimedia labs given the restrictions On Mon, Feb 25, 2013 at 5:36 PM, Danny Joe Bauch <dj.bauch(a)gmail.com> wrote:

Microsoft was very kind to provide me with an Azure account which I used to do the testing of 1.18 and 1.19. I've not been in touch with them lately, nor have I checked whether that account is still open. I would gladly jump back on that. I'm afraid I got a bit distracted when my job disappeared out from under me, but I'm back at work at a new job and eager to jump back in on MSSQL and Azure support. On Mon, Feb 25, 2013 at 11:04 AM, Mark A. Hershberger <mah(a)everybody.org>wrote;wrote:

On 02/25/2013 07:40 AM, Chad wrote: Yeah. Just wanted to point people to prior roundups on this topic -- see http://thread.gmane.org/gmane.science.linguistics.wikipedia.technical/56384 & https://www.mediawiki.org/wiki/Bug_management/Triage/Databases_20111102 for some people Mark could reach out to to ask for testing & development help, and for this summary of what needed doing as of November 2011: The question: what do we need to test more often to keep RDBMSes happy? https://www.mediawiki.org/wiki/Database_testing & https://www.mediawiki.org/wiki/New_installer/Test_plan Permissions, searching, schema setup, schema changes, quoting & identifiers, weird page names, transactions, import, dump, & interface coverage seem like the main culprits. And I think we can mostly agree that MySQL/MariaDB (InnoDB & secondarily MyISAM), SQLite, and PostgreSQL are higher priority than SQL Server/SQL Server Express, Oracle, and DB2, although others might volunteer as maintainers and get some of that switched around. :-) Now fixed. Still needs fixing. Where's this branch now, if it's still useful? Thanks for working on this, Mark! -- Sumana Harihareswara Engineering Community Manager Wikimedia Foundation

On 02/25/2013 12:53 PM, Sumana Harihareswara wrote: Sure, for starters. :) Bear in mind, if we want to keep support for all these dbs, every change to the database schema has to (at some point) result in a change to separate SQL files for each DB (MySQL and SQLite use the same ones). For instance, there is a separate active oracle/tables.sql. Then, we need to make sure it actually works as intended for all the dbs. We do have database tests. As people noted, just having Jenkins run all the existing tests for every db would be a major step forward. We *only* run them for SQLite (not even MySQL!). See https://bugzilla.wikimedia.org/show_bug.cgi?id=35912 Matt Flaschen

http://stackoverflow.com/questions/108699/good-php-orm-library By the way, MySQL 5.6 is out and it supports fulltext search indexation for InnoDB tables. They also promise better peformance on large hardware. Still cannot find 12.04 ppa for 5.6.10, though and do not want to go troubles installing from source (although I installed MySQL from source some years ago).. Why going another database engines besides MySQL / MariaDB? Dmitriy

On 02/26/2013 02:14 PM, Luke Welling WMF wrote: It would be nice if we did. In my own production environments, I always use postgres. To date, mw has been "good enough" with its support that I've never had significant integration problems, but looking forward is always a little worrying. -- Marc

I'm still active on Oracle front, but as you might have noticed i have been [WARNING ... understatement ahead] a bit busy in the last 1,5 year so i just can't manage to pay as much attention to what's going on as i would like to ... I used to get paid by my company to do this, but due to some budget cuts and some other projects that keep me busy at the office and over the weekends i'm now maintaining this in the little i have left of my own spare time. I'm still trying to stay up to date, but i just can't manage to stay involved in the actual development and the comunity as i used to, but if anyone needs my help with testing and fixing bugs in my department, my mailbox is always open. Because of this lack of time on my part i can't keep track of all the changes being made and i would appretiate it if somone could drop me a line if there are oracle specific issues ... as i'm doing a lot of DBA work i've got access to Oracle installations of all shapes and sizes, so i can test on almost any Oracle version. As to the current state ... in the last 6 months most of the changes to the code just was keeping up to date with schema changes ... no major issues so i'm quite satisfied with the current state, i still wouldn't suggest it to anyone who would expect it to just plug and play, but if the admin has any DBA-fu moves up his sleeve it performs nicely. I'm planning get back into the game and do some development in a month or so (when i finish one of my other projects) to bring some of the extensions i've developed for my company and my clients into git and update my farms to a more recent version (i'm still running those farms on 1.17) ... ... so ... yeah ... i'm still alive and kicking here ... glad to see ppl still remember i exist :D LP, Jure On 25. 02. 2013 16:40, Chad wrote: