Re: [sqlite] FW: GUI INfo

2014-09-10 Thread forkandwait
Maxine Nietz nevadamax@... 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

[sqlite] Window functions?

2014-08-25 Thread forkandwait
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.

Re: [sqlite] Window functions?

2014-08-25 Thread forkandwait
Simon Slavin slavins@... 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

Re: [sqlite] Window functions?

2014-08-25 Thread forkandwait
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?

2014-08-25 Thread forkandwait
Stephan Beal sgbeal@... 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 feels

Re: [sqlite] Window functions?

2014-08-25 Thread forkandwait
big stone stonebig34@... 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 ) : . be