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.10.0-py3-none-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7727da4b1352b3bce846e0b6d0486be8949a32ef473179edc9050f7ac03d6d77 |
|
MD5 | 05a097804b7be4d3451f1a44eabd011c |
|
BLAKE2b-256 | d8c4c8984d8a237c9068d888f835ea04f65b4efa11ced1888a6399716bcd1425 |
Hashes for adbc_driver_sqlite-0.10.0-py3-none-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a67b518c380f8b490c6aab2d90006dfa285941128172393effb3a58c73304d34 |
|
MD5 | 4b8b49c9374af5538eb021f677df083a |
|
BLAKE2b-256 | df9b36cf45c0c7b34f0881e6c3b0f79b02c341fd79f19614079a99b31ce33cfd |
Hashes for adbc_driver_sqlite-0.10.0-py3-none-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b506902bdf60a0a09ca5f178d39d5bdf3a69679c917144c755b45b32ed7fa672 |
|
MD5 | 5ccd1d4e33b4aa0890cc33c834861609 |
|
BLAKE2b-256 | 99c7db332431c20084cb9465003a1291f435fd92a284837118e69a478f2829b5 |
Hashes for adbc_driver_sqlite-0.10.0-py3-none-macosx_11_0_arm64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1396d83aee72593dd975181feb258f7225ef4c1cbd68c59ce7924e215de8f1f7 |
|
MD5 | 0ea2bf5d9691d86212459a0f27d6a115 |
|
BLAKE2b-256 | 2a770644ec7b08c6195dfb739cb226ca48dcae674a913f803eb1852ab04a7fa9 |
Hashes for adbc_driver_sqlite-0.10.0-py3-none-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d3e552aff125600e6d1c0e91cd5dddf337b34ca1b86eb3be20db4a2cd7334d59 |
|
MD5 | b2c5326c860cb050859c8b8d63cda430 |
|
BLAKE2b-256 | 9a0cf6a94b71f6080c5ae99e43659eea6e006c6419b47da97c5b99a9eb4145c2 |