pydoris

What it is and what it does

Pydoris bridges Python applications to Apache Doris, an MPP analytical database designed for sub-second query response times on large datasets. It provides a SQLAlchemy dialect that lets you connect using standard SQLAlchemy patterns—create_engine with a doris:// URL, then execute queries through the connection object. The package depends on sqlalchemy, sqlalchemy-utils, mysqlclient, and requests, making it a thin wrapper around Doris's wire protocol.

You use it when you need Python code to query Doris for reporting, ad-hoc analysis, or data lake acceleration. It's not an ORM layer but a database driver: you write SQL or use SQLAlchemy's text() construct to run queries and fetch results. The package requires Python 3.7 or later and is marked as production-stable.

Use it for:

• Connect a Python analytics or reporting application to Doris for real-time query execution.
• Build ETL pipelines that read from Doris using SQLAlchemy's connection and metadata introspection.
• Execute ad-hoc SQL queries against a Doris cluster from Python scripts or Jupyter notebooks.
• Integrate Doris as a backend for a data warehouse or data lake query layer in a larger Python service.

Worth the install?

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

Pydoris is a Python client for Apache Doris that enables SQLAlchemy-based database connections and query execution against a Doris analytical database.

Yes. Pydoris is actively maintained, carries no known vulnerabilities, has low install friction, and is licensed permissively. Install it if you need to query Apache Doris from Python—it's the standard SQLAlchemy dialect for that purpose. No significant blockers.

Install

pydoris on PyPI

pip install pydoris

uv add pydoris

poetry add pydoris

Installing pydoris

Before you install

Low install friction with a pure-Python wheel distribution. The package is actively maintained with a recent release and carries a high star count on its repository, suggesting stable community adoption.

License in practice

Licensed under Apache 2.0 (permissive), which allows commercial use, modification, and distribution with minimal restrictions—suitable for most production and proprietary projects.

Quickstart

pip install pydoris

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()

Requires Python 3.7 or later; mysqlclient dependency may require system libraries for compilation on some platforms.

Verify before relying

• Whether the package supports connection pooling or concurrent query execution patterns.
• Performance characteristics and query timeout behavior when working with large result sets.
• Whether SQLAlchemy ORM features (not just raw SQL) are fully supported through this dialect.

Package facts

Evidence: pydoris-1.2.0-py3-none-any.whl

Tags

More Front-Ends packages