Installation of SQL extensions

SQL Table widget supports PostgreSQL and MSSQL databases.

PostgreSQL

The components of Orange intended for work with SQL data require the following extensions on the PostgreSQL server (>= 9.5), where the data is stored:

• quantile - http://pgxn.org/dist/quantile

  It can be installed with pgxn client:

  pgxn install quantile
  pgxn load -d mydb quantile
  

  Or manually (after fetching the source from the link above):

  make install
  psql dbname -c "CREATE EXTENSION quantile"
  

• tsm_system_time

  Extension is part of the PostgreSQL contrib.

  cd contrib/tsm_system_time
  make install
  psql dbname -c 'CREATE EXTENSION tsm_system_time;'
  

MSSQL

Install pymssql module.

pip install pymssql

If using Python3.6, you might have issues with availability of wheels.

Or run into fatal error: 'sqlfront.h' file not found

You would need FreeTDS which you can install:

• On Debian-based systems: apt install freetds-dev
• On OSX: brew install freetds

If the error persists install pymssql from git:

pip install Cython

pip install git+https://github.com/pymssql/pymssql.git