{"library":"presto-client","title":"Presto Client (Renamed to Trino Python Client)","description":"The `presto-client` library, currently at version 0.303.0, has been renamed and superseded by the `trino-python-client` project, which is available on PyPI as the `trino` package. While `presto-client` exists, it is largely a stub advising migration. Trino (formerly PrestoSQL) is a distributed SQL query engine for big data analytics. The actively maintained `trino` library provides a DBAPI 2.0 compliant client, with current versions released frequently, often monthly or bi-monthly, reflecting active development and maintenance.","language":"python","status":"renamed","last_verified":"Mon May 18","install":{"commands":["pip install trino"],"cli":null},"imports":["from trino.dbapi import connect","from trino.exceptions import TrinoQueryError"],"auth":{"required":false,"env_vars":[]},"quickstart":{"code":"import trino\nimport os\n\n# Connect to Trino using environment variables for host, port, etc.\n# Default to common local settings if env vars are not set.\nconn = trino.dbapi.connect(\n    host=os.environ.get('TRINO_HOST', 'localhost'),\n    port=int(os.environ.get('TRINO_PORT', '8080')),\n    user=os.environ.get('TRINO_USER', 'python_client'),\n    catalog=os.environ.get('TRINO_CATALOG', 'system'),\n    schema=os.environ.get('TRINO_SCHEMA', 'runtime'),\n    http_scheme=os.environ.get('TRINO_HTTP_SCHEME', 'http'),\n    auth=trino.auth.BasicAuthentication(\n        username=os.environ.get('TRINO_USERNAME', ''),\n        password=os.environ.get('TRINO_PASSWORD', '')\n    ) if os.environ.get('TRINO_USERNAME') else None,\n)\n\nwith conn.cursor() as cur:\n    cur.execute(\"SELECT node_id, uri FROM nodes LIMIT 5\")\n    for row in cur.fetchall():\n        print(row)\n","lang":"python","description":"This quickstart demonstrates how to connect to a Trino cluster, execute a simple query, and fetch results using the DBAPI 2.0 interface. It uses environment variables for configuration to avoid hardcoding sensitive information. The `with conn.cursor()` syntax is supported from version 0.334.0 onwards.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":{"tag":null,"tag_description":null,"last_tested":"2026-05-18","installed_version":null,"pypi_latest":"0.303.0","is_stale":null,"summary":{"python_range":"3.10–3.9","success_rate":50,"avg_install_s":3.4,"avg_import_s":0.68,"wheel_type":"wheel"},"results":[{"runtime":"python:3.10-alpine","python_version":"3.10","os_libc":"alpine (musl)","variant":"trino","exit_code":1,"wheel_type":null,"failure_reason":"build_error","import_side_effects":null,"install_time_s":null,"import_time_s":null,"mem_mb":null,"disk_size":null},{"runtime":"python:3.10-slim","python_version":"3.10","os_libc":"slim (glibc)","variant":"trino","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":3.7,"import_time_s":0.49,"mem_mb":12,"disk_size":"184M"},{"runtime":"python:3.11-alpine","python_version":"3.11","os_libc":"alpine (musl)","variant":"trino","exit_code":1,"wheel_type":null,"failure_reason":"build_error","import_side_effects":null,"install_time_s":null,"import_time_s":null,"mem_mb":null,"disk_size":null},{"runtime":"python:3.11-slim","python_version":"3.11","os_libc":"slim (glibc)","variant":"trino","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":3.3,"import_time_s":0.78,"mem_mb":13.4,"disk_size":"191M"},{"runtime":"python:3.12-alpine","python_version":"3.12","os_libc":"alpine (musl)","variant":"trino","exit_code":1,"wheel_type":null,"failure_reason":"build_error","import_side_effects":null,"install_time_s":null,"import_time_s":null,"mem_mb":null,"disk_size":null},{"runtime":"python:3.12-slim","python_version":"3.12","os_libc":"slim (glibc)","variant":"trino","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":2.8,"import_time_s":0.81,"mem_mb":13.2,"disk_size":"181M"},{"runtime":"python:3.13-alpine","python_version":"3.13","os_libc":"alpine (musl)","variant":"trino","exit_code":1,"wheel_type":null,"failure_reason":"build_error","import_side_effects":null,"install_time_s":null,"import_time_s":null,"mem_mb":null,"disk_size":null},{"runtime":"python:3.13-slim","python_version":"3.13","os_libc":"slim (glibc)","variant":"trino","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":2.8,"import_time_s":0.76,"mem_mb":14.2,"disk_size":"180M"},{"runtime":"python:3.9-alpine","python_version":"3.9","os_libc":"alpine (musl)","variant":"trino","exit_code":1,"wheel_type":null,"failure_reason":"build_error","import_side_effects":null,"install_time_s":null,"import_time_s":null,"mem_mb":null,"disk_size":null},{"runtime":"python:3.9-slim","python_version":"3.9","os_libc":"slim (glibc)","variant":"trino","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"clean","install_time_s":4.2,"import_time_s":0.58,"mem_mb":11.7,"disk_size":"183M"}]}}