HTSQL 2.1-RC1 : A Query Language for the Accidental Programmer
We'd like to announce the release candidate for
HTSQL 2.1, a high-level query language and web
service gateway for relational databases. HTSQL
is specifically designed for analytical inquiries
and targeted to data analysts and web developers.
HTSQL is implemented as a WSGI component, works
with PostgreSQL, MySQL, SQLite and could be used
to embed ad-hoc reporting features into your
Python application.
Homepage: http://htsql.org
Download: http://pypi.python.org/pypi/HTSQL/
Source: http://bitbucket.org/prometheus/htsql
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 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
We'd like to announce the next release of HTSQL, a high-level query language for relational databases. HTSQL is specifically designed for data analysts & web developers and makes writing and maintaining complex queries a pleasure. HTSQL can be used as a command-line interpreter, a WSGI application, or a Python library. # Create an HTSQL instance.
from htsql import HTSQL htsql = HTSQL("pgsql:htsql_demo")
# Find all schools matching the given pattern.
query = "/school?name~$pattern" for row in htsql.produce(query, pattern='art'): ... print row ... school(code=u'art', name=u'School of Art and Design', campus=u'old') school(code=u'la', name=u'School of Arts and Humanities', campus=u'old')
# For schools in the old campus, get # of associated programs and departments.
query = "/school{name, count(program), count(department)}?campus='old'" for row in htsql.produce(query): ... print "%s: %d programs, %d departments" % row ... School of Art and Design: 3 programs, 2 departments College of Education: 7 programs, 2 departments School of Arts and Humanities: 9 programs, 5 departments School of Natural Sciences: 6 programs, 4 departments
For more detailed instructions for use with Python, see http://htsql.org/doc/embed.html Homepage: http://htsql.org Download: http://pypi.python.org/pypi/HTSQL Source: http://bitbucket.org/prometheus/htsql Since our 2.1 release, we've focused on usability improvements. We've added a web-based query editor with syntax highlighting & completion. We also implemented a new configuration system to provide granular meta-data customization. Finally, we added plugins for Django and SQLAlchemy integration. For a detailed list of changes, see http://htsql.org/blog/htsql-2.2-final.html Please join us at #htsql on irc.freenode.net Clark C. Evans & Kirill Simonov
participants (1)
-
Clark C. Evans