Overview - Python Connector for xBase

Overview

Python Connector for xBase is a connectivity solution for accessing FoxPro, Visual FoxPro, dBase, and other databases in DBF file formats 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 enables you to establish a direct connection to Visual FoxPro, dBase, and other xBase databases eliminating the need for the client library. A direct connection increases the speed of data transmission between a Python application and an xBase database and simplifies the deployment.

Local indexing

The connector offers an internal data indexing mechanism that is way more efficient than native DBF indexes for complex queries.

Retrieval of corrupted data

You can choose to ignore corrupted data and metadata errors in DBF tables. Corrupted data is skipped, while intact data is properly retrieved.

Compatibility

• Python versions from 3.7 to 3.12
• xBase compatibility:
• FoxPro 2, Visual FoxPro
• dBase III-dBase 7
• Codebase
• Clipper
• HiPer-Six
• 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.