stdb-driver 0.3.2

Mireo SpaceTime database connector

Mireo SpaceTime database remote connector

stdb-driver is a Python module for managing remote Mireo SpaceTime database.

Features

• Both blocking and asynchronous modes of operation are available.
• Supports listing nodes; listing, creating and droping tables; inserting rows; and performing range queries.
• Range query results are convertible to Python lists, NumPy arrays and Pandas dataframes.
• Requires CPython 3.10+.
• Available for Linux (glibc 2.17+ and musl 1.2+; x86-64) and Windows (x86-64).

Installation

pip install -U stdb-driver -i https://pypi.mireo.local

Conversions to NumPy and Pandas data types require those packages that can be installed as optional dependencies:

pip install -U stdb-driver[numpy]
pip install -U stdb-driver[pandas]
pip install -U stdb-driver[all]

Example

import stdb_driver

# Connect
session = stdb_driver.SessionConfig().zk_hosts(<address>).build()
print(session.status())  # SessionStatus.Connected

# List nodes and tables
print(session.list_nodes(), session.list_tables())

# Run range query
RALL = stdb_driver.RANGE_ALL
res = session.range_query('segment', [[(1, 10000), RALL, RALL, RALL, RALL, RALL, RALL, RALL, RALL]])

# Print column names and their MSQL data types
print(res.row_type.columns)

# Iterating over rows converts each lazily to a Python list of appropriate Python data types
for row in res:
	print(row)

# Query result can be converted to:
rows = res.to_list()  # Python list of appropriate Python data types
arr = res.to_numpy()  # NumPy array of appropriate NumPy data types (requires numpy)
df = res.to_pandas()  # Pandas dataframe of appropriate NumPy/Pandas data types (requires pandas)

# Disconnect
session.stop()
print(session.status())  # SessionStatus.Stopped