Skip to content

Installation of SQL extensions

robertcv edited this page Jul 25, 2018 · 2 revisions

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

You can’t perform that action at this time.