Two in one:
On 8 May,2014, at 8:25 , Matthias Wessendorf <mwessendorf(a)gmail.com> wrote:
This query will give the total number of installations for each variant, but only for
android. So what I would like to suggest it to simplify the data model and only have a
relation with variants instead of one per type this will also make the data model more
extendable (when a new device type is introduced the data model doesn’t have to change).
If grouping of these variants is needed clients will need to do it themselves.
that would still allow us to say "Android-free variant has 10000 installations; iPad
variant has 5000 installations", right ?
Right, but do it in one query instead of x and have a more flexible data model at the same
time.
On 7 May,2014, Karel Piwko wrote:
I think it is a good idea to simplify underlying model. Could we
additionally provide SQL views that groups only one variant and expose it
via REST point?
Right I would like to keep the REST endpoint the same as this is our interface. Don’t know
if we should base the grouping on views as we should support multiple databases, and like
you said don’t know if this can be done for H2, for now let’s keep it simple and just do a
`group by` query?
Cheers,
Erik Jan