RE: [binarycloud-dev] QueryManager / Standards

[Andreas A. <a.a...@th...>]

Hi Alex,

> My point is that if we establish fairly restrictive standards about table
> and field naming, we can get around those problems and ensure
> compatibility between oracle, mySQL, and Postgres:

Agreed if those conventions do really work with all Metabase supported dbms.
Or at least with the most widely used ones. I would add Informix to the list
above.

> Re: the above, I'd prefer to have something that works with a standard,
> instead of trying to build code that works with 'everything'.
Ok, I see your point. I'm not a db expert an my experience with different
dbms are limited. Would a standard proposed in the other mail work with most
dbms without trouble?

What does Manuel think?

> I'm not saying QueryManager should process incoming queries (like
> strtoupper) but I think we should standardize those names elsewhere in the
> system.
Ok, and everybody !must! strictly obey. I.e. writing a query with mysql

SELECT foo FROM bar

will return the columnheader "foo" even if the field ist named "FOO". So the
queries must entirely be written UPPERCASE.

Andi