Just wanted to support the idea of adding windowing functions to SQLite as it is the biggest hurdle for me to get others to use it. If size is an issue, I would love to have a build option to enable it.
My $0.02 On Tue, Jun 26, 2018 at 8:27 AM Gert Van Assche <ger...@gmail.com> wrote: > Thanks Olivier, very good to know. > > gert > > Op di 26 jun. 2018 om 09:06 schreef Olivier Mascia <o...@integral.be>: > > > > Le 26 juin 2018 à 07:56, Gert Van Assche <ger...@gmail.com> a écrit : > > > > > > If I would like to use these ranking techniques in SQLite, can I do > this > > > with an extension? Has nobody created a Windowing.dll yet? > > > Just asking. My short term need has been solved, but now that I know > > this, > > > I'm sure I'd like to use this technique later. But I like to stick to > > > SQLite. > > > > Don't want to spoil any news, it is viewable by the public anyway, but > > there are clearly experimental, interesting (and significant) work > ongoing > > by the SQLite developers around SQL windowing functions. A quick look to > > the exp-window-functions branch clearly shows that. > > > > https://www.sqlite.org/src/timeline?n=100&r=exp-window-functions > > > > So it _may_ be possible that you see these features in a later version of > > SQLite, or not. We'll see. I certainly wish the best for this > experience > > which looks good and nicely ongoing. > > > > From experience as a user of SQLite, not all development of features > > through branches get merged to the trunk. Sometimes they stay available > as > > a branch for you to choose to use, sometimes they end up in the main > SQLite > > product (trunk branch). Sometimes they can stay significant time aside > > before one day being merged. I have no specific expectations, and you > > shouldn't have too, I'm just monitoring areas of development that are > > interesting to my eyes and programming needs. Mainly the > > 'server-process-edition' branch, the 'begin-concurrent-pnu' branch and > this > > 'exp-window-functions' branch. > > > > :) > > > > -- > > Best Regards, Meilleures salutations, Met vriendelijke groeten, > > Olivier Mascia > > > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
