Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:71632 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 74343 invoked from network); 27 Jan 2014 09:43:44 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 27 Jan 2014 09:43:44 -0000 Authentication-Results: pb1.pair.com smtp.mail=lester@lsces.co.uk; spf=permerror; sender-id=unknown Authentication-Results: pb1.pair.com header.from=lester@lsces.co.uk; sender-id=unknown Received-SPF: error (pb1.pair.com: domain lsces.co.uk from 217.147.176.204 cause and error) X-PHP-List-Original-Sender: lester@lsces.co.uk X-Host-Fingerprint: 217.147.176.204 mail4.serversure.net Linux 2.6 Received: from [217.147.176.204] ([217.147.176.204:54345] helo=mail4.serversure.net) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id E9/22-12631-F4A26E25 for ; Mon, 27 Jan 2014 04:43:44 -0500 Received: (qmail 30725 invoked by uid 89); 27 Jan 2014 09:43:40 -0000 Received: by simscan 1.3.1 ppid: 30719, pid: 30722, t: 0.0665s scanners: attach: 1.3.1 clamav: 0.96/m:52 Received: from unknown (HELO linux-dev4.lsces.org.uk) (lester@rainbowdigitalmedia.org.uk@81.138.11.136) by mail4.serversure.net with ESMTPA; 27 Jan 2014 09:43:40 -0000 Message-ID: <52E62ACF.7030301@lsces.co.uk> Date: Mon, 27 Jan 2014 09:45:51 +0000 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:26.0) Gecko/20100101 Firefox/26.0 SeaMonkey/2.23 MIME-Version: 1.0 To: internals@lists.php.net References: <52E29253.2000801@lsces.co.uk> <52E2924B.6080002@ajf.me> <52E299D4.6040102@garfieldtech.com> <52E2C98C.6010005@lerdorf.com> <52E61045.9000800@sugarcrm.com> In-Reply-To: <52E61045.9000800@sugarcrm.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Subject: Re: [PHP-DEV] Ruminations on PHP 5++ From: lester@lsces.co.uk (Lester Caine) 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