[Qgis-developer] have aggregate/window expressions ever been discussed?

[Vincent Picavet]

Hello Andreas,

Le mardi 27 mai 2014 10:28:13, Andreas Neumann a écrit :
> Hi,
> 
> We would definitely need this functionality for our application modules
> - we need functions like "min", "max", "mean", "sum", "average" to work
> on 1:n relations.
> 
> Now that we have relations in QGIS, I think that aggregate functions are
> a logical next step. Something to seriously consider in 2.6.

As already stated before, I am worrying about current developments around a 
lot of features looking like database features :
* Table joins
* relations
* "SQL-like" processing
* .. including aggregates

Implementing all these features on top of QGIS seems reinventing the wheel, 
and database wheels are particularly hard to design and implement well.
I really think we should re-study the global design of such features to have a 
clear and clean strategy instead of stacking features on features, lacking 
coherency.

As stated by Regis, basing this work on top of SQLite may be the best option, 
but more study has to be done and a general agreement is needed to go this 
way.

Vincent

> 
> Andreas
> 
> Am 23.05.2014 17:34, schrieb G. Allegri:
> > Recently I had to calculate the relative dimension of a polygon relative
> > to the others of the same class. I know there are a lot of way to do it,
> > inside and outside QGIS, but I wondered if field calculator (and
> > expressions in general) couls be extended to accompish this kind of
> > tasks.
> > 
> > The approach would be something similar WINDOW functions in Postgresql
> > [1], where for each record a new value will be calculated on the basis
> > of other records (filtered or not).
> > 
> > Has this ever been discussed? Is it something that could fit QGIS
> > expressions?
> > 
> > giovanni
> > 
> > [1] http://www.postgresql.org/docs/9.1/static/tutorial-window.html
> > 
> > 
> > 
> > _______________________________________________
> > Qgis-developer mailing list
> > Qgis-developer at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/qgis-developer
> 
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer