Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

add *deterministic* parameter to sqlite3.Connection.create_function() #78222

Closed
sir-sigurd mannequin opened this issue Jul 4, 2018 · 3 comments
Closed

add *deterministic* parameter to sqlite3.Connection.create_function() #78222

sir-sigurd mannequin opened this issue Jul 4, 2018 · 3 comments
Labels
3.8 (EOL) end of life extension-modules C modules in the Modules dir type-feature A feature request or enhancement

Comments

@sir-sigurd
Copy link
Mannequin

sir-sigurd mannequin commented Jul 4, 2018

BPO 34041
Nosy @berkerpeksag, @sir-sigurd
PRs
  • bpo-34041: Added *deterministic* parameter to sqlite3.Connection.create_function(). #8086
  • Note: these values reflect the state of the issue at the time it was migrated and might not reflect the current state.

    Show more details

    GitHub fields:

    assignee = None
    closed_at = <Date 2018-07-08.07:09:57.643>
    created_at = <Date 2018-07-04.10:04:14.357>
    labels = ['extension-modules', 'type-feature', '3.8']
    title = 'add *deterministic* parameter to sqlite3.Connection.create_function()'
    updated_at = <Date 2018-10-04.21:05:46.346>
    user = 'https://github.com/sir-sigurd'

    bugs.python.org fields:

    activity = <Date 2018-10-04.21:05:46.346>
    actor = 'hydroflask'
    assignee = 'none'
    closed = True
    closed_date = <Date 2018-07-08.07:09:57.643>
    closer = 'berker.peksag'
    components = ['Extension Modules']
    creation = <Date 2018-07-04.10:04:14.357>
    creator = 'sir-sigurd'
    dependencies = []
    files = []
    hgrepos = []
    issue_num = 34041
    keywords = ['patch']
    message_count = 3.0
    messages = ['321027', '321263', '327086']
    nosy_count = 3.0
    nosy_names = ['berker.peksag', 'hydroflask', 'sir-sigurd']
    pr_nums = ['8086']
    priority = 'normal'
    resolution = 'fixed'
    stage = 'resolved'
    status = 'closed'
    superseder = None
    type = 'enhancement'
    url = 'https://bugs.python.org/issue34041'
    versions = ['Python 3.8']

    @sir-sigurd
    Copy link
    Mannequin Author

    sir-sigurd mannequin commented Jul 4, 2018

    SQLiter 3.8.3 and higher allows to mark created functions as deterministic to allow additional optimizations. There isn't currently a way to it from Python.

    https://sqlite.org/c3ref/create_function.html

    @sir-sigurd sir-sigurd mannequin added extension-modules C modules in the Modules dir type-feature A feature request or enhancement labels Jul 4, 2018
    @berkerpeksag berkerpeksag added the 3.8 (EOL) end of life label Jul 6, 2018
    @berkerpeksag
    Copy link
    Member

    New changeset 0830858 by Berker Peksag (Sergey Fedoseev) in branch 'master':
    bpo-34041: Allow creating deterministic functions in Connection.create_function() (GH-8086)
    0830858

    @hydroflask
    Copy link
    Mannequin

    hydroflask mannequin commented Oct 4, 2018

    Any possible way we can backport these changes to Python 3.5+? 3.8 is a ways away.

    @ezio-melotti ezio-melotti transferred this issue from another repository Apr 10, 2022
    Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
    Labels
    3.8 (EOL) end of life extension-modules C modules in the Modules dir type-feature A feature request or enhancement
    Projects
    None yet
    Development

    No branches or pull requests

    1 participant