An ADBC driver for working with SQLite.
Project description
ADBC SQLite Driver for Python
This package contains bindings for the ADBC SQLite driver, using the driver manager to provide a DBAPI 2.0/PEP 249-compatible interface on top.
Example
import adbc_driver_sqlite.dbapi
with adbc_driver_sqlite.dbapi.connect() as conn:
with conn.cursor() as cur:
cur.execute("SELECT 1")
print(cur.fetch_arrow_table())
Building
Dependencies: a build of the SQLite driver, and the
adbc-driver-manager
Python package. Optionally, install PyArrow to
use the DBAPI 2.0-compatible interface.
Set the environment variable ADBC_SQLITE_LIBRARY
to the path to
libadbc_driver_sqlite.{dll,dylib,so}
before running pip install
.
# If not already installed
pip install -e ../adbc_driver_manager
export ADBC_SQLITE_LIBRARY=/path/to/libadbc_driver_sqlite.so
pip install --no-deps -e .
For users building from the arrow-adbc source repository, you can alternately use CMake to manage library dependencies and set environment variables for you. Assuming you specify -DADBC_DRIVER_SQLITE=ON
you can also add -DADBC_BUILD_PYTHON=ON
to define a python
target.
For example, assuming you run cmake from the project root:
cmake -S c -B build --preset debug -DADBC_BUILD_PYTHON=ON
cmake --build build --target python
will properly build and install the Python library for you.
See CONTRIBUTING.md for details on the general build process.
Testing
To run the tests, use pytest:
$ pytest -vvx
See CONTRIBUTING.md for details on the general test process.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distributions
Hashes for adbc_driver_sqlite-1.2.0-py3-none-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a7a0d9c8ffe47b4b502f731e3a128a4f0bd7795028ae146755add1e27490d490 |
|
MD5 | b98fcca00a90e67d5383ec2b21f21061 |
|
BLAKE2b-256 | e030e2698de2e501918d5ec6171e2c6f4b607db3ed70f02a982861c2bb30330a |
Hashes for adbc_driver_sqlite-1.2.0-py3-none-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | fc535701c7dffa233a67b58303891c4534d8b4f812442ba59eb7b030fc164699 |
|
MD5 | 21bf2e9b3e28592faf90a9286057eb65 |
|
BLAKE2b-256 | 1fc48e6b486db4049149e70e125a9b2a809679927945306e93f97dfc8199c0de |
Hashes for adbc_driver_sqlite-1.2.0-py3-none-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9d7fb6df4810d9f9b6aa9db5f35fef52fd88ed71d8a147c7649a33e3de875bcd |
|
MD5 | df825f95d19a66869d0ea407e7bf520b |
|
BLAKE2b-256 | 0a1eb02d229f7229471e20c061c42643b6ec61166a0cd6f3648d3ae4ed0ae8ae |
Hashes for adbc_driver_sqlite-1.2.0-py3-none-macosx_11_0_arm64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3c40ae78e5e7df2935434646809617dd52e3406320be087e544251b6a5dcdbc9 |
|
MD5 | 890f762c1053e908867ed537e7a75d96 |
|
BLAKE2b-256 | d8363d25d19c2001df08ed4ee85135a8a23bcb3fd17ba4ed7c3bc6593399ad3e |
Hashes for adbc_driver_sqlite-1.2.0-py3-none-macosx_10_15_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0a7d34e94b9b32fffd3d456369c696a134366476879a23ab5783b381b4a6d2a2 |
|
MD5 | 2857cf92aab7b4e827d6506386dedeeb |
|
BLAKE2b-256 | 9c82a13bb3569e8f59caeb7d94069ac1880246ecb459225700576e37d89edf53 |