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
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.
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
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
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
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