pydoris-custom

What it is and what it does

This is a Python driver for Apache Doris, a real-time analytical database designed for fast queries on large datasets. It wraps the Doris client protocol and exposes it through SQLAlchemy, so you can use standard SQLAlchemy patterns to connect, query, and fetch results. The package depends on sqlalchemy for ORM/query building, mysqlclient for the underlying protocol connection, and requests for HTTP communication.

The custom build removes sqlalchemy-utils, which the original package included but never actually used, making the install lighter. It supports Python 3.7 through 3.11 and is marked production-stable. The package is actively maintained and has no known security vulnerabilities.

Use it for:

• Running analytical queries on Doris from a Python application using SQLAlchemy's query API
• Building data pipelines that read from Doris and transform results in Python
• Connecting a web framework (Django, Flask) to a Doris backend for reporting or dashboards
• Prototyping analytics code against a Doris cluster before deploying to production
• Integrating Doris queries into Python data science workflows alongside pandas or numpy

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

A Python client for Apache Doris that provides SQLAlchemy integration to query a high-performance analytical database with sub-second response times on large datasets.

Yes, if you need to query Apache Doris from Python. The package is production-stable, actively maintained, has no vulnerabilities, and low install friction. The custom build removes unnecessary bloat. The only caveat is that mysqlclient may require system libraries on some platforms, but that is a one-time setup cost.

Install

pydoris-custom on PyPI

pip install pydoris-custom

uv add pydoris-custom

poetry add pydoris-custom

Installing pydoris-custom

Before you install

Low friction install with three stable runtime dependencies (sqlalchemy, mysqlclient, requests). The package is actively maintained with recent commits and marked production-stable. The custom build removes an unused dependency, reducing bloat.

License in practice

Apache 2.0 is permissive; you can use this package in commercial and proprietary projects with minimal restrictions, provided you include a copy of the license.

Quickstart

pip install pydoris-custom

from sqlalchemy import create_engine, text

engine = create_engine('doris://root:password@localhost:9030/catalog.database')
connection = engine.connect()
rows = connection.execute(text('SELECT * FROM table')).fetchall()

mysqlclient requires MySQL development headers; on some systems you may need to install libmysqlclient-dev or equivalent before pip install succeeds.

Verify before relying

• Whether mysqlclient requires system-level MySQL development libraries on your platform
• Performance characteristics and query latency on datasets of different scales
• Compatibility with specific Doris versions beyond what the README documents

Package facts

Evidence: pydoris_custom-1.1.0-py3-none-any.whl

Tags

More Front-Ends packages