pyproject.toml

[project]
name = "pydough"
dynamic = ["version"]
keywords = ["analytics"]
description = "Analytics DSL for Python"
readme = "README.md"
authors = [{name = "Bodo.ai"}]
requires-python = ">=3.10"

classifiers = [
    "Development Status :: 4 - Beta",
    "Intended Audience :: Developers",
    "License :: OSI Approved :: Apache Software License",
    "Operating System :: OS Independent",
    "Programming Language :: Python",
    "Programming Language :: Python :: 3.10",
    "Programming Language :: Python :: 3.11",
    "Programming Language :: Python :: 3.12",
]

# Note: sqlite is included in the standard library, so it doesn't need to be listed here.
# There is a bug in some unit tests when run with sqlglot>=26.8.0
# TODO: Upgrade pyarrow once the LLM package supports pyarrow>=23. Currently
# pinned to pyarrow==22 for compatibility with the LLM integration environment.
dependencies = ["pytz", "sqlglot==26.7.0", "pandas>=2.0.0", "jupyterlab", "pyarrow==22"]

[project.urls]
# TODO: Add homepage + documentation when docs are live.
Repository = "https://github.com/bodo-ai/PyDough"

[dependency-groups]
dev = [
    "pre-commit",
    "pytest",
    "ruff==0.6.7",
    "pytest-repeat",
    "boto3",
    "pydough[snowflake]",
    "pydough[mysql]",
    "pydough[postgres]",
    "pydough[server]",
    "pydough[bodosql]",
    "pydough[oracle]",
]

[project.optional-dependencies]
snowflake = ["snowflake-connector-python[pandas]==4.1.1"]
mysql = ["mysql-connector-python==9.5.0"]
postgres = ["psycopg2-binary"]
server = ["fastapi", "httpx", "uvicorn"]
bodosql = ["bodo>=2026.2", "bodosql>=2026.2", "pyiceberg[pyiceberg-core]==0.10.0"]
oracle = ["oracledb==3.4.2"]

# TODO: Remove this override once the LLM package supports pyarrow>=23.
# The base dependency pins pyarrow==22 for LLM compatibility, but bodo
# (via the bodosql extra) requires exactly pyarrow>=23,<23.1. Using >=22
# would let uv pick pyarrow 24+ which breaks bodo, so we pin to 23.0.x here.
[tool.uv]
override-dependencies = ["pyarrow>=23,<23.1"]

[build-system]
requires = ["hatchling", "hatch-vcs"]
build-backend = "hatchling.build"

[tool.hatch.version]
source = "vcs"

[tool.ruff]
unsafe-fixes = true
lint.extend-select = [
    "I",   # isort
    "UP",  # pyupgrade
    "C4",  # flake8-comprehensions
    "TID", # flake8-tidy-imports
]

lint.ignore = [
    "UP038",
]
# Don't run ruff on any ipython notebooks as they may have
# names that don't statically resolve.
exclude = ["**/*.ipynb"]

[tool.mypy]
# Don't run mypy on any ipython notebooks
exclude = '.*\.ipynb$'