Re: [binarycloud-dev] QueryManager / Standards

[Alex B. <en...@tu...>]

> Andreas Aderhold wrote:
> 
>>> for example, in oracle both of these queries work:
>>> select newsid from news;
>> 
>> How are the column headers returned for this query also in lowercase? Or in
>> uppercase? In MySQL they are returned as typed in the query.
>> 
> 
> Wouldn't it be better just to define column and table names as
> case-insensitive and always uppercase/lowercase them in QueryManager before
> doing a MetaBase query?

1)
yes that is entirely possible

2)
I don't like it because I think it's a hell of a lof more elegant to have
'name sync' between entities, entity paths, and sql.

> Then, the user will be free in choosing their naming convention.
> Doesn't Oracle (or some other databases) really support '_'? In that case,
> especially, allowing the user to mix upper and lower cases in the names would
> be nice. E.g. "FurbeeId" is more readable than "furbeeid" or "FURBEEID".
> 
> Just my 2 pence :-)

The above is opinion, not doctrine... does anyone else have an opinion on
this one?

_a




> --
>        * *       Konstantin Chuguev           Francis House
>     *      *     Application Engineer         112 Hills Road
>   *              Tel: +44 1223 302992         Cambridge CB2 1PQ
> D  A  N  T  E      WWW: http://www.dante.net    United Kingdom
> 
> 
> 
> 
> _______________________________________________
> binarycloud-dev mailing list
> bin...@li...
> http://lists.sourceforge.net/lists/listinfo/binarycloud-dev
>