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) requires a commercial license. See HTSQL Licensing.
After installing HTSQL, please see our HTSQL Handbook.
If you’re running a Debian or Ubuntu system, you can install HTSQL from our APT repository:
# wget -q -O - http://dist.htsql.org/misc/build.gpg.key | apt-key add -
# echo 'deb http://dist.htsql.org/debian stable free' >> /etc/apt/sources.list
# apt-get update
# apt-get install htsql
You need to install additional packages to use HTSQL with a database other than SQLite. For PostgreSQL:
# apt-get install htsql-pgsql
For MySQL:
# apt-get install htsql-mysql
We provide RPM packages for RedHat Enterprise Linux 6 or CentOS 6.
To include HTSQL RPM repository, run:
# rpm -Uvh http://dist.htsql.org/redhat/6/i386/HTSQL-release-1.0-1.el6.noarch.rpm
Now you can install HTSQL:
# yum install HTSQL
To install PostgreSQL or MySQL backend, run:
# yum install HTSQL-PGSQL
# yum install HTSQL-MYSQL
HTRAF is a toolkit for embedding data into HTML pages. HTRAF is written in Javascript and released under dual MIT/GPL license.
The latest build of HTRAF could be downloaded from http://dist.htsql.org/source/HTRAF-latest.zip.
To install HTSQL from source, please read Installing HTSQL.