Re: Draft TAP document inputs

From: Patrick Dowler <patrick.dowler-at-nrc-cnrc.gc.ca>
Date: Mon, 23 Apr 2007 09:04:31 -0800


On Monday 23 April 2007 05:37, Kona Andrews wrote:
> In general, I don't think the DB administrators would be happy with a
> compulsory directSQL method anyway, so we need to allow for system
> administrators wanting to switch off the directSQL bit of TAP.

I think that's an understatement: personally I think is is almost crazy to allow it in most cases because you need to know too much to formulate good SQL... by "good SQL" I just mean reasonably efficient (which means knowing the DB platform at least) and producing correct results (which means rather explicit deep understanding of the schema and content).

I really cannot foresee allowing directSQL to any of the tables I have developed. In fact, I can't even feasibly write good SQL manually and always use tools that generate the SQL for me -- and I designed the schema :)

-- 

Patrick Dowler
Tel/Tél: (250) 363-6914                  | fax/télécopieur: (250) 363-0045
Canadian Astronomy Data Centre   | Centre canadien de donnees astronomiques
National Research Council Canada | Conseil national de recherches Canada
Government of Canada                  | Gouvernement du Canada
5071 West Saanich Road               | 5071, chemin West Saanich
Victoria, BC                                  | Victoria (C.-B.)
Received on 2007-04-23Z19:21:17