Skip to content

Deprecate sqlite3.version and sqlite3.version_info #93370

Closed
Closed
Deprecate sqlite3.version and sqlite3.version_info#93370
#95017 (+2)
Labels
3.12only security fixeseasytopic-sqlite3type-featureA feature request or enhancement

Description

@erlend-aasland
erlend-aasland
opened on May 31, 2022

The sqlite3.version and sqlite3.version_info attributes have historically created some confusion, as they are sometimes mistaken for the SQLite 3 version number. They used to reflect the pysqlite1 version number, until the external pysqlite package stopped upstreaming changes to the stdlib sqlite3 module2, but today they carry no meaning or practical value3.

In order to avoid future frustration, I suggest to deprecate sqlite3.version and sqlite3.version_info in 3.12, and remove them in 3.14.

See also discussion on Discourse

Footnotes

  1. The sqlite3 stdlib module was forked off of the external pysqlite module around 2005. ↩

  2. Somewhere around 2015, IIRC. ↩

  3. sqlite3.version is set to the value '2.6.0', and sqlite3.version_info is set to the value (2, 6, 0). ↩

Activity

  1. erlend-aasland
    added
    type-featureA feature request or enhancement
    easy
    3.12only security fixes
    topic-sqlite3
    on May 31, 2022
  2. erlend-aasland
    added this to sqlite3 issueson May 31, 2022
  3. erlend-aasland
    moved this to TODO: Feature in sqlite3 issueson May 31, 2022
  4. erlend-aasland
    moved this from TODO: Feature to Backwards compatibility issues in sqlite3 issueson May 31, 2022
  5. erlend-aasland
    moved this from Backwards compatibility issues to TODO: Feature in sqlite3 issueson May 31, 2022

  6. serhiy-storchaka commented on May 31, 2022

    @serhiy-storchaka
    serhiy-storchaka
    on May 31, 2022
    Member

    But it would be nice to expose the Sqlite 3 version number. What do you think?

  7. erlend-aasland commented on Jun 1, 2022

    @erlend-aasland
    erlend-aasland
    on Jun 1, 2022
    ContributorAuthor

    But it would be nice to expose the Sqlite 3 version number. What do you think?

    We already do :) sqlite3.sqlite_version and sqlite3.sqlite_version_info

  8. subramaniam02 commented on Jun 3, 2022

    @subramaniam02
    subramaniam02
    on Jun 3, 2022

    Not sure what is the process. But I am interested to work on this.

  9. erlend-aasland
    moved this from TODO: Feature to In Progress in sqlite3 issueson Jun 5, 2022

  10. erlend-aasland commented on Jun 5, 2022

    @erlend-aasland
    erlend-aasland
    on Jun 5, 2022
    ContributorAuthor

    Not sure what is the process. But I am interested to work on this.

    Sorry for the late reply. Looks like there is already a PR up, however there are probably more deprecations coming up in the 3.12 dev phase :)

  11. subramaniam02 commented on Jun 6, 2022

    @subramaniam02
    subramaniam02
    on Jun 6, 2022

    Not sure what is the process. But I am interested to work on this.

    Sorry for the late reply. Looks like there is already a PR up, however there are probably more deprecations coming up in the 3.12 dev phase :)

    Ok Thank you !

  12. erlend-aasland
    added a commit that references this issue on Jun 7, 2022

    gh-93370: Deprecate sqlite3.version and sqlite3.version_info (#93482)

    ffc58a9

  13. 3 remaining items

  14. Repository owner moved this from In Progress to Done in sqlite3 issueson Jun 7, 2022
  15. erlend-aasland
    reopened this on Jun 25, 2022

  16. erlend-aasland commented on Jun 25, 2022

    @erlend-aasland
    erlend-aasland
    on Jun 25, 2022
    ContributorAuthor

    Reopening as pythoninfo.py was not updated to catch the deprecation warning. Excerpt from https://github.com/python/cpython/runs/7056328858?check_suite_focus=true:

    /Users/runner/work/cpython/cpython/Lib/test/pythoninfo.py:55: DeprecationWarning: version is deprecated and will be removed in Python 3.14
  17. erlend-aasland
    added a commit that references this issue on Jun 25, 2022

    pythongh-93370: Catch sqlite3.version deprecation warning in pythonin…

    df497a9
  18. serhiy-storchaka
    added a commit that references this issue on Jun 26, 2022

    Revert 30935 defer bpo45162 to 312 (#94285)

    1ffde3e
  19. erlend-aasland
    added a commit that references this issue on Jun 26, 2022

    gh-93370: Drop deprecated sqlite3.version from pythoninfo.py (#94277)

    27934be

  20. erlend-aasland commented on Jun 27, 2022

    @erlend-aasland
    erlend-aasland
    on Jun 27, 2022
    ContributorAuthor

    Remaining issue resolved by #94277.

  21. erlend-aasland
    closed this as completedon Jun 27, 2022
  22. erlend-aasland
    reopened this on Jul 19, 2022

  23. erlend-aasland commented on Jul 19, 2022

    @erlend-aasland
    erlend-aasland
    on Jul 19, 2022
    ContributorAuthor

    There's a remaining use in Lib/test/test_sqlite3/__init__.py

  24. erlend-aasland
    added a commit that references this issue on Jul 19, 2022

    pythongh-93370: Don't print deprecated pysqlite version in test_sqlite3

    9399f8c
  25. erlend-aasland
    closed this as completedin #95017on Jul 19, 2022
  26. erlend-aasland
    added a commit that references this issue on Jul 19, 2022

    gh-93370: Don't print deprecated pysqlite version in test_sqlite3 (#9…

    be09bae
  27. miss-islington
    added a commit that references this issue on Jul 19, 2022

    pythongh-93370: Don't print deprecated pysqlite version in test_sqlit…

    dc100d4
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    3.12only security fixeseasytopic-sqlite3type-featureA feature request or enhancement

    Projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions