htsql is a high-level query language for relational databases.
it is an abstraction layer above SQL
it machine-generates the SQL code and does so in a way that covers all
corner cases and usually runs faster than hand-written SQL queries
(according to the author, who is also the creator of YAML)
It's written in python and can be installed using the Python
easy_install utility (easy_install HTSQL) or pip.
Here is an example of how to use it: notice the URL, where I specify
username(at)host slash dbname.
Also notice that htsql shows you the query results and then the SQL
bash$ htsql-ctl shell pgsql://username(at)hostname/dbname
Interactive HTSQL Shell
Type 'help' for more information, 'exit' to quit the shell.
| count(tablename) |
| 74 |
FROM "public"."tablename" AS "tablename"
Please see http://htsql.org/doc/index.html for the documentation.
The author of htsql is available (via phone) for a Q&A session on the subject.
If there is interest, I could organize a meetup. We could watch one the video
presentations from the htsql web site, and then have a Q&A session with the
lapug by date
|Next:||From: Joe Conway||Date: 2011-12-14 02:34:58|
|Subject: PGDay.SoCal @ SCALE 10X|
|Previous:||From: Aleksey Tsalolikhin||Date: 2011-10-20 06:04:04|
|Subject: Automating aspects of Database Administration with CFEngine 3|