Analyze Boston SQL Client Beta Release by Nat Taylor

Analyze Boston SQL Client Beta Release

Published on Apr 16, 2018. Updated on

I am proud to announce the beta release of the unofficial browser-based SQL Client for Analyze Boston at https://nattaylor.com/labs/analyzeboston

Screenshot of the Analyze Boston SQL Client beta release

The client provides a browser-based interface for executing and display the results of SQL queries against Analyze Boston’s open data portal datasets.

Features

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

Limitations

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.

Future Plans

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.

Feedback

Please send feedback to nattaylor@gmail.com

Nat Taylor — Blog, Product Management & Tinkering