I'd like to announce the release candidate for HTSQL 2.1,
a high-level query language for relational databases
specifically designed for data analysts & web developers.
Using HTSQL, you could provide an instant web API for
any existing PostgreSQL database. HTSQL works best
for databases that are properly normalized with
declared foreign key constraints.
Since 2.0 release, announced in February, we added many
new language features which increase the "query power"
of the language. HTSQL is now able to express quite
sophisticated business inquiries.
Homepage: http://htsql.org
Source: http://bitbucket.org/prometheus/htsql
The remaining work for the 2.1-FINAL includes more
documentation and specific focus on producing optimal
SQL for aggregates & projections.
The 2.2 release of HTSQL later this year will be
focused on "usability". It'll include improved
configuration, a query editor and formatting options.
Also for this release we've cleaned up the homepage
for HTRAF -- a javascript toolkit for constructing
attractive dashboards and interactive reports. This
toolkit is MIT licensed and implemented as a JQuery
plugin. For more detail, please visit http://htraf.org
Let's us know if you have any questions!
Clark C. Evans & Kirill Simonov
***********************************************************
HTSQL -- A Query Language for the Accidental Programmer
***********************************************************
HTSQL ("Hyper Text Structured Query Language") is a high-level query
language for relational databases. The target audience for HTSQL is
the accidental programmer -- one who is not a SQL expert, yet needs a
usable, comprehensive query tool for data access and reporting.
HTSQL is also a web service which takes a request via HTTP, translates
it into a SQL query, executes the query against a relational database,
and returns the results in a format requested by the user agent (JSON,
CSV, HTML, etc.).
Use of HTSQL with open source databases (PostgreSQL, MySQL, SQLite) is
royalty free under BSD-style conditions. Use of HTSQL with proprietary
database systems (Oracle, Microsoft SQL) requires a commercial license.
See ``LICENSE`` for details.
For installation instructions, see ``INSTALL``. For list of new
features in this release, see ``NEWS``. HTSQL documentation is in the
``doc`` directory.
http://htsql.org/
The HTSQL homepage
http://htsql.org/doc/introduction.html
Get taste of HTSQL
http://htsql.org/doc/tutorial.html
The HTSQL tutorial
http://bitbucket.org/prometheus/htsql
HTSQL source code
irc://irc.freenode.net#htsql
IRC chat in #htsql on freenode
http://lists.htsql.org/mailman/listinfo/htsql-users
The mailing list for users of HTSQL
HTSQL is copyright by Prometheus Research, LLC. HTSQL is written by
Clark C. Evans <cce@clarkevans.com> and Kirill Simonov
<xi@resolvent.net>.
Generous support for HTSQL was provided by the Simons Foundation.
This material is also based upon work supported by the National
Science Foundation under Grant #0944460.