This issue tracker has been migrated to GitHub, and is currently read-only.
For more information, see the GitHub FAQs in the Python's Developer Guide.

Author erlendaasland
Recipients erlendaasland, iljau
Date 2020-05-24.20:24:16
SpamBayes Score -1.0
Marked as misclassified Yes
Message-id <1590351857.12.0.399306740255.issue40617@roundup.psfhosted.org>
In-reply-to
Content
This is a good idea, but I think the Python interface should stay the same.

From the user perspective, you'd only need to implement the 'value' and 'inverse' callbacks to transform your aggregate class into an aggregate window class.

From the CPython perspective, we'd only need to use sqlite3_create_window_function() instead of sqlite3_create_function_v2(), if we are compiling against SQLite 3.25.3 or newer.

I guess it would be nice to output a warning if the user aggregate class contains 'value' and 'inverse' callbacks, but sqlite3 _doesn't_ support aggregate window functions.
History
Date User Action Args
2020-05-24 20:24:17erlendaaslandsetrecipients: + erlendaasland, iljau
2020-05-24 20:24:17erlendaaslandsetmessageid: <1590351857.12.0.399306740255.issue40617@roundup.psfhosted.org>
2020-05-24 20:24:17erlendaaslandlinkissue40617 messages
2020-05-24 20:24:16erlendaaslandcreate