Skip to main content

Open source SQL Query Assistant for Databases/Warehouses

Project description

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'

Project details


Download files

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

Source Distribution

gethue-0.26.tar.gz (25.9 kB view hashes)

Uploaded source

Built Distribution

gethue-0.26-py3-none-any.whl (12.9 kB view hashes)

Uploaded py3

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page