A native Python client for the Vertica database.
Project description
# vertica-python
vertica-python is a native Python adapter for the Vertica (http://www.vertica.com) database.
This package is a Python port of the excellent Vertica Ruby gem (https://github.com/sprsquish/vertica).
vertica-python is currently in a alpha stage; it has been tested for functionality, but does not have a test suite. Please use with caution, and feel free to submit issues and/or pull requests.
vertica-python has been tested with Vertica 6.1.2 and Python 2.6/2.7. Please let me know if it's working on other versions.
## Installation
If you're using pip >= 1.4 and you don't already have pytz installed:
pip install --pre pytz
To install vertica-python with pip:
pip install vertica-python
Source code for vertica-python can be found at:
http://github.com/uber/vertica-python
## Usage
**Buffered** (in-memory) results:
```
from vertica_python import connect
connection = connect({
'host': '127.0.0.1',
'port': 5433,
'user': 'some_user',
'password': 'some_password',
'database': 'a_database'
})
result = connection.query("SELECT * FROM a_table LIMIT 2")
connection.close()
print result.rows
# [{'id': 1, 'value': 'something'}, {'id': 2, 'value': 'something_else'}]
```
**Unbuffered** (streaming) results:
```
from vertica_python import connect
connection = connect({
'host': '127.0.0.1',
'port': 5433,
'user': 'some_user',
'password': 'some_password',
'database': 'a_database'
})
def magical_row_handler(row):
print row
result = connection.query("SELECT * FROM a_table LIMIT 2", options={}, handler=magical_row_jhandler)
# {'id': 1, 'value': 'something'}
# {'id': 2, 'value': 'something_else'}
connection.close()
```
## License
MIT License, please see `LICENSE` for details.
## Acknowledgements
Many thanks go to the contributors to the Ruby Vertica gem, since they did all of the wrestling with Vertica's protocol and have kept the gem updated. They are:
* [Matt Bauer](http://github.com/mattbauer)
* [Jeff Smick](http://github.com/sprsquish)
* [Willem van Bergen](http://github.com/wvanbergen)
* [Camilo Lopez](http://github.com/camilo)
vertica-python is a native Python adapter for the Vertica (http://www.vertica.com) database.
This package is a Python port of the excellent Vertica Ruby gem (https://github.com/sprsquish/vertica).
vertica-python is currently in a alpha stage; it has been tested for functionality, but does not have a test suite. Please use with caution, and feel free to submit issues and/or pull requests.
vertica-python has been tested with Vertica 6.1.2 and Python 2.6/2.7. Please let me know if it's working on other versions.
## Installation
If you're using pip >= 1.4 and you don't already have pytz installed:
pip install --pre pytz
To install vertica-python with pip:
pip install vertica-python
Source code for vertica-python can be found at:
http://github.com/uber/vertica-python
## Usage
**Buffered** (in-memory) results:
```
from vertica_python import connect
connection = connect({
'host': '127.0.0.1',
'port': 5433,
'user': 'some_user',
'password': 'some_password',
'database': 'a_database'
})
result = connection.query("SELECT * FROM a_table LIMIT 2")
connection.close()
print result.rows
# [{'id': 1, 'value': 'something'}, {'id': 2, 'value': 'something_else'}]
```
**Unbuffered** (streaming) results:
```
from vertica_python import connect
connection = connect({
'host': '127.0.0.1',
'port': 5433,
'user': 'some_user',
'password': 'some_password',
'database': 'a_database'
})
def magical_row_handler(row):
print row
result = connection.query("SELECT * FROM a_table LIMIT 2", options={}, handler=magical_row_jhandler)
# {'id': 1, 'value': 'something'}
# {'id': 2, 'value': 'something_else'}
connection.close()
```
## License
MIT License, please see `LICENSE` for details.
## Acknowledgements
Many thanks go to the contributors to the Ruby Vertica gem, since they did all of the wrestling with Vertica's protocol and have kept the gem updated. They are:
* [Matt Bauer](http://github.com/mattbauer)
* [Jeff Smick](http://github.com/sprsquish)
* [Willem van Bergen](http://github.com/wvanbergen)
* [Camilo Lopez](http://github.com/camilo)
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
vertica-python-0.1.8.tar.gz
(14.0 kB
view details)
File details
Details for the file vertica-python-0.1.8.tar.gz.
File metadata
- Download URL: vertica-python-0.1.8.tar.gz
- Upload date:
- Size: 14.0 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 22f1132d3d22ed4a1dbf9dfa3168aeee4cbd07733079f6b85a179de570005b9a |
|
| MD5 | 1069ccceb2a543811b02a3e7329318e8 |
|
| BLAKE2b-256 | 888045d0fa4e0918ec47aa20bd7aca5a2521bfd96f4b6a80581a4193296e14ae |
