# Turn your PostgreSQL queries into Charts

DevFeed: [Turn your PostgreSQL queries into Charts](<https://devfeed.tech/articles/turn-your-postgresql-queries-into-charts-34544.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2014/08/turn-your-postgresql-queries-into-charts/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2014-08-25T12:09:00Z

Content type: tutorial

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [App](<https://devfeed.tech/topics/app.md>), [data](<https://devfeed.tech/topics/data.md>)

Tags: [application](<https://devfeed.tech/tags/application.md>), [charts](<https://devfeed.tech/tags/charts.md>), [compare](<https://devfeed.tech/tags/compare.md>), [compiler](<https://devfeed.tech/tags/compiler.md>), [console](<https://devfeed.tech/tags/console.md>), [debian](<https://devfeed.tech/tags/debian.md>), [github](<https://devfeed.tech/tags/github.md>), [install](<https://devfeed.tech/tags/install.md>), [mongodb](<https://devfeed.tech/tags/mongodb.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

The article introduces pgcharts, an application that turns PostgreSQL SQL queries into charts. Users can edit a query, define categories and data series, add legends, and produce bar, column, pie, or donut charts. At the time of writing, the application had to be compiled with SBCL, with a Debian package planned.

## Source excerpt

Earlier this year we did compare compare Aggregating NBA data, PostgreSQL vs MongoDB then talked about PostgreSQL, Aggregates and histograms where we even produced a nice Histogram chart directly within the awesome psql console. Today, let's get that same idea to the next level, with pgcharts: *The new [pgcharts](https://github.com/dimitri/pgcharts) application* The application's specifications are quite simple: edit an SQL query, set your categories and your data series, add in some legends, and get a nice chart. Currently supported are bar, column, pie and donut charts, and we should be able to add anything that http://www.highcharts.com/ has support for.