Skip to main content
Help us improve Python packaging – donate today!

python interface to Phoenix and SQLAlchemy interfaces

Project Description

Phoenix database adapter for Python

pyphoenix is a Python library for accessing the Phoenix SQL database using the remote query server introduced in Phoenix 4.4. The library implements the standard DB API 2.0 interface, which should be familiar to most Python programmers. It include sqlachemy plugins.


The easiest way to install the library is using pip:

pip install pyPhoenix

You can also download the source code and install it manually:

cd /path/to/pyphoenix/
python install


The library implements the standard DB API 2.0 interface, so it can be used the same way you would use any other SQL database from Python, for example:

import pyphoenix

database_url = 'http://localhost:8765/'
conn = pyphoenix.connect(database_url, autocommit=True)

cursor = conn.cursor()
cursor.execute("CREATE TABLE users (id INTEGER PRIMARY KEY, username VARCHAR)")
cursor.execute("UPSERT INTO users VALUES (?, ?)", (1, 'admin'))
cursor.execute("SELECT * FROM users")
print cursor.fetchall()

Phoenix versions

Phoenix 4.7 uses a serialization based on Protocol Buffers (proto3) by default.

This library only supports Protocol serialization.

Setting up a development environment

If you want to quickly try out the included examples, you can set up a local virtualenv with all the necessary requirements:

virtualenv e
source e/bin/activate
pip install -r requirements.txt
python develop

If you need a Phoenix server for experimenting, you can get one running quickly using Vagrant:

vagrant up

You can connect to the virtual machine and work with the Phoenix shell from there:

vagrant ssh
/opt/phoenix/bin/ localhost

Interactive SQL shell

There is a Python-based interactive shell include in the examples folder, which can be used to connect to Phoenix and execute queries:

./examples/ http://localhost:8765/
no rows affected (1.363 seconds)
db=> UPSERT INTO test (id, name) VALUES (1, 'Lukas');
1 row affected (0.004 seconds)
db=> SELECT * FROM test;
|   ID | NAME  |
|    1 | Lukas |
1 row selected (0.019 seconds)

Running the test suite

The library comes with a test suite for testing Python DB API 2.0 compliance and various Phoenix-specific features. In order to run the test suite, you need a working Phoenix database and set the pyphoenix_TEST_DB_URL environment variable:

export pyphoenix_TEST_DB_URL='http://localhost:8765/'

Known issues

  • In general, the library has not been battle-tested yet. You might encounter almost any problem. Use with care.
  • You can only use the library in autocommit mode. The native Java Phoenix library also implements batched upserts, which can be committed at once, but this is not exposed over the remote server. (CALCITE-767)
  • TIME and DATE columns in Phoenix are stored as full timestamps with a millisecond accuracy, but the remote protocol only exposes the time (hour/minute/second) or date (year/month/day) parts of the columns. (CALCITE-797, CALCITE-798)
  • TIMESTAMP columns in Phoenix are stored with a nanosecond accuracy, but the remote protocol truncates them to milliseconds. (CALCITE-796)
  • ARRAY columns are not supported. (CALCITE-1050, PHOENIX-2585)


  • Creates versions for select
  • select over queryserver with pyphoenix



import sqlalchemy

db = sqlalchemy.create_engine('phoenix://localhost:8765/')
conn = db.connect()

Release history Release notifications

History Node


History Node


This version
History Node


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date
pyPhoenix-0.9.4-py2-none-any.whl (44.7 kB) Copy SHA256 hash SHA256 Wheel 2.7 Mar 20, 2017

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging CloudAMQP CloudAMQP RabbitMQ AWS AWS Cloud computing Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page