Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.python.announce > #438
| Path | csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.chainon-marquant.org!gegeweb.org!de-l.enfer-du-nord.net!feeder2.enfer-du-nord.net!news.mixmin.net!feeder.erje.net!xlned.com!feeder7.xlned.com!news2.euro.net!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail |
|---|---|
| Return-Path | <cce@clarkevans.com> |
| X-Original-To | python-announce@python.org |
| Delivered-To | python-announce-list@mail.python.org |
| X-Spam-Status | OK 0.000 |
| X-Spam-Evidence | '*H*': 1.00; '*S*': 0.00; 'python,': 0.01; 'high- level': 0.05; 'url:bitbucket': 0.07; 'python': 0.08; 'url:pypi': 0.08; 'command-line': 0.09; 'homepage:': 0.09; 'instance.': 0.09; 'interpreter,': 0.09; 'message-id:@webmail.messagingengine.com': 0.09; 'relational': 0.09; 'release,': 0.09; 'x-mailer:messagingengine.com webmail interface': 0.09; '2.1': 0.15; 'campus,': 0.16; 'design:': 0.16; 'education:': 0.16; 'highlighting': 0.16; 'integration.': 0.16; 'row': 0.16; 'sqlalchemy': 0.16; 'subject:Language': 0.16; 'subject:Programmer': 0.16; 'subject:Query': 0.16; 'url:embed': 0.16; 'wsgi': 0.16; 'syntax': 0.16; 'url:blog': 0.17; 'language': 0.17; '>>>': 0.18; 'received:internal': 0.18; "we'd": 0.21; 'header:In-Reply-To:1': 0.22; 'download:': 0.23; 'received:10.202': 0.23; 'received:10.202.2': 0.23; 'received:66.111': 0.23; 'received:66.111.4': 0.23; 'received:messagingengine.com': 0.23; 'received:smtp.messagingengine.com': 0.23; 'usability': 0.23; 'cc:2**0': 0.24; 'changes,': 0.24; 'library.': 0.24; 'subject: : ': 0.25; 'url:doc': 0.25; 'django': 0.26; 'import': 0.27; 'specifically': 0.27; 'print': 0.29; 'developers': 0.32; 'matching': 0.32; 'list': 0.32; 'arts': 0.34; 'skip:" 20': 0.35; 'url:python': 0.36; '...': 0.36; 'charset:us-ascii': 0.37; 'query': 0.37; 'skip:" 10': 0.37; 'announce': 0.38; 'url:org': 0.39; 'maintaining': 0.39; 'to:addr:python.org': 0.40; 'more': 0.61; 'join': 0.61; 'art': 0.61; 'header:Message-Id:1': 0.62; "we've": 0.62; 'our': 0.64; 'natural': 0.66; 'designed': 0.69; 'programs,': 0.80; 'evans': 0.91; 'plugins': 0.91; 'schools': 0.93 |
| DKIM-Signature | v=1; a=rsa-sha1; c=relaxed/relaxed; d= messagingengine.com; h=message-id:from:to:cc:mime-version :content-transfer-encoding:content-type:references:subject :in-reply-to:date; s=smtpout; bh=N9YD1VtiFH6BPgW/q08RaO5JP/E=; b= hxEdscoKeQiMGY0vesSR4do/W4yFn9gHlD8ix5Vj4GyqO1fjsYdEIxQHZMkQyBsB LiX4ZUKPsVUNbDqTFHMB6Q13pqnjyftx+ISaloTLVU6ql5RAw+Swur4TD5ibyIhP WRT2BoHRbY+bakDtqgniQeraNhJRVWRKbbIz4vlXt6Y= |
| X-Sasl-Enc | VDt977R/TJaKEjvV39LfmTmw5HPlbbCjrL3DkJkqsXEd 1324004884 |
| From | "Clark C. Evans" <cce@clarkevans.com> |
| To | python-announce@python.org |
| MIME-Version | 1.0 |
| Content-Transfer-Encoding | 7bit |
| Content-Type | text/plain; charset="us-ascii" |
| X-Mailer | MessagingEngine.com Webmail Interface |
| References | <1308707767.26897.1465823453@webmail.messagingengine.com> |
| Subject | HTSQL 2.2 : A Query Language for the Accidental Programmer |
| In-Reply-To | <1308707767.26897.1465823453@webmail.messagingengine.com> |
| Date | Thu, 15 Dec 2011 22:08:04 -0500 |
| X-Mailman-Approved-At | Fri, 16 Dec 2011 17:06:47 +0100 |
| X-BeenThere | python-announce-list@python.org |
| X-Mailman-Version | 2.1.12 |
| Precedence | list |
| Reply-To | python-list@python.org |
| List-Id | Announcement-only list for the Python programming language <python-announce-list.python.org> |
| List-Unsubscribe | <http://mail.python.org/mailman/options/python-announce-list>, <mailto:python-announce-list-request@python.org?subject=unsubscribe> |
| List-Archive | <http://mail.python.org/pipermail/python-announce-list> |
| List-Post | <mailto:python-announce-list@python.org> |
| List-Help | <mailto:python-announce-list-request@python.org?subject=help> |
| List-Subscribe | <http://mail.python.org/mailman/listinfo/python-announce-list>, <mailto:python-announce-list-request@python.org?subject=subscribe> |
| Approved | python-announce-list@python.org |
| Newsgroups | comp.lang.python.announce |
| Message-ID | <mailman.3732.1324051608.27778.python-announce-list@python.org> (permalink) |
| Lines | 47 |
| NNTP-Posting-Host | 2001:888:2000:d::a6 |
| X-Trace | 1324051608 news.xs4all.nl 6870 [2001:888:2000:d::a6]:40900 |
| X-Complaints-To | abuse@xs4all.nl |
| Xref | x330-a1.tempe.blueboxinc.net comp.lang.python.announce:438 |
Show key headers only | View raw
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
Back to comp.lang.python.announce | Previous | Next | Find similar | Unroll thread
HTSQL 2.2 : A Query Language for the Accidental Programmer "Clark C. Evans" <cce@clarkevans.com> - 2011-12-15 22:08 -0500
csiph-web