gethue 0.26

Open source SQL Query Assistant for Databases/Warehouses

Compose

Query Editor component

Compose is the open source module powering the Hue SQL Editor. It comes as a Web service API for querying any Databases & Data Warehouses or building your own Cloud SQL Editor.

Start

Hello World query

curl -u hue:hue -X POST http://localhost:8005/editor/v1/query/sqlite --data 'statement=SELECT 100, 200'

Docker

docker run -it -p 8005:8005 gethue/compose:latest

Pypi

pip install gethue

compose-admin migrate
compose-admin createsuperuser
compose-admin start

compose auth
compose query
compose storage list s3a://demo-gethue

Dev

One time

git clone https://github.com/gethue/compose.git
cd compose
./install.sh  # If you want a Python virtual-env
pre-commit install

Start API

source python_env/bin/activate
python compose/manage.py runserver 0.0.0.0:8005

Config

compose/conf/local_settings.py

Checks

pre-commit run --all-files
python compose/manage.py test

Hue

npm run webpack-npm

API

Live

• https://api.gethue.com/api/schema/swagger-ui/
• https://api.gethue.com/api/schema/redoc/

Query

curl -u hue:hue -X POST http://localhost:8005/api/editor/execute/sqlite --data 'statement=SELECT 100, 200'

curl -u hue:hue -X POST http://localhost:8005/api/editor/execute/sqlite --data 'statement=SELECT 100, 200'
curl -u hue:hue -X POST http://localhost:8005/api/editor/check_status --data 'qid=abc'
curl -u hue:hue -X POST http://localhost:8005/api/editor/fetch_result_data --data 'qid=abc'