Re: [sqlite] FW: GUI INfo

Maxine Nietz writes: > > Is this the way to post a question? You are doing fine, but here is a link I send to new listserv users sometimes: http://www.catb.org/esr/faqs/smart-questions.html ___ sqlite-users mailing list

Re: [sqlite] Window functions?

big stone writes: > - but would a basic subset, like the one described here in March '14 ( > http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/2014-March/051635.html For non-subscribers to read: http://thread.gmane.org/gmane.comp.db.sqlite.general/86702 > ) : >

Re: [sqlite] Window functions?

Stephan Beal writes: > For the small percentage of users who need it (or would even know how to > apply it). i've been following this list since 2006 or 2007 and i recall > this topic having come up only a small handful of times, which implies that > only a small minority of users

Re: [sqlite] Window functions?

> You used the word "immense" which I like - it is an apt description of the > knowledge and effort needed to add windowing functions to SQLite (and > probably any other database engine for that matter). Hehe. I would be interested in any of your specific thoughts on the immensity of it. I can

Re: [sqlite] Window functions?

Simon Slavin writes: > Would you care to explain what advantages Window functions would give us that VIEWs and sub-SELECTs don't > give us ? I'm not being contrary, I'd like to know. I have never compared lines of code between the various approaches, but window functions make it

[sqlite] Window functions?

Has anyone thought in some detail about what it would it take to add window functions to SQLite? http://www.postgresql.org/docs/9.4/static/tutorial-window.html For data analysis shops like us (think SAS + baroquely complex Excel + lots of graphs), SQLite with window functions would be immense.