基于Web的查询编辑器：HTSQL

HTSQL 是一个基于 URI 的关系数据库高级查询语言，使用 Web 服务层对数据库访问进行封装，并将 HTTP 请求转成 SQL 命令并返回查询结果，格式是 HTML 或者 JSON。

Debian / Ubuntu
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

RedHat EL / CentOS
We provide RPM packages for RedHat Enterprise Linux 6 or CentOS 6.
Note:
You may need to add the EPEL repository to satisfy the dependency on PyYAML.
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