piwik framework firebird conversion

Created by: Lester Caine, Last modification: 06 Jun 2012 (11:56 BST)

Need to update this ...

But the current codebase can be followed at the Hg Repository

Work is also progressing on tidying the test suite and the progress can be found here

Porting piwik to work with a Firebird database.

DONE

  1. Add Firebird as a database option
  2. Remove backticks
  3. INSERT IGNORE INTO => UPDATE OR INSERT INTO
  4. LIMIT needs to be accessed via db->limit() function in zend ( Use ROWS for speed )
  5. Reserved word fields need renaming
    value -> a_value  ... on archive tables - reserved word
    count -> lp_count ... on log profiling - reserved word
    startDate -> startdate ... can't manage mixed case field names
    ?
  6. Disable locking, not required for Firebird
  7. 'OPTIMIZE TABLE' not needed in Firebird, garbage collection is a background task
  8. Drop use of lastInsertId() - switch to SQL standard sequence numbers (generators in Firebird)
  9. Tracker Firebird Driver seems to be running nicely now, data being gathered stabily
  10.  

TODO

  1. SHOW STATUS needs looking at
  2.