Re: [Phpwebsite-developers] Database Design Suggestions

[Jason C. <cam...@xp...>]

I had voted for ADODB before Smarty was found and I think PEAR would be the 
way to go too if we were to use Smarty just for the fact that Smarty uses 
it and like you said it already is in PHP to begin with....



>> 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
> 
> 
> 
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> http://lists.sourceforge.net/lists/listinfo/phpwebsite-developers