Scott Stevens added the comment:
Due to the SQLite "Magellan" bug, I'd suggest this be 3.26+.
Details: https://blade.tencent.com/magellan/index_en.html
See also: https://bugs.python.org/issue35360
--
nosy: +Scott Stevens
___
Python tracker
Ronald Oussoren added the comment:
My latter points makes it possible to define custom windowing functions in
Python, similar to how it is already possible to define other SQLite functions
in Python.
--
___
Python tracker
Big Stone added the comment:
hum. On Windows at least, just drop-in replace the sqlite3.dll per the new
sqlite-3.25 dll and the window functions just works.
==> I don't see the need for your latter point, at least on Windows.
checked with sqlite_bro on Python-3.6.7rc1 with example:
CREATE
Ronald Oussoren added the comment:
To completely do this requires two things:
1) Upgrade SQLite included in a number of binary distributions
2) Update the sqlite extension to allow creating custom window functions in
Python
The latter is definitely something that cannot be done in a
New submission from Big Stone :
sqlite-3.25 now includes window functions, something very important in modern
SQL.
https://www.sqlite.org/windowfunctions.html
Could it be included in next Python maintenance release ?
--
messages: 327253
nosy: Big Stone
priority: normal
severity: