On 6/21/07, Michael Baierl <[EMAIL PROTECTED]> wrote:
On Thu, 21 Jun 2007 10:15:08 +0200, Andrej Mocilnik
<[EMAIL PROTECTED]> wrote:
> Hi,
> I'm running PHP5 together with PostgreSQL as DB. I don't know much about
> MDB2, but I think PDO is the best abstract layer for DB access.
> Regardless PHP5 vs PHP4, I think OOP is the only way to keep a project
> flexible while growing and it makes team work easier too. PHP5 can
> benefits of objects properties like inheritance, abstraction,
> interfaces, code reuse, exceptions handling,...
> Programming with object-oriented syntax the code becomes more readable
> and the project can benefits of it a lot.
In my opinion a real DB abstraction that also abstracts all your SQL
queries like MDB2 works against the speed improvements you have when you
use PDO. I don't see what's wrong with
SELECT * FROM table WHERE id=?
compared to
$q = new SelectQuery();
$q->selectFrom('table');
$q->where('id', $id);
.. just making this up now, but I think the first one is much more
readable.
And honestly, on which databases will Roundcube exist? Most probably 98%
MySQL.... don't invest too much time in the 2% other users.... it's not
worth the effort!
Get outta here. ;-)
Roundcube will maintain and improve its support for different database engines.
That has never been a question.
Using a DBAL would improve handling - that's all. For example you
write a query, add a limit and it works on MySQL, Oracle and Informix
- the DBAL would take care of that. I think we are far from looking
into building yet another DBAL. :-)
Cheers,
Till
