Deprecate sqlite3.version and sqlite3.version_info

[erlend-aasland]

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

[serhiy-storchaka]

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

[erlend-aasland]

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

[subramaniam02]

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

[erlend-aasland]

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 :)

[subramaniam02]

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 !