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.9.0-py3-none-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | eb6cd9dc71631bcee474a18191b6f61b060d1af5ea7974886858a29f6dc1e4b2 |
|
MD5 | ba01c7ef06587de8f27a253eaeacce0d |
|
BLAKE2b-256 | 6dcf17a0c779a64efc100589233224c76602498857548f24665a07e25beac206 |
Hashes for adbc_driver_sqlite-0.9.0-py3-none-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 905de41658f7567f0919e5aa34d1e3261f8a802212c46f06a6b767ba7f07277e |
|
MD5 | a3f04ae199fc666aa6e61d8218709ec6 |
|
BLAKE2b-256 | 478b0e66b80df00f152e9a9255b2185ee0691766ada78e2b2cc4b8d358b09b34 |
Hashes for adbc_driver_sqlite-0.9.0-py3-none-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 24782431d415914930366b1c717a2629bb9e9892eac2bf051c065a2d954e3a27 |
|
MD5 | 33fa1f9c237f42ff3204c26f559fa9bf |
|
BLAKE2b-256 | 632d37fc1bbb12cf89a3037b3a922da888ff622bb205bbd646ed597504a93678 |
Hashes for adbc_driver_sqlite-0.9.0-py3-none-macosx_11_0_arm64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9a150c28b9e37f8f9ee16271179905cfc485f662eb936351e8b6c3149ea2152c |
|
MD5 | f9f890987962bd0c3aa021277e24e0d6 |
|
BLAKE2b-256 | 2838319c8fe3e35043c3c5f4e34b844a62c034c1039bb29691ecabee96a51e8b |
Hashes for adbc_driver_sqlite-0.9.0-py3-none-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | da62a80e642088fb43f4d69265e58c8dfcd9b38548814d643d63f2e59346a4f3 |
|
MD5 | 52082e5277d89c0ada038ce9a82ae19f |
|
BLAKE2b-256 | 58b81d8529561957c31150b13c62fef858908b184b9649529898df0bcb5360ce |