Groups > comp.lang.python.announce > #1101

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

Path	csiph.com!eeepc.pasdenom.info!news.pasdenom.info!news.dougwise.org!aioe.org!news.stack.nl!newsfeed.xs4all.nl!newsfeed5.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path	<cce@clarkevans.com>
X-Original-To	python-announce-list@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; 'url:pycon': 0.03; 'pycon': 0.03; 'irc': 0.03; 'high-level': 0.05; 'mysql,': 0.05; 'relational': 0.07; 'release,': 0.07; 'sql.': 0.07; 'sqlite': 0.07; 'python': 0.08; 'url:pypi': 0.08; 'accidental': 0.09; 'executes': 0.09; 'freenode': 0.09; 'homepage:': 0.09; 'http,': 0.09; 'message-id:@webmail.messagingengine.com': 0.09; 'postgresql.': 0.09; 'query,': 0.09; 'received:66.111.4.25': 0.09; 'received:out1.smtp.messagingengine.com': 0.09; 'url:bitbucket': 0.09; 'x-mailer:messagingengine.com webmail interface': 0.09; 'programmer': 0.12; "we'd": 0.15; 'csv,': 0.16; 'embed': 0.16; 'orm': 0.16; 'royalty': 0.16; 'sql)': 0.16; 'subject:Programmer': 0.16; 'subject:Query': 0.16; 'translates': 0.16; 'wsgi': 0.16; 'html,': 0.18; 'received:internal': 0.18; 'url:doc': 0.19; 'written': 0.20; 'cc:2**0': 0.21; 'directory.': 0.23; 'download:': 0.23; 'received:10.202': 0.23; 'received:10.202.2': 0.23; 'received:10.202.2.42': 0.23; 'received:66.111': 0.23; 'received:66.111.4': 0.23; 'received:compute2.internal': 0.23; 'received:messagingengine.com': 0.23; 'received:smtp.messagingengine.com': 0.23; 'foundation': 0.23; 'remaining': 0.24; 'installation': 0.24; 'code': 0.25; 'language': 0.26; 'reporting': 0.27; 'curious': 0.28; 'implemented': 0.28; 'proprietary': 0.29; 'taste': 0.30; 'expect': 0.30; 'list': 0.31; 'url:mailman': 0.31; 'gateway': 0.31; 'point,': 0.31; 'source': 0.31; 'supports': 0.32; 'requires': 0.33; 'under': 0.33; 'enough': 0.33; "we're": 0.34; 'generous': 0.34; 'novel': 0.34; 'structured': 0.34; 'yet': 0.34; 'user': 0.35; 'raw': 0.36; 'open': 0.36; 'current': 0.36; 'query': 0.36; 'to:addr:python- announce-list': 0.36; 'used': 0.36; 'tool': 0.36; 'science': 0.37; 'charset:us-ascii': 0.37; 'subject: : ': 0.37; 'release': 0.38; 'announce': 0.38; 'data': 0.38; 'url:org': 0.38; 'requested': 0.39; 'url:python': 0.39; 'to:addr:python.org': 0.40; 'could': 0.40; 'your': 0.61; 'fill': 0.61; 'header:Message-Id:1': 0.61; 'chat': 0.62; 'url:us': 0.62; 'results': 0.62; 'agent': 0.62; 'free': 0.62; 'copyright': 0.64; 'production': 0.65; 'national': 0.68; 'details.': 0.69; 'skip:= 50': 0.71; 'commercial': 0.71; 'license.': 0.72; 'months.': 0.73; 'research,': 0.82; 'ad-hoc': 0.84; 'querying': 0.84; 'url:2011': 0.84; 'gaps': 0.91; 'homepage': 0.91; 'evans': 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:subject:date; s=smtpout; bh=G66tE9hmkZrY0UDPv0uipQba/aY=; b=Ak62RzMeYqKsONZ0hcmkPR/MgUtwX+VXB1joY75MlxnGmOG7uQCz68hssoYn4DrCSg+Cp3bvllymxt+wYEqQKon3hm9dA6b6UQ08oYuurcxeViV2sEjWWzpCwUDa71iC7wpDy00mi2i07Yeh+35gfExLmZD5NxUAnCh7xvGAt8k=
X-Sasl-Enc	PhzTZBl4a88hUEPcum8EO0I1FYmtd1RwwVQiMg6dTxcm 1296593243
From	"Clark C. Evans" <cce@clarkevans.com>
To	python-announce-list@python.org
MIME-Version	1.0
Content-Transfer-Encoding	7bit
Content-Type	text/plain; charset="us-ascii"
X-Mailer	MessagingEngine.com Webmail Interface
Subject	HTSQL 2.0-FINAL : A Query Language for the Accidental Programmer
Date	Tue, 01 Feb 2011 15:47:23 -0500
X-Mailman-Approved-At	Wed, 02 Feb 2011 00:22:14 +0100
Cc	Kirill Simonov <xi@resolvent.net>
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.1562.1296602535.6505.python-announce-list@python.org> (permalink)
Lines	77
NNTP-Posting-Host	82.94.164.166
X-Trace	1296602535 news.xs4all.nl 81484 [::ffff:82.94.164.166]:43344
X-Complaints-To	abuse@xs4all.nl
Xref	csiph.com comp.lang.python.announce:1101

Show key headers only | View raw

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.

Back to comp.lang.python.announce | Previous | Next | Find similar | Unroll thread

Thread

HTSQL 2.0-FINAL : A Query Language for the Accidental Programmer "Clark C. Evans" <cce@clarkevans.com> - 2011-02-01 15:47 -0500

csiph-web