Re: [Phpwebsite-developers] Database Design Suggestions

[Todd O. <to...@da...>]

> 1. All primary keys should be integer (size, indexing speed,
comparability).
> This may cause issues for heavily populated tables (forums, etc), though
we
> can design around it.

I agree that there should be an integer primary key for every table.  I
don't understand your concern with large forums.  The indexing is still more
efficient with integers.

As far as database abstraction goes, let me cast my vote for PEAR.  Smarty
uses PEAR (although not for databases), phplib will be integrated into PEAR,
and I believe PEAR will become the standard, whether phpWebSite adopts it or
not--it's in the PHP distribution already.  Having reviewed the classes, I
believe they will serve us well.

--Todd