Open source SQL Query Assistant for Databases/Warehouses


Keywords
component, editor, query, sql
License
Apache-2.0
Install
pip install gethue==0.26

Documentation

PyPI version Test Status DockerPulls GitHub contributors Code coverage Status License

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

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'