Query language for the accidental programmer
Project description
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.
Installation Instructions
Download HTSQL source code:
$ hg clone http://bitbucket.org/prometheus/htsql
Build and install HTSQL:
$ cd htsql $ make build # make install
Installing HTSQL creates a htsql-ctl script. For general help and a list of commands, run:
$ htsql-ctl help
To start a command-line HTSQL shell, run:
$ htsql-ctl shell DBURI
To start an HTTP server running HTSQL, run:
$ htsql-ctl server DBURI [HOST [PORT]]
Here, DBURI specifies how to connect to the database and must have the form:
ENGINE://USER:PASS@HOST:PORT/DATABASE
See also:
- http://htsql.org/doc/install.html
Installation and Administration Guide
List of Changes
2.1.0 beta 1 (2011-03-08)
Ported to MySQL, Oracle and MS SQL Server.
Added support for projections (base^kernel).
2.0.1 final (2011-02-01)
Merged /:json and /:jsonex formatters; use /:jsonex layout to avoid CSRF issues.
Documentation updates.
2.0.0 rc 1 (2011-01-21)
HTRAF demo is promoted to a standalone project; see http://bitbucket.org/prometheus/htraf.
Added /:jsonex format: JSON with extra metadata.
Documentation updates.
2.0.0 beta 5 (2010-12-14)
Completed the SQLite backend.
Completed the standard library.
2.0.0 beta 4 (2010-12-05)
Refactored peep-hole optimization of the frame tree and SQL serialization; refined the generated SQL.
Refactored the internal API for adding functions.
Added new (experimental) syntax for infix function call.
Added an “Examples” section to the documentation.
Fixed compatibility with Python 2.5.
Many minor bugfixes, documentation updates, etc.
2.0.0 beta 3 (2010-11-09)
Refactored the translator from the term tree to the frame tree; added a new translation step to collapse nested frames and reduce SQL expressions.
Added the HTRAF demo: use HTSQL with client-side javascript to define complex dashboards.
Added the SSI demo: using HTSQL for web without giving direct access to the database.
Updated the tutorial, minor bugfixes, regression test updates, etc.
2.0.0 beta 2 (2010-10-01)
Refactored the translator from the expression graph to the term tree.
Added Content-Disposition header to :json and :csv renderers.
Merged the tutorial to the repository.
2.0.0 beta 1 (2010-09-21)
Initial beta release.
PostgreSQL and SQLite backends are (mostly) supported, the former more than the latter.
The SQL translator needs more work, in particular, the term tree, the frame structure and the serializer.
Lots of functions are either not implemented or missing a proper serializer, especially in the SQLite backend.
Other areas which need more work before the final release: rendering, introspection, regression tests and documentation.
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distributions
Built Distribution
File details
Details for the file HTSQL-2.1.0b1.zip.
File metadata
- Download URL: HTSQL-2.1.0b1.zip
- Upload date:
- Size: 1.3 MB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | b73e028107faf8f086af6a0e67bf4c5d9762752089140c4084629a523fa95a67 |
|
| MD5 | 828ed5a628e86a6c67dd472af02c4c04 |
|
| BLAKE2b-256 | f759c7551a7c02d5a5356303a9fa4c07a4fb6cc7e64c7abbb83345260110646d |
File details
Details for the file HTSQL-2.1.0b1.tar.gz.
File metadata
- Download URL: HTSQL-2.1.0b1.tar.gz
- Upload date:
- Size: 1.2 MB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 70c318f22b86fd4fe6712c94278cc8b8cf19ff80835120122536912e17aae120 |
|
| MD5 | 5a9566828a5bd982bb6007ebf4725834 |
|
| BLAKE2b-256 | cbb0214af72d0778cbeeb5effd4305cf84c0c9ea97eb4ccf38186f568369ff91 |
File details
Details for the file HTSQL-2.1.0b1-py2.6.egg.
File metadata
- Download URL: HTSQL-2.1.0b1-py2.6.egg
- Upload date:
- Size: 624.0 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | cb6a239f559ebbf2bb556e91c40f34ddde3d4d960815896edd34e06fbd72bbf2 |
|
| MD5 | 22101e45658e86dcb95897fe1fc549c2 |
|
| BLAKE2b-256 | 3b513e6600f2de82ec12df9192d8fecae3cbb3cc1fa361af69d6f2cce01f133f |
