pyhdb-rs 0.1.0

High-performance Python driver for SAP HANA with native Arrow support

pyhdb-rs

High-performance Python driver for SAP HANA with native Apache Arrow support.

Features

• DB-API 2.0 compliant — Drop-in replacement for existing HANA drivers
• Zero-copy Arrow integration — Direct data transfer to Polars and pandas
• Async support — Native async/await with connection pooling
• Type-safe — Full type hints and strict typing

Installation

pip install pyhdb_rs

With optional dependencies

pip install pyhdb_rs[polars]    # Polars integration
pip install pyhdb_rs[pandas]    # pandas + PyArrow
pip install pyhdb_rs[all]       # All integrations

[!TIP] Use uv pip install pyhdb_rs for faster installation (10-100x faster than pip).

Quick start

from pyhdb_rs import connect

with connect("hdbsql://user:pass@host:39017") as conn:
    cursor = conn.cursor()
    cursor.execute("SELECT * FROM MY_TABLE")
    for row in cursor:
        print(row)

Usage

Polars integration

import pyhdb_rs.polars as hdb

df = hdb.read_hana(
    "SELECT * FROM sales WHERE year = 2024",
    "hdbsql://user:pass@host:39017"
)
print(df.head())

pandas integration

import pyhdb_rs.pandas as hdb

df = hdb.read_hana(
    "SELECT * FROM sales",
    "hdbsql://user:pass@host:39017"
)

Async support

from pyhdb_rs.aio import connect

async with connect("hdbsql://user:pass@host:39017") as conn:
    cursor = await conn.cursor()
    await cursor.execute("SELECT * FROM MY_TABLE")
    async for row in cursor:
        print(row)

[!NOTE] Use async with for proper resource cleanup. The context manager handles connection pooling automatically.

Connection pooling

from pyhdb_rs.aio import ConnectionPool

pool = ConnectionPool(
    uri="hdbsql://user:pass@host:39017",
    min_connections=2,
    max_connections=10,
)

async with pool.acquire() as conn:
    cursor = await conn.cursor()
    await cursor.execute("SELECT 1")

Error handling

from pyhdb_rs import connect, DatabaseError, InterfaceError

try:
    with connect("hdbsql://user:pass@host:39017") as conn:
        cursor = conn.cursor()
        cursor.execute("SELECT * FROM nonexistent")
except DatabaseError as e:
    print(f"Database error: {e}")
except InterfaceError as e:
    print(f"Connection error: {e}")

Type hints

This package is fully typed and includes inline type stubs:

from pyhdb_rs import connect, Connection, Cursor

def query_data(uri: str) -> list[tuple[int, str]]:
    with connect(uri) as conn:
        cursor: Cursor = conn.cursor()
        cursor.execute("SELECT id, name FROM users")
        return cursor.fetchall()

Requirements

• Python >= 3.11

Development

git clone https://github.com/bug-ops/pyhdb-rs
cd pyhdb-rs/python

pip install -e ".[dev]"

pytest
ruff check .
mypy .

Documentation

See the main repository for full documentation.

License

Licensed under either of Apache License, Version 2.0 or MIT license at your option.