After executing the query against a database, it then returns the results in a format best suited for the user agent (CSV, HTML, etc.).
HTSQL stands for "Hyper Text Structured Query Language".
Use of HTSQL with open source databases (PostgreSQL, MySQL, SQLite) is royalty free under BSD-style conditions.
Usage of HTSQL with proprietary database systems (Oracle, Microsoft SQL, DB2) requires a commercial license.
By default the server is listening on localhost:8080, but that can be changed, not to conflict with other apps.
Documentation is included in the download package.
Here are some key features of "HTSQL":
· Oracle (Database Client 10g or higher, Oracle 9i Client)
· Microsoft SQL Server (all versions)
· Python 2.5 to 3.0, but not 3.0
· PyYAML 3.07 or higher, compiled with LibYAML bindings
· psycopg2 2.0.10 or higher
· simplejson 2.0 or higher
· setuptools 0.6c9 or higher
What's New in This Release: [ read full changelog ]
· `tweak.django`: fixed the introspector missing auto-created many-to-many models, respect Django transaction context.
· `htsql-ctl shell`: improved output of `describe` command, allow multi-line queries when the input is not TTY.
· Configuration: added support for `!include` tag.
· Reduced memory footprint for large database schemas.
· Improved error reporting.
· Many other fixes and improvements.