On Tue, 1 Feb 2005, Dave Howorth wrote:
> Sebastian Riedel wrote:
> > Plural table names are bad bad bad!
>
> They work perfectly with my loader :)
> That was one inconsequential factor that drove me to write it.
I don't see your loader on CPAN...
>
> > Use id as primary key...
> >
> > This is better.
>
> Well, it's doubleplus conformant with the thought police maybe :)
With Sebastian, and nobody else including major works on database theory,
ontology, semantics....you don't see Ullman writing schema with 'id'.
Nor Codd. I don't believe Tim Berners-Lee used that as an identifier
in his work on the Semantic Web.
Individual objects may, or may not be, plural. Tables of rows certainly
make sense as plural names. Or worse yet, collection names may be another
word altogether. think about the plural and singular of clothing.
We have an article, not item, of clothing and we have a collection of
clothes....or a line of clothes is a term often used in the fashion
industry (and therefore in a system catering to fashion photographers...).
We speak of a particular designer's line of clothes, their (e.g.) fall
collection, and a particular garment.
Woops! garment! not clothing!
I spend a LOT of time working and thinking about stuff like this.
I need Maypole and Class::DBI::Loader etc. to not get in my way and make
extra work.
_______________________________________________
maypole mailing list
maypole at lists.netthink.co.uk
http://lists.netthink.co.uk/listinfo/maypole
This archive was generated by hypermail 2.1.3 : Thu Feb 24 2005 - 22:25:58 GMT