WHERE PANEL

The Where Panel module is a Web App written in PHP to display properly where provenance information computed with the ProvSQL extension for PostgreSQL.

Features

Enter SQL queries directly in your browser and see immediately from where the result of each cell come from.

All queries supported with ProvSQL work also with this App.

Prerequisites

  1. Make sure you have a database with ProvSQL extension enabled. For any question, refer to the main README of the project.

  2. A Web Server supporting PHP with the lib pgsql enabled. We recommend the use of LAMP (or XAMP or MAMP depending on your OS).

Installation

Put the files of the Where Panel in the appropriate directory of your Web Server: for example /var/www/html with LAMP.

Enter proper information in the config file and, if needed, check if your PostgreSQL server is correctly configured in /etc/postgresql/X.X/main/pg_hba.conf (X.X is the version of the server currently running). Be sure you choose either trust or md5 as a method. If you use the md5 method make sure you have already set a passwd to the user. By default, the connexion string of the config file attempt to connect as user postgres with same dbname and passwd.

Testing your installation

Create a new database and run setup.sql, add_provenance.sql, and security.sql. Connect to this database and choose predefined queries or test with your own.

Using the Panel

The left panel displays all relations tagged with provenance indication. Type your query in the right part and observe the result. When your mouse is on a cell, all cells used to compute the result are highlighted.

Uninstalling

Delete files from your Web Server.

License

Contact