README.md

Introduction

Plotpg is an open source experiment to generate charts from postgresql result sets.

The plotpg project page provides a demo of basic features.

More technical details and examples are available in the project wiki.

Installation

Plotpg is a typical postgresql extension.

git clone git@github.com:no0p/plotpg.git
cd plotpg
make
sudo make install

Plotpg provides a plot function for plotting data, and a gnuplot function for plotting analytic functions. After installation, these functions can be added to a database with the following command in psql.

=# create extension plotpg;

A Gnuplot Dependency

Plotpg uses the gnuplot program to generate plot data. So the extension will only work if this application is installed. On an ubuntu system the following command will suffice:

sudo apt-get install gnuplot gnuplot-x11

Basic Usage

Please see the project wiki for usage examples. A basic pattern of use follows:

select plot('select price, weight from widgets');