Skip to main content

Mireo SpaceTime MSQL connector

msql-driver is a Python module for querying a Mireo SpaceTime database using the MSQL query language.

Features

  • Both blocking and asynchronous modes of operation.
  • Query results are convertible to Python lists, NumPy arrays, and Pandas dataframes.
  • Streamlit integration with support for asynchronous querying.
  • Type stubs included — full IDE autocompletion and type checking.
  • Requires CPython 3.10+.
  • Available for Linux (glibc 2.17+ and musl 1.2+; x86-64 and arm64), Windows (x86-64 and arm64), and macOS (10.12+ x86-64 and 11.0+ arm64).

Installation

pip install -U msql-driver

Conversions to NumPy or Pandas data types require optional dependencies:

pip install -U msql-driver[numpy]
pip install -U msql-driver[pandas]

Install optional dependencies for all available conversions:

pip install -U msql-driver[convert]

Streamlit integration requires an optional dependency:

pip install -U msql-driver[streamlit]

Install all optional dependencies using:

pip install -U msql-driver[all]

Example

import msql_driver

# Connect
session = msql_driver.SessionConfig().host(<address>).user(<org>, <user>, <password>).build()
print(session.status())  # SessionStatus.Connected

# Run a query (returns one Rows object per result set)
res, = session.run_query("select * from st.segment limit 10")

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

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

# Or convert the whole result at once:
rows = res.to_list()    # list of tuples of native Python types
arr = res.to_numpy()    # NumPy array (requires numpy)
df = res.to_pandas()    # Pandas dataframe (requires pandas)

# Cancellable query execution
result, cancel = session.submit_query("select * from st.segment")
# ... cancel.cancel() to abort
res_list = result.try_get()  # non-blocking, returns None if not ready
res_list = result.get()      # blocks until ready

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

License

Licensed under BSD 3-Clause "New" or "Revised" License.

Credits

Authored and maintained by Mireo.

Metadata

Release files for msql-driver 0.10.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Built distributions (wheels)

Table of built distributions (wheels) for msql-driver 0.10.0
File
msql_driver-0.10.0-cp310-abi3-win_arm64.whl CPython 3.10 abi3 Windows ARM64 Details
msql_driver-0.10.0-cp310-abi3-win_amd64.whl CPython 3.10 abi3 Windows x86-64 Details
msql_driver-0.10.0-cp310-abi3-musllinux_1_2_x86_64.whl CPython 3.10 abi3 Linux musl 1.2+ x86-64 Details
msql_driver-0.10.0-cp310-abi3-musllinux_1_2_aarch64.whl CPython 3.10 abi3 Linux musl 1.2+ ARM64 Details
msql_driver-0.10.0-cp310-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl CPython 3.10 abi3 Linux glibc 2.17+ x86-64 Details
msql_driver-0.10.0-cp310-abi3-manylinux_2_17_aarch64.manylinux2014_aarch64.whl CPython 3.10 abi3 Linux glibc 2.17+ ARM64 Details
msql_driver-0.10.0-cp310-abi3-macosx_11_0_arm64.whl CPython 3.10 abi3 macOS 11.0+ ARM64 Details
msql_driver-0.10.0-cp310-abi3-macosx_10_12_x86_64.whl CPython 3.10 abi3 macOS 10.12+ x86-64 Details

Total release size: 7.9 MB

Release files / msql_driver-0.10.0-cp310-abi3-win_arm64.whl

Download URL msql_driver-0.10.0-cp310-abi3-win_arm64.whl
Size 915.5 kB
Tags CPython 3.10 Windows ARM64 abi3
SHA-256 checksum
How to use checksums
1ab8b4b7ebb637942e0a50ef6b6f05560ce0c02ad262d070aae9389fb5854c43
BLAKE2b-256 checksum
How to use checksums
793e8e4c6a4f6e5282d70ca6d8c193352824fc99a7a9d4315efd181ccef395ab
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via uv/0.11.0 {"installer":{"name":"uv","version":"0.11.0","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":null,"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}

Release files / msql_driver-0.10.0-cp310-abi3-win_amd64.whl

Download URL msql_driver-0.10.0-cp310-abi3-win_amd64.whl
Size 1.1 MB
Tags CPython 3.10 Windows x86-64 abi3
SHA-256 checksum
How to use checksums
9a57d31405a83631b4b545bdb41d410c05dda269a4d5408c6e1182aebaf33ba6
BLAKE2b-256 checksum
How to use checksums
bc2d2e9b59f1bcabc0ccfaf389089a965185660e6822ba67fe9472dbc1d6d36a
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via uv/0.11.0 {"installer":{"name":"uv","version":"0.11.0","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":null,"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}

Release files / msql_driver-0.10.0-cp310-abi3-musllinux_1_2_x86_64.whl

Download URL msql_driver-0.10.0-cp310-abi3-musllinux_1_2_x86_64.whl
Size 1.0 MB
Tags CPython 3.10 Linux musl 1.2+ x86-64 abi3
SHA-256 checksum
How to use checksums
04284fa4fef3dcebf1751626562880b9e01f3bff5e94c9e9d2710d44ce790348
BLAKE2b-256 checksum
How to use checksums
46c098bbb01c47d1e1e9dc4440b0b5801d0e8332567f64f17b955987497b6622
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via uv/0.11.0 {"installer":{"name":"uv","version":"0.11.0","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":null,"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}

Release files / msql_driver-0.10.0-cp310-abi3-musllinux_1_2_aarch64.whl

Download URL msql_driver-0.10.0-cp310-abi3-musllinux_1_2_aarch64.whl
Size 972.4 kB
Tags CPython 3.10 Linux musl 1.2+ ARM64 abi3
SHA-256 checksum
How to use checksums
128bea64a863f2e980c6628f72e8a582971e51889aa46a2c87ebe13dd644eec1
BLAKE2b-256 checksum
How to use checksums
6accfd541ac1f770d3f8e656ab3b8a0446b6f1a2b4958a759cfa9d66d777f1cc
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via uv/0.11.0 {"installer":{"name":"uv","version":"0.11.0","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":null,"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}

Release files / msql_driver-0.10.0-cp310-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl

Download URL msql_driver-0.10.0-cp310-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Size 1.1 MB
Tags CPython 3.10 Linux glibc 2.17+ x86-64 abi3
SHA-256 checksum
How to use checksums
1f51aa00c51c0a0cd4fe3329aaf2235b59f51c930e41536fce6f84fbc361597c
BLAKE2b-256 checksum
How to use checksums
bb0ca206eb0a92d04d306c9983b1a582ad37dacd71ba61dfe8f69b5f4b59894e
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via uv/0.11.0 {"installer":{"name":"uv","version":"0.11.0","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":null,"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}

Release files / msql_driver-0.10.0-cp310-abi3-manylinux_2_17_aarch64.manylinux2014_aarch64.whl

Download URL msql_driver-0.10.0-cp310-abi3-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Size 972.3 kB
Tags CPython 3.10 Linux glibc 2.17+ ARM64 abi3
SHA-256 checksum
How to use checksums
3d04ba0aa2185ce7f4c01fecfe3176f37575faddb0e74bd7a0c6b2f1e4fc097c
BLAKE2b-256 checksum
How to use checksums
4a768f6a9b6c64549eab0df81cb2511ec3802aab2e1fa3bcd6c573c8fc81bc8f
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via uv/0.11.0 {"installer":{"name":"uv","version":"0.11.0","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":null,"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}

Release files / msql_driver-0.10.0-cp310-abi3-macosx_11_0_arm64.whl

Download URL msql_driver-0.10.0-cp310-abi3-macosx_11_0_arm64.whl
Size 916.0 kB
Tags CPython 3.10 abi3 macOS 11.0+ ARM64
SHA-256 checksum
How to use checksums
aa670d8eaf738d7a45aff295aff61715c545aadaf32fe8b57a7b19035e443838
BLAKE2b-256 checksum
How to use checksums
a2af060e5d2a8e124e850409351c16355fa3b75e7a1f0ea0f987e81cce003683
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via uv/0.11.0 {"installer":{"name":"uv","version":"0.11.0","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":null,"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}

Release files / msql_driver-0.10.0-cp310-abi3-macosx_10_12_x86_64.whl

Download URL msql_driver-0.10.0-cp310-abi3-macosx_10_12_x86_64.whl
Size 1.0 MB
Tags CPython 3.10 abi3 macOS 10.12+ x86-64
SHA-256 checksum
How to use checksums
5f06024f9ef5bd4112db1174672c352c9f5ddc658a5aea0f3bde67b55d1af2bb
BLAKE2b-256 checksum
How to use checksums
6fdde1a917061be0af18959eaa382088a612904937558c0c6d1834e5d53aef2d
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via uv/0.11.0 {"installer":{"name":"uv","version":"0.11.0","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":null,"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}

Security for msql-driver 0.10.0

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page