Geek asks and answers

Sqlite version for Python 3.x

I want to use sqlite3 with Python 3.1.3, and I need to set enable_load_extension to true. For this, I believe that I need sqlite version 3.x. From the read posts, it seems here that a suitable version of sqlite should be bundled with python version 2.6 and higher. However, when I do this:

import sqlite3
sqlite3.version_info

Returned result: '2.4.1'

I get the same answer on another machine running Python 2.6.

The pysqlite site does not have binaries for Python 3.x. My copy of Python appeared on the official Python website.

So: 1) What version of sqlite should I have with 3.1? 2) If I have to have a more modern version, where did she go, do I need to set an environment variable? 2) If I need u

+3
source share
2

SQLite pysqlite, Python SQLite API. version version_info, , .

- , sqlite3? 3.x!

SQLite, sqlite_version :

import sqlite3
print sqlite3.sqlite_version

Python 2.6 3.5.9. Python 3.2 3.7.4.

SQL :

>>> import sqlite3
>>> connection = sqlite3.connect(':memory:')
>>> cursor = connection.cursor()
>>> cursor.execute('SELECT sqlite_version()').fetchone()
('3.7.4',)
+8

sqlite3.sqlite_version_info... 3.5.9 Python 2.6 3.1, 3.6.21 Python 2.7 3.7.4 Python 3.2. pysqlite.

" enable_load_extension true"?

...

+2

More articles: