In one of the previous blog posts we mentioned that installing the optional dependency psycopg2 allows Orange to connect to PostgreSQL databases and work directly on the data stored there.
It is also possible to transfer a whole table to the client machine, keep it in the local memory, and continue working with it as with any other Orange data set loaded from a file. But the true power of this feature lies in the ability of Orange to leave the bulk of the data on the server, delegate some of the computations to the database, and transfer only the needed results. This helps especially when the connection is too slow to transfer all the data and when the data is too big to fit in the memory of the local machine, since SQL databases are much better equipped to work with large quantities of data residing on the disk.

If you want to test this feature it is now even easier to do so! A third party distribution called 2UDA provides a single installer for all major OS platforms that combines Orange and a PostgreSQL 9.5 server along with LibreOffice (optional) and installs all the needed dependencies. The database even comes with some sample data sets that can be used to start testing and using Orange out of the box. 2UDA is also a great way to get the very latest version of PostgreSQL, which is important for Orange as it relies heavily on its new TABLESAMPLE clause. It enables time-based sampling of tables, which is used in Orange to get approximate results quickly and allow responsive and interactive work with big data.

We hope this will help us reach an even wider audience and introduce Orange to a whole new group of people managing and storing their data in SQL databases. We believe that having lots of data is a great starting point, but the benefits truly kick in with the ability to easily extract useful information from it.


2 thoughts on “2UDA

  1. I am trying to connect Orange to postgresql database but an error appears when I select my server and database

    could not open extension control file “/usr/share/postgresql/9.5/extension/quantile.control”: No such file or directory

    Who can I resolve this error


    1. Orange uses two postgresql extensions for more effiecient data manipulation, which are usually not installed by default. 2UDA installer should take care of that and install postgres with everything needed, but you can also install them on a custom/existing pg server:

      If the data is small enough to be transferred, you can also use the option “Download data to local memory” and work with a local copy, which does require any support from the database side.

Leave a Reply