pyvideo.org: Videos of Clark C. Evanshttp://www.pyvideo.org/speaker/181/clark-c--evans/rssen-usSun, 11 Mar 2012 00:00:00 -0600500PyOhio 2011: HTSQL is a WSGI reporting toolkit for Relational Databaseshttp://www.pyvideo.org/video/534/pyohio-2011--htsql-is-a-wsgi-reporting-toolkit-fo<p>Description</p>
HTSQL is a WSGI reporting toolkit for Relational Databases
Presented by Clark C. Evans
HTSQL is a URI-based high-level query language for relational databases; it is
written in the Python language. HTSQL is a wonderful complement existing WSGI-
based applications, making it trivial to create interactive dashboards,
complex reports. We use HTSQL as a REST query interface for data integration
and ad-hoc reporting by technical users or ``accidental programmers``.
Clark C. Evanshttp://www.pyvideo.org/video/534/pyohio-2011--htsql-is-a-wsgi-reporting-toolkit-fo46. HTSQL : a navigational query language for relational databaseshttp://www.pyvideo.org/video/728/46-htsql-a-navigational-query-language-for-rel<p>Abstract</p>
This poster will cover a description of the HTSQL query language
(http://htsql.org).
Catherine Devlin,Clark C. EvansSun, 11 Mar 2012 00:00:00 -0600http://www.pyvideo.org/video/728/46-htsql-a-navigational-query-language-for-relHTSQL - an insanely good WSGI / REST interface to your favorite databasehttp://www.pyvideo.org/video/365/pycon-2011--htsql---an-insanely-good-wsgi---rest-<p>Abstract</p>
HTSQL is a URI-based high-level query language for relational databases; it is
written in the Python language. HTSQL is a wonderful complement existing WSGI-
based applications, making it trivial to create interactive dashboards,
complex reports. We use HTSQL as a REST query interface for data integration
and ad-hoc reporting by technical users or ``accidental programmers``.
<p>Description</p>
The HTSQL processor is a high-level URI-based query language for relational
databases such as SQLite, PostgreSQL or MySQL. Since it's written in Python,
it is easy to integrate and generates immediate value as the core of your
application's custom reporting engine. HTSQL is like the Django or SQLAlchemy
ORMs in that it generates SQL, but unlike an ORM in that its design center is
completely different -- it was created for hard core reporting and not object
to relational mapping. Hence, it is a wonderful complement to existing WSGI-
based applications to easily create dashboards, complex reports. We use HTSQL
as a REST reporting interface for data integration and ad-hoc queries.
This talk will have two parts. In the first part we'll give a brief overview
of the rationale and design of the query language. In the second part, we'll
show how to hook the HTSQL processor into your WSGI application and how to
make custom commands, such as a simple calendar output from a table containing
a date column.
The talk will be presented by Clark Evans, HTSQL was developed by Kyrylo
Simonov. The main HTSQL site is [http://htsql.org](http://htsql.org) and the
code is at [http://bitbucket.org/prometheus/htsql](http://bitbucket.org/promet
heus/htsql). It'll be similar to previous talks, such as
[http://htsql.org/talks/20101103.html](http://htsql.org/talks/20101103.html).
Clark C. EvansFri, 11 Mar 2011 00:00:00 -0600http://www.pyvideo.org/video/365/pycon-2011--htsql---an-insanely-good-wsgi---rest-