{"author":"Vitaly Markov","author_email":"wild.desu@gmail.com","bugtrack_url":null,"classifiers":["Development Status :: 5 - Production/Stable","Intended Audience :: Developers","License :: OSI Approved :: MIT License","Programming Language :: Python :: 3","Programming Language :: Python :: 3.10","Programming Language :: Python :: 3.11","Programming Language :: Python :: 3.12","Programming Language :: Python :: 3.9","Topic :: Database"],"description":"

Pyexasol

\n\n $\"Continuous$ \n\n\n $\"Anaconda\"$ \n\n\n $\"PyPi$ \n\n\n $\"Downloads\"$ \n\n\n $\"Supported$ \n\n

\n\nPyEXASOL is the officially supported Python connector for [Exasol](https://www.exasol.com). It helps to handle massive volumes of data commonly associated with this DBMS.\n\nYou may expect significant performance improvement over ODBC in a single process scenario involving pandas.\n\nPyEXASOL provides API to read & write multiple data streams in parallel using separate processes, which is necessary to fully utilize hardware and achieve linear scalability. With PyEXASOL you are no longer limited to a single CPU core.\n\n\n## Quick links\n- [Getting started](#getting-started)\n- [Reference](/docs/REFERENCE.md)\n- [Examples](/docs/EXAMPLES.md)\n- [Best practices](/docs/BEST_PRACTICES.md)\n- [Local config (.ini file)](/docs/LOCAL_CONFIG.md)\n- [SQL formatting](/docs/SQL_FORMATTING.md)\n- [HTTP Transport](/docs/HTTP_TRANSPORT.md)\n- [HTTP Transport (multiprocessing)](/docs/HTTP_TRANSPORT_PARALLEL.md)\n- [Parallelism](/docs/PARALLELISM.md)\n- [SSL encryption](/docs/ENCRYPTION.md)\n- [WebSocket protocol versions](/docs/PROTOCOL_VERSION.md)\n- [Performance tests](/docs/PERFORMANCE.md)\n- [UDF scripts output](/docs/SCRIPT_OUTPUT.md)\n- [DB-API 2.0 compatibility](/docs/DBAPI_COMPAT.md)\n- [Optional dependencies](/docs/DEPENDENCIES.md)\n- [Changelog](/CHANGELOG.md)\n- [Developer Guide](/docs/DEVELOPER_GUIDE.md)\n\n\n## PyEXASOL main concepts\n\n- Based on [WebSocket protocol](https://github.com/exasol/websocket-api);\n- Optimized for minimum overhead;\n- Easy integration with pandas via HTTP transport;\n- Compression to reduce network bottleneck;\n\n\n## System requirements\n\n- Exasol >= 7.1\n- Python >= 3.9\n\n\n## Getting started\n\nInstall PyEXASOL:\n```\npip install pyexasol[pandas]\n```\n\nRun basic query:\n```python\nimport pyexasol\n\nC = pyexasol.connect(dsn='', user='sys', password='exasol')\n\nstmt = C.execute(\"SELECT * FROM EXA_ALL_USERS\")\n\nfor row in stmt:\n print(row)\n```\n\nLoad data into `pandas.DataFrame`:\n```python\nimport pyexasol\n\nC = pyexasol.connect(dsn='', user='sys', password='exasol', compression=True)\n\ndf = C.export_to_pandas(\"SELECT * FROM EXA_ALL_USERS\")\nprint(df.head())\n```\n\nYou may set up [local config](/docs/LOCAL_CONFIG.md) to store your personal Exasol credentials and connection options:\n```python\nimport pyexasol\n\nC = pyexasol.connect_local_config('my_config')\n\nstmt = C.execute(\"SELECT CURRENT_TIMESTAMP\")\nprint(stmt.fetchone())\n```\n\nConnect to Exasol SAAS using OpenID token for authentication:\n\n```python\nimport pyexasol\n\nC = pyexasol.connect(dsn='', user='sys', refresh_token='')\n\nstmt = C.execute(\"SELECT * FROM EXA_ALL_USERS\")\n\nfor row in stmt:\n print(row)\n```\n\n## Created by\n[Vitaly Markov](https://www.linkedin.com/in/markov-vitaly/), 2018 — 2022\n\nEnjoy!\n\n## Maintained by\n[Exasol](https://www.exasol.com) 2023 — Today \n","description_content_type":"text/markdown","docs_url":null,"download_url":null,"downloads":{"last_day":-1,"last_month":-1,"last_week":-1},"dynamic":null,"home_page":null,"keywords":"exasol, sql, database, performance, websocket, import, export","license":"MIT","license_expression":null,"license_files":null,"maintainer":null,"maintainer_email":null,"name":"pyexasol","package_url":"https://pypi.org/project/pyexasol/","platform":null,"project_url":"https://pypi.org/project/pyexasol/","project_urls":{"Changelog":"https://github.com/exasol/pyexasol/blob/master/CHANGELOG.md","Documentation":"https://github.com/exasol/pyexasol/","Homepage":"https://www.exasol.com/","Issues":"https://github.com/exasol/pyexasol/issues","Source":"https://github.com/exasol/pyexasol"},"provides_extra":null,"release_url":"https://pypi.org/project/pyexasol/0.27.0/","requires_dist":["websocket-client>=1.0.1","pyopenssl","rsa","packaging","numpy<2,>1.26.0; extra == \"numpy\"","pandas[numpy]<3,>=2; extra == \"pandas\"","ujson; extra == \"ujson\"","python-rapidjson; extra == \"rapidjson\"","orjson>=3.6; extra == \"orjson\"","pproxy; extra == \"examples\""],"requires_python":"<4.0,>=3.9","summary":"Exasol python driver with extra features","version":"0.27.0","yanked":false,"yanked_reason":null}

Dependency	Optional
packaging	false
pyopenssl	false
rsa	false
websocket-client	false
numpy	true
orjson	true
pandas	true
pproxy	true
python-rapidjson	true
ujson	true

Package search

pyexasol

project_urls

Dependencies

All package metadata

Releases