November 4th, 2009 by Leons Petrazickis
I’m hosting a workshop today at CASCON. The resources for it are below.
Materials
Resources
Downloads
Posted in db2, mediawiki | No Comments »
September 23rd, 2009 by Leons Petrazickis
MediaWiki 1.15 was released with partial DB2 support, but unfortunately there were some changes to the database schema that I missed and it didn’t work out of the box. Since then, I’ve committed several fixes to the main development trunk. The trunk is currently destined to become 1.16alpha, though theoretically I could backport these to the 1.15 branch.
My Apache is currently crashing willy-nilly on startup. Hopefully, there are no silly development bugs left in.:-)
Posted in mediawiki | No Comments »
August 15th, 2009 by Leons Petrazickis
No fresh download quite yet, but I just made a large commit to the MediaWiki source of the last week’s work. This is going in the trunk — aka MediaWiki 1.16alpha. There are a few bugs I hope to catch this weekend, at which point I’ll put up a fresh archive of working code.
config/index.php:
* Made installation on IBM DB2 more robust
* Replaced E_ALL error reporting mode with E_ALL | E_STRICT
includes/db/DatabaseIbm_db2.php
* Enabled DB2_CASE_LOWER option for all connections and statements
* Enabled DB2_DEFERRED_PREPARE_ON for all statements — delays statement preparation until execution to reduce database load
* Enabled DB2_ROWCOUNT_PREFETCH_ON for all statements — makes db2_num_rows() work correctly
* Cleaned up error handling
* Cleaned up method signatures
* Rewrote insertion to use prepared statements — required for inserting more than 32k of text
* Insertion will never try to insert a NULL value into a primary key
* Now relying on implicit casting in DB2 9.7 — no longer sniffing to see if column is integer or string before adding quotes
* Implemented actual prepared statement handling — required for correct INSERT, UPDATE behaviour
* In install mode, the class will print additional messages to the install bullet scroll
* Added bitwise operation abstraction (BITNOT, BITAND, BITOR)
includes/specials/SpecialAncientpages.php
* Added skeleton DB2 syntax to the database-specific switch statement
maintenance/convertLinks.inc
* Made limit clause database-agnostic
maintenance/ibm_db2/README
* Contents replaced with link to http://www.mediawiki.org/wiki/Manual:IBM_DB2
maintenance/ibm_db2/tables.sql
* Revised types to better match the main schema
* All tables names now the same as MySQL — was using Postgres schema’s names before
* Added some additional indices
* Added the change_tag, tag_summary, valid_tag, user_properties, log_search, and l10n_cache tables
* Added several new columns
maintenance/storage/compressOld.inc
* Made limit clause database-agnostic
Posted in mediawiki | No Comments »
June 23rd, 2009 by Leons Petrazickis
The DB2 data movement tool sounds like an excellent way to move stuff from, say, MySQL to DB2. I should see if I can use it to move a MediaWiki database.
Speaking of MediaWiki, I swear I’ll have a patched zip of 1.15 ready any day now.:-)
Posted in db2, mysql, mediawiki | No Comments »
