SQL for Orange

We bet you’ve always wanted to use your SQL data in Orange, but you might not be quite sure how to do it. Don’t worry, we’re coming to the rescue.

The key to SQL files is installation of ‘psycopg2‘ library in Python.

 

WINDOWS

Go to this website and download psycopg2 package. Once your .whl file has downloaded, go to the file directory and run command prompt. Enter “pip install [file name]” and run it.

 

MAC OS X, LINUX

If you’re on Mac or Linux, install psycopg2 with this.

 

SQLTable

Upon opening Orange, you will be able to see a lovely new icon – SQL Table. Then just connect to your server and off you go!

 

10 thoughts on “SQL for Orange

  1. Hi, I have Orange 3.8.0 (git revision 58a5218) with Python 3.4. My OS is Windows 10 64 bit.
    I want to use the SQL Table function but when you run the program it sends “Please install the backend to use this widget”.
    I installed the version of Postgres 10 and I installed the component PSYCOPG2-2.6.2. Win32-PY 3.4-PG 9.5.3-release. exe.
    I also tried with the version psycopg2-2.6.2. Win-AMD64-PY 3.4-PG 9.5.3-release. exe but the result does not change.
    Could you help me?

          1. Yes, that is me. You can install it from .zip file from my branch if you wish.

    1. Dear Sagar, the proper wheel for my platform works just fine. Be careful to use a wheel for Python 3 (cp34 or cp35) as Orange 3.3.7 runs on Python 3.
      I hope you’ve managed to solve your issue.

Leave a Reply