gethue 0.13

Open source SQL Query Assistant for Databases/Warehouses

Compose

Query Editor component

Compose is the open source module powering the Hue SQL Assistant. It comes as Web service for querying any Databases & Data Warehouses or building your own Cloud SQL Editor. Contributions are welcome and more modules are on the way (Files, Catalog...).

Start

Hello World query

curl -u hue:hue https://localhost:8005/v1/editor/query/sqlite --data 'snippet={"statement":"SELECT 1000, 1001"}'

Docker

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

Pypi

pip install gethue

compose migrate
compose createsuperuser
compose start

Live docs

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

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
cd compose
python compose/manage.py runserver 0.0.0.0:8005

Checks

pre-commit run --all-files
pytest