harish2704 / sql-chart

Draw charts interactively from any SQL queries

SQL chart

Draw chart for any SQL queries

What is this?

A simple web application to visualize data from any arbitrary SQL query.

How it is working?

• set DB_CONNECTION string either in env variable or in config file
• Start the application by running run.sh. Visit 'http://127.0.0.1:8000/index.html'
• Enter the SQL query in the text box and submit.
• available columns in the data will be shown in UI. visualize the data by dragging columns into required axis. Also choose requied aggregation function for pivot table
• Entire state of the graph ( SQL, columns in each axis, aggregation function etc ) is stored in the URL ( in URL hash ) so that we can reload the page without loosing the data.

How to run this

git clone https://github.com/harish2704/sql-chart
cd sql-chart
pip2 install -r requirements.txt --user
# Edit config file and set database connection url. For details, refer https://docs.sqlalchemy.org/en/latest/core/engines.html
./run.sh

Screencast

Watch video

Thanks

• Authors of pivottable ( https://github.com/nicolaskruchten/pivottable ). The UI code is shamelessly copied from one of the examples given in this project.
• Simple backed api server ( server.js ) is written in https://falconframework.org/.
• https://plot.ly/javascript/

sql-chart's Issues

sqlalchemy.exc.ObjectNotExecutableError: Not an executable object: 'SELECT * from orders'

[2023-07-12 15:04:09 +0530] [78652] [ERROR] Error handling request /api/data?q=SELECT+*+from+orders
Traceback (most recent call last):
File "/home/prameela/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1408, in execute
meth = statement._execute_on_connection
AttributeError: 'str' object has no attribute '_execute_on_connection'

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/home/prameela/.local/lib/python3.10/site-packages/gunicorn/workers/sync.py", line 135, in handle
self.handle_request(listener, req, client, addr)
File "/home/prameela/.local/lib/python3.10/site-packages/gunicorn/workers/sync.py", line 176, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/home/prameela/.local/lib/python3.10/site-packages/falcon/api.py", line 244, in call
responder(req, resp, **params)
File "/home/prameela/PycharmProjects/text_to_chart/sql-chart/server.py", line 17, in on_get
result = conn.execute(sql)
File "/home/prameela/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1410, in execute
raise exc.ObjectNotExecutableError(statement) from err
sqlalchemy.exc.ObjectNotExecutableError: Not an executable object: 'SELECT * from orders'