Opened 5 years ago

Closed 4 years ago

#31030 closed Cleanup/optimization (fixed)

register SQLite functions as deterministic on Python 3.8

Reported by: Sergey Fedoseev Owned by: Sergey Fedoseev
Component: Database layer (models, ORM) Version: dev
Severity: Normal Keywords: sqlite
Cc: Triage Stage: Accepted
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no


On Python 3.8 deterministic parameter was added to sqlite3.Connection.create_function() , it should be used when possible to allow SQLite to perform additional optimizations.

Change History (6)

comment:1 by Simon Charette, 5 years ago

Triage Stage: UnreviewedAccepted

We'll want to makes to not do so for functions using global or connection state (e.g. timezone).

Last edited 5 years ago by Simon Charette (previous) (diff)

comment:2 by Sergey Fedoseev, 5 years ago

comment:3 by Sergey Fedoseev, 5 years ago

Has patch: set

comment:4 by Mariusz Felisiak, 5 years ago

Needs documentation: set
Owner: changed from nobody to Sergey Fedoseev
Status: newassigned

comment:5 by Mariusz Felisiak, 4 years ago

Needs documentation: unset

comment:6 by Mariusz Felisiak <felisiak.mariusz@…>, 4 years ago

Resolution: fixed
Status: assignedclosed

In 026719cf:

Fixed #31030 -- Registered SQLite functions as deterministic on Python 3.8+.

Note: See TracTickets for help on using tickets.
Back to Top