Re: [aerogear-dev] paging installations new console
On Thu, 8 May 2014 09:19:34 +0200
Erik Jan de Wit <edewit(a)redhat.com> wrote:
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?
Sure. SQL view might only be an performance optimization for some of the
databases. Optional feature tbd in future.
Cheers,
Erik Jan