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 Distributions
Built Distributions
Hashes for adbc_driver_sqlite-0.11.0-py3-none-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6362be1a935b361eef963e444b62b21e6ca97994b486caca4e8d27b92bdfb6f3 |
|
MD5 | 4099407f8eab4089e6d123d54503f6f0 |
|
BLAKE2b-256 | 93f5ca3e10653e94dbedf2357a428485ab96b2798d894fb257156ff7d507f5d7 |
Hashes for adbc_driver_sqlite-0.11.0-py3-none-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6dacdb7249be540a1edd36ad4f3c6d2a7c1b6f3742c786239ebe607ee5cf298b |
|
MD5 | 793325625515f69c0bbfe0a15e3746d4 |
|
BLAKE2b-256 | 9b7beecdb2c6f462a2723d344ff624be05811bcdbe534394e17ebf6706464b8a |
Hashes for adbc_driver_sqlite-0.11.0-py3-none-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | df7604b1526a39d3c3dece07f24a69e8aea14bfc15bd854d0cc98ccb075ea277 |
|
MD5 | 8087838cb38fa0ef2d910d8849e4e8c6 |
|
BLAKE2b-256 | 38b6883aa674ff9c88f6e55d7ba4bc969b91a366ee540ca1df8f2f385f600cf1 |
Hashes for adbc_driver_sqlite-0.11.0-py3-none-macosx_11_0_arm64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 993f51f6c406f182bf94d34eee020192c9637a5bee81e7adac9975454b8333fd |
|
MD5 | 3ac62188565dc552935d377dd7b17261 |
|
BLAKE2b-256 | 49806e9d1efed7b509aca6964bf24ab288e7569a0b8dd0724b7499988b5c5fa5 |
Hashes for adbc_driver_sqlite-0.11.0-py3-none-macosx_10_15_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 88f8795f94c09e9b88ce6590c5c218515b23d42016837da55861489e7869e132 |
|
MD5 | cb71848e315b0686e615ffba48b5679f |
|
BLAKE2b-256 | d6f777805d6421c60172df2e8b924b7ecc7b4e039d95043d691ae2e2e0253dea |