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: [email protected]
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/