News for hackers. Stuff that matters.
Re:SQLite Release 3.25.0 adds support for window functions by est on Wednesday August 15, 2018 @05:26AM (#17764714)
This is super cool.

Does anyone know how to upgrade python3's sqlite module to the latest version?

Re:SQLite Release 3.25.0 adds support for window functions by mci on Wednesday August 15, 2018 @09:01AM (#17765675)
Use APSW instead of sqlite3: https://rogerbinns.github.io/apsw/
Re:SQLite Release 3.25.0 adds support for window functions by coleifer on Wednesday August 15, 2018 @11:19AM (#17766692)
You can use https://github.com/coleifer/pysqlite3

It even supports user-defined window functions using the new sqlite apis.

Re:SQLite Release 3.25.0 adds support for window functions by simonw on Wednesday August 15, 2018 @01:56PM (#17768181)
Charles provided really great documentation on how to build this here: http://charlesleifer.com/blog/compiling-sqlite-for-use-with-...

Or if you're feeling lazy (like I was), there's a fork of his library at https://github.com/karlb/pysqlite3 which compiles the 3.25.0 amalgamation by default. This worked for me:

    $ python3 -mvirtualenv venv
    $ source venv/bin/activate
    $ pip install git+git://github.com/karlb/pysqlite3
    Collecting git+git://github.com/karlb/pysqlite3
    ...
    Installing collected packages: pysqlite3
    Successfully installed pysqlite3-0.2.0
    $ python
    Python 3.6.5 (default, Mar 30 2018, 06:41:53) 
    [GCC 4.2.1 Compatible Apple LLVM 9.0.0 (clang-900.0.39.2)] on darwin
    Type "help", "copyright", "credits" or "license" for more information.
    >>> import pysqlite3
    >>> pysqlite3.connect(":memory:").execute("select sqlite_version()").fetchall()
    [('3.25.0',)]
Re:SQLite Release 3.25.0 adds support for window functions by MrEfficiency on Wednesday August 15, 2018 @10:16AM (#17766151)
Is this going to be an issue?

Or just a benefit?

Ive had python libraries break with updates.