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":
Supports:
· PostgreSQL
· MySQL
· SQLite
· Oracle (Database Client 10g or higher, Oracle 9i Client)
· Microsoft SQL Server (all versions)
Requirements:
· 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 ]
· Updated API for making HTSQL requests from Python application.
· Improved error messages; added suggestions for lookup errors.
· `tweak.override`: added support for global functions, parameterized calculations.
Find us on Google+
