[aerogear-dev] paging installations new console

[Karel Piwko]

On Thu, 8 May 2014 09:19:34 +0200
Erik Jan de Wit <edewit at redhat.com> wrote:

> Two in one:
> 
> On 8 May,2014, at 8:25 , Matthias Wessendorf <mwessendorf at 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