49
Python 2.6.2 (r262:71605, Apr 14 2009, 22:40:02) [MSC v.1500 32 bit (Intel)] on
win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>> sqlite3.version
'2.4.1'

Questions:

  • Why is the version of the sqlite3 module '2.4.1'
  • Whats the reason behind bundling such an old sqlite with Python? The sqlite releaselog says 2002 Mar 13 (2.4.1).
nnn
  • 493
  • 1
  • 4
  • 4

1 Answers1

100
Python 2.5.1
>>> import sqlite3
>>> sqlite3.version
'2.3.2'
>>> sqlite3.sqlite_version
'3.3.4'

version - pysqlite version
sqlite_version - sqlite version

Nick Dandoulakis
  • 42,588
  • 16
  • 104
  • 136
sdu
  • 2,740
  • 4
  • 31
  • 30
  • 3
    Odd verisoning on the part of SQlite. – whatnick Oct 12 '09 at 07:39
  • 14
    The pysqlite database adapter is a totally separate project from the underlying sqlite3 database project so the version numbers are not related. See http://stackoverflow.com/questions/1545479/force-python-to-forego-native-sqlite3-and-use-the-installed-latest-sqlite3-vers/1546162 for an extended discussion. – Ned Deily Oct 12 '09 at 07:54
  • One liner to print to CLI: `python -c "import sqlite3; print(sqlite3.version); print(sqlite3.sqlite_version)"` – smartexpert Oct 02 '22 at 23:24