Stas Malyshev wrote:
Figuring how to do databases uniformly and take PDO into 21st century
would be a huge boon, people could stop reinventing the bicycle of
database abstraction layer over and over. We though PDO would take this
niche but looks like it wasn't enough.
The problem with PDO is that it offers no management of the Schema or SQL and only partial management of even the data. As an example of the mess currently being supported, I have been asked to look at replacing a W2k based CCTV management system. The system is working fine, it's only 'politics' that is driving the change, but paying for new software is something that is not being provided by the 'powers to be'. ZoneMinder looks like it will provide a Linux based alternative. It's PHP powered on the interface, so something I'm comfortable with except ... it's still only using mysql driver! Adding to the fun, the database management is python scripts, and other sections of the package are using perl. I have yet to actually get it working on one of my machines as one part or another keeps throwing errors so I've not yet even seen if it's worth spending time reworking, but one of the first steps if I do find it usable will be to rework the database interface and get it working with Firebird.
Interestingly while the roadmap says 'Replace all tabs with 4 spaces!' there is no mention of upgrading to mysqli :)
--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk