← Back to team overview

mahara-contributors team mailing list archive

[Bug 572189] Re: Firebird support development

 

Just to keep in touch with this ....
I have been struck with multiple disk failures on 6 month old Seagate disks over the last few weeks to the point where Seagate have actually agreed to try and recover one free of charge due to the problem. Disks have also failed at customer sites! While material now lost can be recovered other ways, it's eating up a lot of time which will not be compensated for by Seagate. 

I AM hoping to have an Hg based local repository with my own work in so
that all of the developments are fully documented, and am still trying
to find the time to merge a couple of mahara 'tricks' back into the
bitweaver code base!

At the present time it does not look like the fundamental design
problems in PDO will be addressed in the short term, so as long as that
path is avoided there should be no problem with other cross database
development.

-- 
Firebird support development
https://bugs.launchpad.net/bugs/572189
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.

Status in Mahara ePortfolio: Confirmed

Bug description:
Attached are a pair of drivers to add Firebird as an option on the supported databases. Class goes to xmldb library, and the adodb driver replaces the one currently provided.

The next step on this exercise is to work out how to handle wrapping of field names with double quotes. The normal practice has been to use 'backtick' as a hook to identify both field and table names that need processing. This is then replaced or removed as required before the SQL is run. This would - I think - tidy up a problem I am seeing currently in the code base where some fields have had double quotes added in the scripts, or bodge case statements adjust things for MySQL or Postgres .... A generic fix would allow the availability of other databases to be expanded? And I am happy to look at handling that.





References