I am proud to announce the beta release of the unofficial browser-based SQL Client for Analyze Boston at https://nattaylor.com/labs/analyzeboston
The client provides a browser-based interface for executing and display the results of SQL queries against Analyze Boston’s open data portal datasets.
The client is designed to stay lite, offering just:
SQL editor with syntax highlighting
HTML table results presentation
Typeahead schema search
Export to CSV, TSV & clipboard
At this time the configuration of the Analyze Boston open data portal does not include an Access-Control-Allow-Origin header so a browser extension is required to display error messages since they return a 409 status code which is blocked by default.
Eventually I’d like to contribute the source to Analyze Boston or CKAN (which powers Analyze Boston.) Along the way, I’d really like to add some sort of automated testing as well as cleanup the codebase.