What is the SQLite3 Version Compatible with Python 3.9?

Python 3.9 includes SQLite3 as part of its standard library. The specific version of SQLite3 bundled with Python 3.9 can vary depending on the Python release and the operating system.

Generally, Python aims to include a relatively recent and stable version of SQLite3.

To determine the exact version of SQLite3 being used by a specific Python 3.9 installation, you can use the following Python code:

import sqlite3
print(sqlite3.sqlite_version)

Execute this script in your Python 3.9 environment. The output will display the SQLite3 version string.

For example, the output might look something like:

3.33.0

This indicates that SQLite3 version 3.33.0 is being used.

Typically, Python 3.9 includes SQLite3 versions from the 3.30.0 range and upwards. However, checking directly using the code snippet is the most accurate way to determine the version for your specific Python 3.9 setup. Remember that OS updates or custom Python builds might also influence the exact SQLite3 version that is included.

Learn more about this