From: | Aleksey Tsalolikhin <atsaloli(dot)tech(at)gmail(dot)com> |
---|---|
To: | Los Angeles PostgreSQL Users Group <lapug(at)postgresql(dot)org> |
Subject: | Any interest in a presentation on htsql? |
Date: | 2011-10-20 18:36:45 |
Message-ID: | CA+jMWoebFCE5OAUXbe6-TcEB+ZJxs16StDykKZY7C3nq6EpX8Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | lapug |
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
query itself.
bash$ htsql-ctl shell pgsql://username(at)hostname/dbname
Interactive HTSQL Shell
Type 'help' for more information, 'exit' to quit the shell.
dbname$ /count(tablename)
| count(tablename) |
-+--------------------------+-
| 74 |
(1 row)
----
/count(tablename)
SELECT COUNT(TRUE)
FROM "public"."tablename" AS "tablename"
dbname$
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
author.
Yours truly,
-at
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2011-12-14 02:34:58 | PGDay.SoCal @ SCALE 10X |
Previous Message | Aleksey Tsalolikhin | 2011-10-20 06:04:04 | Automating aspects of Database Administration with CFEngine 3 |