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 -- http://mail.python.org/mailman/listinfo/python-announce-list Support the Python Software Foundation: http://www.python.org/psf/donations/