pinotdb

Install

pinotdb on PyPI

pip install pinotdb

uv add pinotdb

poetry add pinotdb

Package facts

Evidence: pinotdb-9.1.2-py3-none-any.whl

About pinotdb

from the package's own PyPI description — quoted content, verbatim

from pinotdb import connect

# this assumes 8000 is the broker port
conn = connect(host='localhost', port=8000, path='/query/sql', scheme='http')
curs = conn.cursor()
curs.execute("""
    SELECT place,
           CAST(REGEXP_EXTRACT(place, '(.*),', 1) AS FLOAT) AS lat,
           CAST(REGEXP_EXTRACT(place, ',(.*)', 1) AS FLOAT) AS lon
      FROM places
     LIMIT 10
""")
for row in curs:
    print(row)

from pinotdb import connect

# this assumes that 443 is the broker secure https port
conn = connect(host='localhost', port=443, path='/query/sql', scheme='https')
curs = conn.cursor()
curs.execute("""
    SELECT place,
           CAST(REGEXP_EXTRACT(place, '(.*),', 1) AS FLOAT) AS lat,
           CAST(REGEXP_EXTRACT(place, ',(.*)', 1) AS FLOAT) AS lon
      FROM places
     LIMIT 10
""")
for row in curs:
    print(row)

Read as markdown · JSON record · Source repository · Homepage

AI interpretation — verify before relying

AI-generated interpretation of the package facts above; every digit, version, license, or vulnerability id it cites is grounded in the facts already shown on this page

A Python DB-API and SQLAlchemy dialect for querying Apache Pinot via its SQL API, supporting both synchronous and asynchronous connections with optional authentication and multi-stage engine configuration.

Low install friction with four lightweight runtime dependencies (ciso8601, h11, httpx, urllib3). Package is actively maintained with a recent release 80 days ago and an active repository.

MIT license permits unrestricted use, modification, and distribution in both open-source and commercial contexts with minimal obligations.

from pinotdb import connect

conn = connect(host='localhost', port=8000, path='/query/sql', scheme='http')
curs = conn.cursor()
curs.execute('SELECT * FROM places LIMIT 10')
for row in curs:
    print(row)

Verdict: A well-maintained, permissively licensed connector for Pinot with low install friction and no known vulnerabilities. Suitable for production use in environments with active Pinot deployments, supporting both traditional and async SQLAlchemy patterns.

Needs verification

• Whether the package's four runtime dependencies themselves have any known vulnerabilities or maintenance concerns.
• Performance characteristics and query timeout behavior under high-load or network-latency scenarios.
• Compatibility guarantees with Pinot versions beyond the stated 1.1.0 support.

Similar packages