Download

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 the HTSQL License.

After installing HTSQL, see also Using and Configuring HTSQL.

Debian / Ubuntu

If you’re running a debian-derived system, you can install HTSQL from our APT repository:

# wget -O - http://htsql.org/apt/build.gpg.key | apt-key add -
# echo 'deb http://htsql.org/apt htsql non-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

Alternatively, you could download and install htsql_2.2.1-1_all.deb directly.

RedHat EL6 / CentOS

For RedHat Enterprise Linux 6 or CentOS 6, you must first install dependencies which are PyYAML and python-setuptools available from the EPEL 6 repository:

# yum install PyYAML
# yum install python-setuptools

For PostgreSQL, you’ll need to install psycopg2:

# yum install python-psycopg2

For MySQL, install:

# yum install MySQL-python

Finally, you can install the HTSQL RPM with:

# rpm -Uvh http://htsql.org/dist/HTSQL-2.2.1-1.el6.noarch.rpm

HTRAF Toolkit

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://htsql.org/dist/HTRAF-2.0.0b1.zip.

Install from Source

To install from source, please read Installing HTSQL.