Re: [sqlite] basic "Window function"

[big stone]

"howzit" is my prefered greetings word.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] basic "Window function"

[Darren Duncan]

On 2014-03-13, 8:17 AM, big stone wrote:

Hello again,

Windowing functions are :
- not easy to workaround with create_function(),
- a truly "sql core" motor functionality.

The only use case that I have, is the small subset I described earlier :
- inside one 'select' :
.  several sum/min/avg/max (different fields) ,
. all with exactly the same "(over partition by ... a series of fields)",
- no ranking, no order by inside this partition.

==> It allows to show a list of records at a certain level, with
statistical analysis done at a completely different (higher or lower) level.

Is it a feature SQLite team would like to do ?

Is there anyone else, (besides little bee), that would "like" this request
?


I know I would like to see this, a lot.

Its one of those things that, if implemented in the core, should not be any more 
effort than it takes to implement aggregate functions with GROUP BY, and it 
would give users a great amount of power.


I was very happy to see WITH get into the core, and windowing is similarly 
something you can get a lot of power from with relatively small core effort.


If SQLite does this, I will be happy that there is yet another significant way 
in which SQLite is more powerful than MySQL (but not PostgreSQL), the WITH 
support being another, and subjecting data definition to transactions is another.


-- Darren Duncan

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] basic "Window function"

[RSmith]

On 2014/03/13 20:02, Petite Abeille wrote:

On Mar 13, 2014, at 4:17 PM, big stone  wrote:


Is there anyone else, (besides little bee), that would "like" this request?

"Oh! Oh pick me! Pick me! Me! Me! M!” — Donkey, Shrek


Hehe, I live in a Country with 11 official languages. Needless to say the actual dialects used are regularly somewhere in between 
those official lines... the sort of thing would make a purist shudder.  Either way, when lots of people from different linguistic 
origins work together, they sometimes speak a common language that invariably ends up being a bit of a mishmash and often misses 
complete words for which a descriptive might be pressed into service and, on occasion, becomes a mainstream constituent of the 
vernacular.


So it is that in one of these work-languages most widely spoken, my most favourite term is for a a Bee (a rather small English word) 
which ended up being referred to as "Picannini flymasjien yena kona lo jam", which in direct translation amounts to: "Very small 
fly-machine he's got jam".


Some beauty lies in the fact that the whole "machine" bit is completely unneeded "small fly" would have sufficed, but the lovely 
rhyme and metrum surfaces everywhere in the culture.


:)


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] basic "Window function"

[Petite Abeille]

On Mar 13, 2014, at 4:17 PM, big stone  wrote:

> Is there anyone else, (besides little bee), that would "like" this request?

"Oh! Oh pick me! Pick me! Me! Me! M!” — Donkey, Shrek

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] basic "Window function"

[big stone]

Hello again,

Windowing functions are :
- not easy to workaround with create_function(),
- a truly "sql core" motor functionality.

The only use case that I have, is the small subset I described earlier :
- inside one 'select' :
   .  several sum/min/avg/max (different fields) ,
   . all with exactly the same "(over partition by ... a series of fields)",
- no ranking, no order by inside this partition.

==> It allows to show a list of records at a certain level, with
statistical analysis done at a completely different (higher or lower) level.

Is it a feature SQLite team would like to do ?

Is there anyone else, (besides little bee), that would "like" this request
?

(http://upload.wikimedia.org/wikipedia/commons/1/13/Facebook_like_thumb.png)
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] basic "Window function"

[Petite Abeille]

On Mar 1, 2014, at 7:39 PM, big stone  wrote:

> Would it be possible to get a small basic subset of the sql  windowing
> function for Sqlite 3.8.5  ?

Yes! Pretty please :)

Supporting windowing functions (aka analytics) would be a major  breakthrough.

http://www.orafaq.com/node/55

Here is a pretty nifty algorithm using analytics, the "Tabibitosan method”:

http://boneist-oracle.livejournal.com/7389.html
http://forums.oracle.com/forums/thread.jspa?messageID=3989678



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users