Do we have an official position on cross database compatibility?
Some of the MediaWiki SQL is in separate files and can be easily directed at a specific database engine. A lot of it though is scattered as fragments though other code and is going to be run on any engine we connect to.
Specifically, do we use MySQL specific syntax that is more efficient (but breaks elsewhere) or do we attempt to write lowest common denominator SQL that will run more places, but not run as efficiently on our primary target?
The only SQL coding standard doc I have seen treats Database and MySQL as synonyms: http://www.mediawiki.org/wiki/Manual:Coding_conventions/Database
Luke Welling
On Tue, Feb 26, 2013 at 5:37 AM, Dmitriy Sintsov questpc@rambler.ru wrote:
26 Февраль 2013 г. 14:27:06 пользователь Nikola Smolenski (
smolensk@eunet.rs) написал:
On 26/02/13 04:18, Matthew Flaschen 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.
I am wondering if it would make sense to give up on SQL, make universal table creation functions in PHP, the same way there are for other queries, and use that. Has anyone tried this before, is there other software that works like this?
http://stackoverflow.com/**questions/108699/good-php-orm-**libraryhttp://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
______________________________**_________________ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/**mailman/listinfo/wikitech-lhttps://lists.wikimedia.org/mailman/listinfo/wikitech-l