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.1.0-py3-none-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 95830e84e304c8a34f025f32c6450232db0ea270d9703d12027a4bf8f75d1fb6 |
|
MD5 | 9731b2387311a61d29b3b82e198007c3 |
|
BLAKE2b-256 | 801cef9325dd29bc6f983c7beb0c1528d71f01ca1adcb38bc9f9a67c281fa48a |
Hashes for adbc_driver_sqlite-1.1.0-py3-none-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0c695ae89248f4123c55c18f1a96327ead62b344b33ed88799fc0fc0d535dd6b |
|
MD5 | f76af5f87e91cfbf43b9e559fc60f136 |
|
BLAKE2b-256 | 8062114c315e732da180f043e72af2768249f1b08cd40cae2d3c9be8ea8bc3b2 |
Hashes for adbc_driver_sqlite-1.1.0-py3-none-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b8697dfe059ebeea6e0735009c89ec4f08c2a9f780bf13ba2fd5d3a155d55b61 |
|
MD5 | 8890a05f7bc470bce56c40fb053cd5fb |
|
BLAKE2b-256 | d4f79f02fc36dcf64c82145b2c135e56d6019fcdf52bd5cfc05e049ac670e40d |
Hashes for adbc_driver_sqlite-1.1.0-py3-none-macosx_11_0_arm64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 01b634a43e6d45378212b2ae82e74eed3b69a32db2664273207573732f01270d |
|
MD5 | 9f993e78d750025202c5af07806ae27c |
|
BLAKE2b-256 | e26073254fee9c605691e58d41bcea27739284cec613fffac46dfaad4783224e |
Hashes for adbc_driver_sqlite-1.1.0-py3-none-macosx_10_15_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 559e2d0e2c061af3fed47efbcff049a075d0588c83436c18bc80a1e4a4483fd0 |
|
MD5 | e120468b16d570a457e75c186f00a2e9 |
|
BLAKE2b-256 | f532cbbfd72e4a18c222f045ba95f383c04d19b751b5140aa7ddeb8b4888a333 |