Skip site navigation (1) Skip section navigation (2)

HTSQL 2.1-RC1 : A Query Language for the Accidental Programmer

From: "Clark C(dot) Evans" <cce(at)clarkevans(dot)com>
To: "PostgreSQL Announce" <pgsql-announce(at)postgresql(dot)org>
Cc: "Kirill Simonov" <xi(at)resolvent(dot)net>
Subject: HTSQL 2.1-RC1 : A Query Language for the Accidental Programmer
Date: 2011-06-21 21:17:35
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-announce
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. 


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

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.
        The HTSQL homepage
        Get taste of HTSQL
        The HTSQL tutorial
        HTSQL source code

        IRC chat in #htsql on freenode
        The mailing list for users of HTSQL

HTSQL is copyright by Prometheus Research, LLC.  HTSQL is written by
Clark C. Evans <cce(at)clarkevans(dot)com> and Kirill Simonov

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.

pgsql-announce by date

Next:From: David FetterDate: 2011-06-27 06:00:54
Subject: == PostgreSQL Weekly News - June 26 2011 ==
Previous:From: Pavel GolubDate: 2011-06-21 10:18:07
Subject: MicroOLAP Database Designer for PostgreSQL 1.8.0 available

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group