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. Homepage: http://htsql.org Download: http://pypi.python.org/pypi/HTSQL/ Source: http://bitbucket.org/prometheus/htsql 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, http://us.pycon.org/2011/schedule/sessions/264/ 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/showcase.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.