3 ms·

So, basically a kind of static type system? Anyway, reporting is a very hard problem. I don't know if exist a truly good way to solve it in a general case. --

by mamcx 10y ago

So, basically a kind of static type system? Anyway, reporting is a very hard problem. I don't know if exist a truly good way to solve it in a general case. --- Is part of this not solve with views? Any example to showcase the trouble?

RBerenguel 10y ago
Don't have examples (that I can show). It's trying to be a static check (more than type, but it's close enough) system, indeed. With views, we can isolate the used data, as long as we don't modify too much the underlying structure. Also, the biggest chunks of SQL we handle are essentially "computational": take this, join with that, mangle a lot what we have now, repeat several times and get an output we can use. Can't avoid the big part in the middle