Description

erlend-aasland

opened on May 31, 2022

Issue body actions

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 pysqlite¹ version number, until the external pysqlite package stopped upstreaming changes to the stdlib sqlite3 module², but today they carry no meaning or practical value³.

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). ↩

Reacted by Ned Deily and s​age

Reacted by Simon Sawicki

Activity

1. erlend-aasland

   added

   type-featureA feature request or enhancementA feature request or enhancement

   easy

   3.12only security fixesonly 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

   on May 31, 2022

   Member

   More actions

   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

   on Jun 1, 2022

   ContributorAuthor

   More actions

   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

   Reacted by Serhiy Storchaka and Jeong, YunWon
8. subramaniam02 commented on Jun 3, 2022

   

   subramaniam02

   on Jun 3, 2022

   More actions

   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

    on Jun 5, 2022

    ContributorAuthor

    More actions

    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

    on Jun 6, 2022

    More actions

    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

    on Jun 25, 2022

    ContributorAuthor

    More actions

    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

    on Jun 27, 2022

    ContributorAuthor

    More actions

    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

    on Jul 19, 2022

    ContributorAuthor

    More actions

    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

Issue actions