[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] Questions re database schema - nomenclature

From: Karsten Hilbert
Subject: Re: [Gnumed-devel] Questions re database schema - nomenclature
Date: Tue, 31 Aug 2004 11:22:43 +0200
User-agent: Mutt/

> 1) NOMENCLATURE in table generating queries:
>       -Given that one will be doing various joins
>        (and I'm not sure if 8.0 supports outer),
Richard, you gotta be kidding us. Why do you think
we don't use MySQL ?

> (
>   id_country serial NOT NULL,
>   country_code char(2) NOT NULL,
>   country_name text NOT NULL, 
>   country_deprecated date,..... etc
Never. Simply too much typing for no gain at all. PostgreSQL
already supports true namespace scoping at various levels:

qualified field names:


alias-qualified field names:

 ... lst.code from lu_state lst ...

schema qualified table.field names:

Eg. no need to invent artificial *namespaces* (this is
different from naming conventions for grouping or "typing"
objects which does make sense).

> manager), so have real life experience in the difficulties of implementing 
> and maintaining code - hence my personal insistance on good naming practices
Who would argue with that conclusion ?

GPG key ID E4071346 @
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

reply via email to

[Prev in Thread] Current Thread [Next in Thread]