HTSQL 2.0-FINAL : A Query Language for the Accidental Programmer

Clark C. Evans cce at
Tue Feb 1 21:47:23 CET 2011

We'd like to announce the final release of HTSQL 2.0,
a novel approach to querying a relational database,
which is neither an ORM nor raw SQL.

HTSQL is a URI-based high-level query language and web 
service gateway for relational databases.  HTSQL is
implemented as a WSGI component and could be used to 
embed ad-hoc reporting in your Python application.


At this point, HTSQL 2.0 may not be mature enough for 
production use; we expect to fill in any remaining gaps 
in the coming months.  The current release supports
SQLite and PostgreSQL.  

We're curious what you think.  See you at PyCon 2011,

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> and
Kirill Simonov <xi at>.

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.

More information about the Python-announce-list mailing list