Overview - Python Connector for SQLite

Overview

Python Connector for SQLite is a connectivity solution for accessing SQLite databases from Python applications. It fully implements the Python DB API 2.0 specification. The connector is distributed as a wheel package for Windows, macOS, and Linux.

Direct connection

The connector supports two SQLite library linking modes: static linking and dynamic linking. Static linking enables a direct connection to SQLite, so you don't have to deploy the SQLite libraries on user workstations. You can use the built-in encryption capabilities in the Direct mode to protect your data from unauthorized access—the statically linked library provides SQLite database encryption without requiring you to purchase an encryption extension.

Compatibility

• Python versions from 3.7 to 3.12
• SQLite version 3.x
• SQLAlchemy
• pandas
• petl

Supported platforms

• Windows 32-bit and 64-bit
• Windows Server 32-bit and 64-bit
• macOS 64-bit and ARM (Apple M1 and M2)
• Linux 64-bit

Note: For details on supported OS versions, check the compatibility page of your Python version.