sqlite3 window functions support using python2.7

[Omkumar]

Hi,

I am using sqlite3 library in python2.7. I wanted to make use of the Window function(row_number) in the application I am working on.

I am using a Ubuntu 16.04 machine.

when I run sqlite3.sqlite_version in my python I get 3.22.0.

It would be very help full if someone could let me know how do I upgrade my sqlite version being used in python to >3.25 to support Window function.

Thanks

[Larz60+]

see: https://docs.python.org/3.1/library/2to3.html

[Gribouillis]

This question is independent from python. The version of sqlite3 that comes with Ubuntu 16.04 is 3.11.0 as can be seen from

Output:
apt show sqlite3

The question is whether one can upgrade sqlite3 in Ubuntu. This seems far from obvious.