Skip to main content

New level of functionality and performance in data access via Python

Project description

Python Connector for xBase

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.

Using the connector

To retrieve data from a database:

Import the module.

import devart.xbase

Connect to a database using the connect() module method and obtain a connection object.

my_connection = devart.xbase.connect(
    Database="path_to_db"
)

Create a cursor object using the cursor() connection method.

my_cursor = my_connection.cursor()

Execute the SQL statement using the execute() cursor method.

my_cursor.execute("SELECT * FROM employees")

Retrieve the result set using one of the fetch*() cursor methods.

for row in my_cursor.fetchall(): 
    print(row)

Ordering and activating the license

You can purchase a license for the connector on the ordering page:
https://www.devart.com/python/xbase/ordering.html

To activate the license, follow the instructions in the documentation:
https://docs.devart.com/python/xbase/activate-a-license.htm

What's new

Python Connector for xBase 1.2

  • Added support for Python 3.13
  • Added support for the BITTEST SQL function

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distributions

devart_xbase_connector-1.2.0-cp313-cp313-win_amd64.whl (1.4 MB view details)

Uploaded CPython 3.13 Windows x86-64

devart_xbase_connector-1.2.0-cp313-cp313-win32.whl (1.2 MB view details)

Uploaded CPython 3.13 Windows x86

devart_xbase_connector-1.2.0-cp313-cp313-manylinux_2_34_x86_64.whl (2.5 MB view details)

Uploaded CPython 3.13 manylinux: glibc 2.34+ x86-64

devart_xbase_connector-1.2.0-cp313-cp313-macosx_10_13_universal2.whl (4.9 MB view details)

Uploaded CPython 3.13 macOS 10.13+ universal2 (ARM64, x86-64)

devart_xbase_connector-1.2.0-cp312-cp312-win_amd64.whl (1.4 MB view details)

Uploaded CPython 3.12 Windows x86-64

devart_xbase_connector-1.2.0-cp312-cp312-win32.whl (1.2 MB view details)

Uploaded CPython 3.12 Windows x86

devart_xbase_connector-1.2.0-cp312-cp312-manylinux_2_34_x86_64.whl (2.5 MB view details)

Uploaded CPython 3.12 manylinux: glibc 2.34+ x86-64

devart_xbase_connector-1.2.0-cp312-cp312-macosx_10_9_universal2.whl (4.9 MB view details)

Uploaded CPython 3.12 macOS 10.9+ universal2 (ARM64, x86-64)

devart_xbase_connector-1.2.0-cp311-cp311-win_amd64.whl (1.4 MB view details)

Uploaded CPython 3.11 Windows x86-64

devart_xbase_connector-1.2.0-cp311-cp311-win32.whl (1.2 MB view details)

Uploaded CPython 3.11 Windows x86

devart_xbase_connector-1.2.0-cp311-cp311-manylinux_2_34_x86_64.whl (2.5 MB view details)

Uploaded CPython 3.11 manylinux: glibc 2.34+ x86-64

devart_xbase_connector-1.2.0-cp311-cp311-macosx_10_9_universal2.whl (4.9 MB view details)

Uploaded CPython 3.11 macOS 10.9+ universal2 (ARM64, x86-64)

devart_xbase_connector-1.2.0-cp310-cp310-win_amd64.whl (1.4 MB view details)

Uploaded CPython 3.10 Windows x86-64

devart_xbase_connector-1.2.0-cp310-cp310-win32.whl (1.2 MB view details)

Uploaded CPython 3.10 Windows x86

devart_xbase_connector-1.2.0-cp310-cp310-manylinux_2_34_x86_64.whl (2.5 MB view details)

Uploaded CPython 3.10 manylinux: glibc 2.34+ x86-64

devart_xbase_connector-1.2.0-cp310-cp310-macosx_10_9_universal2.whl (4.9 MB view details)

Uploaded CPython 3.10 macOS 10.9+ universal2 (ARM64, x86-64)

devart_xbase_connector-1.2.0-cp39-cp39-win_amd64.whl (1.4 MB view details)

Uploaded CPython 3.9 Windows x86-64

devart_xbase_connector-1.2.0-cp39-cp39-win32.whl (1.2 MB view details)

Uploaded CPython 3.9 Windows x86

devart_xbase_connector-1.2.0-cp39-cp39-manylinux_2_34_x86_64.whl (2.5 MB view details)

Uploaded CPython 3.9 manylinux: glibc 2.34+ x86-64

devart_xbase_connector-1.2.0-cp39-cp39-macosx_10_9_universal2.whl (4.9 MB view details)

Uploaded CPython 3.9 macOS 10.9+ universal2 (ARM64, x86-64)

devart_xbase_connector-1.2.0-cp38-cp38-win_amd64.whl (1.4 MB view details)

Uploaded CPython 3.8 Windows x86-64

devart_xbase_connector-1.2.0-cp38-cp38-win32.whl (1.2 MB view details)

Uploaded CPython 3.8 Windows x86

devart_xbase_connector-1.2.0-cp38-cp38-manylinux_2_34_x86_64.whl (2.5 MB view details)

Uploaded CPython 3.8 manylinux: glibc 2.34+ x86-64

devart_xbase_connector-1.2.0-cp38-cp38-macosx_10_9_universal2.whl (4.9 MB view details)

Uploaded CPython 3.8 macOS 10.9+ universal2 (ARM64, x86-64)

devart_xbase_connector-1.2.0-cp37-cp37m-win_amd64.whl (1.4 MB view details)

Uploaded CPython 3.7m Windows x86-64

devart_xbase_connector-1.2.0-cp37-cp37m-win32.whl (1.2 MB view details)

Uploaded CPython 3.7m Windows x86

devart_xbase_connector-1.2.0-cp37-cp37m-manylinux_2_34_x86_64.whl (2.5 MB view details)

Uploaded CPython 3.7m manylinux: glibc 2.34+ x86-64

devart_xbase_connector-1.2.0-cp37-cp37m-macosx_10_9_x86_64.whl (2.6 MB view details)

Uploaded CPython 3.7m macOS 10.9+ x86-64

File details

Details for the file devart_xbase_connector-1.2.0-cp313-cp313-win_amd64.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp313-cp313-win_amd64.whl
Algorithm Hash digest
SHA256 d19d5825be5a6dcb1448083cc22a1b7a68a7b251b594930aa0abae282e367fcc
MD5 457b08ab0fc10cfb99e98e39ea8eae1e
BLAKE2b-256 2da99ca52e26fc8037ab8916003731dc36de6d86c073f4e58957718b937a1441

See more details on using hashes here.

File details

Details for the file devart_xbase_connector-1.2.0-cp313-cp313-win32.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp313-cp313-win32.whl
Algorithm Hash digest
SHA256 4e68a5ae109530777e6178c2241ee5404669c45c912800c249a2aa539802d805
MD5 a8b8ca824a3bdcb0caf56225242223bd
BLAKE2b-256 bfedb194051c365320e688ebb4200979a3ef81fc63b79af580578e4569a9e0da

See more details on using hashes here.

File details

Details for the file devart_xbase_connector-1.2.0-cp313-cp313-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp313-cp313-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 03cf3889aba62d8cb35276e6de3d7c7dfe15dd206aed6b58e93a013cff05d29d
MD5 a6acb9dd9dacc1b7c049e364f41384b6
BLAKE2b-256 3ba1a8a4a2a7ef92c79de437ab721264c906e6000e08cf7b5cd0b4051c956423

See more details on using hashes here.

File details

Details for the file devart_xbase_connector-1.2.0-cp313-cp313-macosx_10_13_universal2.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp313-cp313-macosx_10_13_universal2.whl
Algorithm Hash digest
SHA256 f08f6df6a7683d8e4d25de4faed180837e3bca08086491ceacb5d1aab798e087
MD5 2842bb42c20ac478362535311def7b2c
BLAKE2b-256 10df614bfd332dbef877e2074624f044a533a2cc79c18afc2f78c5bec5e568b4

See more details on using hashes here.

File details

Details for the file devart_xbase_connector-1.2.0-cp312-cp312-win_amd64.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp312-cp312-win_amd64.whl
Algorithm Hash digest
SHA256 273a044e52552b080e6c6c5735aead74ee9df5554774503c51593b406588503a
MD5 3e9e314d51f3ac54d1a7650c08f6df2f
BLAKE2b-256 4bdfff4c0e45b6002a7679f061d8e030f61f77e8cdf6c1dc9dea965b5ccdfedb

See more details on using hashes here.

File details

Details for the file devart_xbase_connector-1.2.0-cp312-cp312-win32.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp312-cp312-win32.whl
Algorithm Hash digest
SHA256 59b813043f46d8321fa3b03eba0e6bdf6cbec99c36e3827a7ec1461ed449c080
MD5 4d6ba395f51bbbb1844b2d71720fc9af
BLAKE2b-256 c7bb35ad9edb58c720c1a7fcaa212e6b066ded76e48443fd168b68a0f15a58be

See more details on using hashes here.

File details

Details for the file devart_xbase_connector-1.2.0-cp312-cp312-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp312-cp312-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 a7b645e6da69d574c93bb4303f8ba8c21efb7a02f9ab11fb62cbff9379daf9fc
MD5 dbca87804cf02b0181446d38ccf787ff
BLAKE2b-256 2f4bd88b8986ce4ea77be4927690281e42415e9bfc93e65322268d97a1145e44

See more details on using hashes here.

File details

Details for the file devart_xbase_connector-1.2.0-cp312-cp312-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp312-cp312-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 0560e13dde714a8d7c71164f3cc75218be35096a90828e4a0d894d93b1648cc8
MD5 c5c2d98c4767734516e851e73003ea6b
BLAKE2b-256 6a4d3ce979b14389f96970ffbb6dc0f74d515e988aec7f59de65c24a8491f687

See more details on using hashes here.

File details

Details for the file devart_xbase_connector-1.2.0-cp311-cp311-win_amd64.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 837fd6dd19af4cee83611bca5195bb5b8217b4533b59a77adaf6dd264e111dcb
MD5 26abe8e3fa4dad4c7666cfa22701de59
BLAKE2b-256 408b84def23d3c554aa1c94f85f4efeeb069c3fa5a8ed7e39857ab0a482db13d

See more details on using hashes here.

File details

Details for the file devart_xbase_connector-1.2.0-cp311-cp311-win32.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp311-cp311-win32.whl
Algorithm Hash digest
SHA256 41442999dcd27c5fee18454402eaf6d20047cd98f92d55e0d8212f0e09037ec8
MD5 707d58587e417e4e782982917d5a3d7e
BLAKE2b-256 ab6bef660c83de44231f40e0c8d9abcbcb1edef7a00190892850f6aaca04d845

See more details on using hashes here.

File details

Details for the file devart_xbase_connector-1.2.0-cp311-cp311-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp311-cp311-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 c2f8962f540d9bc604d2b4de2df1db2e34dbb715e44a38efeeb24d2997907ea9
MD5 81cf3cfce4bf352d485c3053c7371aa3
BLAKE2b-256 108626738884e17b159ac9725a1d970aa86af7ec2c0373734fed1d127191d5e8

See more details on using hashes here.

File details

Details for the file devart_xbase_connector-1.2.0-cp311-cp311-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp311-cp311-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 e07f9ccdca30bd49af69730bb6e0582ff83ca46511e272223a9005096e66231a
MD5 62103b19222c7e664838d14e661bf943
BLAKE2b-256 f17ca7ddc490b3f02f3fd792202da07dd39b2d9f5f9cab189cfb3377e5eb5b56

See more details on using hashes here.

File details

Details for the file devart_xbase_connector-1.2.0-cp310-cp310-win_amd64.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 89d3d6e5328f2e44a332ab1f8f9c76cdd6e63d6b3dc5e22668ff0b391557e6b6
MD5 b6c491005d52b3de8b539958d0408748
BLAKE2b-256 e540024903fdefd937b73c2171e4c5ce8bbb99cd8937fde938b2b20f00517702

See more details on using hashes here.

File details

Details for the file devart_xbase_connector-1.2.0-cp310-cp310-win32.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp310-cp310-win32.whl
Algorithm Hash digest
SHA256 2551e11c249ef5b43e43514b246415e2d5be898cfbede40cdf28caad8d18200d
MD5 c6e4cbb36f9b86a32ee907e9752b679b
BLAKE2b-256 a4e4ba4427fc9156947b5aca13d13d135bfc4eecfda670f87dce09f732240874

See more details on using hashes here.

File details

Details for the file devart_xbase_connector-1.2.0-cp310-cp310-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp310-cp310-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 bd091a13b7629d93e33f012646cb0b78f1d633999ac9d731fe65b53f2b683af8
MD5 2b79bc7cc00fef4099627c5b79147c63
BLAKE2b-256 77105c538cc9ae4acbb0f11f9879c3c17e8f0a327f3ba4dd12a15e7d12ef1377

See more details on using hashes here.

File details

Details for the file devart_xbase_connector-1.2.0-cp310-cp310-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp310-cp310-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 c8910a5af1de9405d08959c4b7932462b32d00d5ab2eae3f86da3c9a8b4f7e13
MD5 ccab4fe1bf5abdae33a5959cc908f9b9
BLAKE2b-256 fb69e0fa84765c1159d89e294a62e9835827b97b0bf1c4906c60a2128f51bf43

See more details on using hashes here.

File details

Details for the file devart_xbase_connector-1.2.0-cp39-cp39-win_amd64.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 09c9072a2697fe03fd9d9af64252ad0554880460d4f7d595b78fbfd848186062
MD5 714654ee9f9e95166cb557fa16b4fca5
BLAKE2b-256 4f95144ebabc1d78d38bb3718033ec399000873391415c1f78763e01640b6782

See more details on using hashes here.

File details

Details for the file devart_xbase_connector-1.2.0-cp39-cp39-win32.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp39-cp39-win32.whl
Algorithm Hash digest
SHA256 a02d9fc88e67bc57af1efdf44fc76c38bc931e90b197d49d6d85a77e296093df
MD5 179ec3ceed66d40fcf7b874614077608
BLAKE2b-256 f45b5c59844c37e7e46791cbc6ce9add3fcf389a83c521bfb4ec1a56e1f90b9d

See more details on using hashes here.

File details

Details for the file devart_xbase_connector-1.2.0-cp39-cp39-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp39-cp39-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 c1a68ef628008ee4b9d607f7b5207773fe18642328c447729389f8726a2cbdbc
MD5 7240f946e7f6be3d7266c98529a025b3
BLAKE2b-256 05ea41dab9f0efce8cce21b0ff647c9e3205467b98a946cc8e3741ce60defe1f

See more details on using hashes here.

File details

Details for the file devart_xbase_connector-1.2.0-cp39-cp39-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp39-cp39-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 a638477df1e8625e04b12a444ce24560b7a4572bf25a6b52bc9aacbeea27867b
MD5 895f321a855719ccb30233f1b0fe8b1d
BLAKE2b-256 431017c1c806076ec9e2aa311f377c3d0077b2a6e7a5faedc1bfc18d850bea7a

See more details on using hashes here.

File details

Details for the file devart_xbase_connector-1.2.0-cp38-cp38-win_amd64.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 44c34643a1097a1c41561d202df404c4488b42b1970e69731e9c5998a76d9c40
MD5 bff984bccdd796095434319b8d8d67b1
BLAKE2b-256 3e51d8844b535fbc37da06580a36dc41720a6ca3a973ce72d4bdd195d004da7a

See more details on using hashes here.

File details

Details for the file devart_xbase_connector-1.2.0-cp38-cp38-win32.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp38-cp38-win32.whl
Algorithm Hash digest
SHA256 c44d865ce585f055fab33f655c032244edce0b5d22d4658dd9c7aae4e0fd3579
MD5 f015bdbba5c9e8d35d0a324f53a1f03e
BLAKE2b-256 e046231e00448192667ba4c9a2c238598ed31090bf049d8d4a6043db8c071f06

See more details on using hashes here.

File details

Details for the file devart_xbase_connector-1.2.0-cp38-cp38-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp38-cp38-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 a3fecf6e0fda9a3c2da7af71dea8aa8b0b935dcd483902c5ef03130d7479e5bc
MD5 8eafdf85b11023958f48c19b469de0de
BLAKE2b-256 54a04ea3e1441902cd9a14b7b6c27844fed06fd8ae2237d918ae0751b095b101

See more details on using hashes here.

File details

Details for the file devart_xbase_connector-1.2.0-cp38-cp38-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp38-cp38-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 75a036a547c622bf11c8baefcfb991cbdc0e41bddd0f8209662ad8111d4670d7
MD5 fcbf0dda92fc02ed2b307c170588b249
BLAKE2b-256 e97c01d7cff0da43bc2ac0ebeb3ba40988f943d58aa3811b76107e65a0e57a36

See more details on using hashes here.

File details

Details for the file devart_xbase_connector-1.2.0-cp37-cp37m-win_amd64.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 00ac8ede2ae2a4b967469ad8bf9c12f0116b18c41f3123a6727468cbe5b9f4fe
MD5 c32a5e0c1c3c6f84f14100492a6330db
BLAKE2b-256 aa1214bd4f047f26086e34e480b6c7e367e0fd5858380a2112aaf9fda0d62e62

See more details on using hashes here.

File details

Details for the file devart_xbase_connector-1.2.0-cp37-cp37m-win32.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp37-cp37m-win32.whl
Algorithm Hash digest
SHA256 575b58f0e7e7d5974cf389ac3e6fbcfb71051286f14206f1cfef6c548c586c28
MD5 ee5a465dd07b695e7df00e349e213348
BLAKE2b-256 b8c62a8fbda2787eab96fd3d0a9f07e09f0f577c6553222c75a9bfe65b3dbbd1

See more details on using hashes here.

File details

Details for the file devart_xbase_connector-1.2.0-cp37-cp37m-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp37-cp37m-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 042e24e384b7b616103a4d80dbce4c01a6dee7bcf0efd168012935eafc395065
MD5 e95fcc6763e96926a5f32145c794b1ab
BLAKE2b-256 87fb9a539025ec69781ce096a3bdbc6da0062a962a28b6ab90600983a37e7182

See more details on using hashes here.

File details

Details for the file devart_xbase_connector-1.2.0-cp37-cp37m-macosx_10_9_x86_64.whl.

File metadata

File hashes

Hashes for devart_xbase_connector-1.2.0-cp37-cp37m-macosx_10_9_x86_64.whl
Algorithm Hash digest
SHA256 284f152c793aafc7922a3dcc0307a7197a5720ee80e4d982eed63d0f4aa12dd4
MD5 908273cd89a67da4696a95f3649fbcab
BLAKE2b-256 b25a12e7bed6866dedf85918c8ce760d3bb6e42988e71a1e2f1af43359289ce9

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page