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.
Plotpg is a typical postgresql extension.
git clone [email protected]: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;
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
Please see the project wiki for usage examples. A basic pattern of use follows:
select plot('select price, weight from widgets');