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.0.0-py3-none-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a7ad4b9719da3e5e392662abc41be25d6335e4a72a76073f7befdb9cca516114 |
|
MD5 | a4adfe54e0609a1e01f8ec6f986ad58a |
|
BLAKE2b-256 | 8fb3349ef7a2729ad92a3ea9755fbbe0b368b73171bbf0ca86205fce3bd2162d |
Hashes for adbc_driver_sqlite-1.0.0-py3-none-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | bddd2ab9e2184b41490000ae5d2625e6bb27557d6561f2057619d5507414ed07 |
|
MD5 | e62a4ed421c08e1ebf132dabfae397ab |
|
BLAKE2b-256 | f426c4a52def83499a5a98473d95c13c149fd850c9d2e0700050991f998bd59e |
Hashes for adbc_driver_sqlite-1.0.0-py3-none-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e831ead3f0bb5bc827b4607293a806915957e1d8693719188234f9917cdb1026 |
|
MD5 | 96d8ca32d88efdf461eb0b0a3ac6c4ac |
|
BLAKE2b-256 | d061ad873743ba7329591fd5e28ffa2b6aeb44bc89a032e29c739881c6ad9254 |
Hashes for adbc_driver_sqlite-1.0.0-py3-none-macosx_11_0_arm64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 616a25ceb26d4f1e99ba4de7ce9eca8d024fdff29c2dce499b704ad474130a8f |
|
MD5 | 15a4899dec13010258e9b7ad04478fb0 |
|
BLAKE2b-256 | b4373517779347b7ba9316843ad5494d9bb879a3a96602bc8f249eb15590a21e |
Hashes for adbc_driver_sqlite-1.0.0-py3-none-macosx_10_15_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0915dea95c676da4d48ab61688bf7e8424dc53283be92512d0c1fbda4915b1ba |
|
MD5 | d0c01ea83f9282966b17cb5084e1e826 |
|
BLAKE2b-256 | 5d96ce113fd215f5db6bae81dee18434c6674e5434b49728afc52451864dd997 |