4 ms·
hah, exactly. “application-specific views...Going back decades”, or “substitute Stored Procs for views”. It’s not really much extra overhead to use a schema+vi
by no-s 5y ago
hah, exactly. “application-specific views...Going back decades”, or “substitute Stored Procs for views”.
It’s not really much extra overhead to use a schema+views. I ask developers to avoid creating views with “Select *”, always specify the columns desired.
Further decoupling is possibly beneficial, e.g. CQRS is wonderful perspective for designing data models that may be more easily distributed or cacheable (by explicitly choosing to separate query schema from modification schema).