On Sun, May 04, 2008 at 09:33:50AM -0700, Steve Atkins wrote: > Part of the problem here might be the wish to avoid a natural > primary key in the database schema, preferring a synthetic > primary key even when there's a perfectly good natural > primary key. > > That's something that I expect to see from the ruby on > rails crowd, not the (presumably more pragmatic) perl folks.
Actually, sometimes a synthetic primary key even when there's a perfectly good natural one is important. For e.g. InnoDB always clusters by the PK, so depending on your access patterns it can be a hell of a lot more efficient. Pragmatism is a many-edged sword :) -- Matt S Trout Need help with your Catalyst or DBIx::Class project? Technical Director http://www.shadowcat.co.uk/catalyst/ Shadowcat Systems Ltd. Want a managed development or deployment platform? http://chainsawblues.vox.com/ http://www.shadowcat.co.uk/servers/ _______________________________________________ List: Catalyst@lists.scsys.co.uk Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/ Dev site: http://dev.catalyst.perl.org/