Recently, I was asked whether Postgres was “covered” in the area of common reporting needs? By reporting I mean ad hoc or predefined chart generation, mostly drag-and-drop style software, used most commonly by Business Intelligence people. The answer is “yes” – you can do reporting on PostgreSQL as easily as with other popular databases.
But what options are out there more specifically? So here’s a small list on some popular options I’m aware of. As a disclaimer, I have to say that I don’t have to deal with reporting too often so it’s not a definitive list in any way, there are dozens and dozens of options out there, and I haven’t used all the listed ones but just seen them used or being talked about.
General reporting/BI solutions
Tableu is definitely one of the most popular and feature rich options. Besides the basics, it provides all kinds of fancy visualizations (geomapping, treemaps, Gantt charts) and supports both ad-hoc queries and loading data to their server for even more options. Commercial product.
Microstrategy provides charting but is more of an enterprise analytics suite with a huge feature-set covering all analytics needs – visualizations, predictive analytics, alerts. Commercial product.
JasperReports is the most popular Open Source reporting software with all the modern features (visual designers, mobile apps) in the Open Source version and even more advanced stuff (ETL, Hadoop integration etc) available in the paid commercial edition.
One of the veterans of business intelligence & visualization software. Quite user friendly but one needs to load data to QlikView first. Commercial product.
NB! For successful ad hoc reporting you should normally make sure your data more or less fits into RAM or you should at least have very fast disks (SSDs).
More lightweight options for PostgreSQL
When your requirements are not so “enterprisy” (you’re ready to set up some software and write some SQL-s) and you’re OK with just the most common graph types, then you also have some options.
Currently for my own needs this very active Open Source project would be my first pick. It has all the basic chart types, plus a way to share charts among users. See the SqlPad project Website for more. It looks something like that:
Simplistic charting for Postgres. Project doesn’t seem to be too active nowadays though. See the GitHub project here.
* Pull the data to you spreadsheet program for DIY charting
Maybe not exactly the most convenient method, but you can still quite easily fetch data from your Postgres database to Libre(Open)Office or MS Excel and do your charting there. How to do it for LibreOffice Calc, for example, can be seen from this YouTube video here and in the end it would look something like my screenshot below. Note that you need also LibreOffice Base and libreoffice-sdbc-postgresql driver (sudo apt install libreoffice-sdbc-postgresql libreoffice-base on Ubuntu).
Please write a comment if there are some other good options out there!