| Lists: | pdxpug |
|---|
| From: | Shawn Helm <helm(dot)shawn(at)gmail(dot)com> |
|---|---|
| To: | pdxpug(at)postgresql(dot)org |
| Subject: | Do you know of any easy-to-use reporting tools that work with PostgreSQL ? |
| Date: | 2010-08-17 00:12:31 |
| Message-ID: | AANLkTikqjnydm3rCA3YBbr3q8+0uHp83QJ8-XV8JUgVU@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pdxpug |
Does
Do you know of or recommend any easy-to-use reporting tools that work with
PostgreSQL ?
I'd like to be able to write views on data we load into a PostgreSQL
database and then generate a decent web-report or PDF from it.
I saw something from SQLMaestro
http://www.sqlmaestro.com/products/postgresql/phpgenerator/
and saw some other things on this list.
http://www.postgresonline.com/journal/archives/133-Database-Administration,-Reporting,-and-Light-application-development.html
I 'm fine with SQL and I know some PL/SQL but have little Python and no PHP
experience.
Thanks for your time,
Shawn
| From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
|---|---|
| To: | pdxpug(at)postgresql(dot)org |
| Subject: | Re: Do you know of any easy-to-use reporting tools that work with PostgreSQL ? |
| Date: | 2010-08-17 00:19:49 |
| Message-ID: | alpine.LNX.2.00.1008161717450.20418@salmo.appl-ecosys.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pdxpug |
On Mon, 16 Aug 2010, Shawn Helm wrote:
> Do you know of or recommend any easy-to-use reporting tools that work with
> PostgreSQL ?
> I'm fine with SQL and I know some PL/SQL but have little Python and no PHP
> experience.
Shawn,
Reporting is done external to the dbms. For Python I'll recommend
ReportLab. I also embed LaTeX code in my Python apps to generate the report
typeset as a .pdf file.
Rich
| From: | Michael Ewan <michael(dot)ewan(at)intel(dot)com> |
|---|---|
| To: | pdxpug(at)postgresql(dot)org |
| Subject: | Re: Do you know of any easy-to-use reporting tools that work with PostgreSQL ? |
| Date: | 2010-08-22 16:07:53 |
| Message-ID: | 4C714B59.7030004@intel.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pdxpug |
We are using Eclipse/BIRT, very easy to use and good documentation.
BIRT is 100% free and open source, reports are rendered on a java EE
application server like tomcat. I'll be doing a talk at the pdxpug
meeting in October/November on this.
There's also Fusion Charts Free, which produces flash graphics from XML
input. As someone else said there is Pentaho, also look at Jaspersoft.
Both of those are commercial tools but with community (free) editions.
If you don't mind some heavy lifting, take a look at MicroStrategy, they
have a free (up to 100 named users) that supports PostgreSQL natively.
Most anything that supports JDBC will support PostgreSQL.
On 08/16/2010 05:12 PM, Shawn Helm wrote:
> Does
> Do you know of or recommend any easy-to-use reporting tools that work
> with PostgreSQL ?
> I'd like to be able to write views on data we load into a PostgreSQL
> database and then generate a decent web-report or PDF from it.
> I saw something from SQLMaestro
> http://www.sqlmaestro.com/products/postgresql/phpgenerator/
> and saw some other things on this list.
> http://www.postgresonline.com/journal/archives/133-Database-Administration,-Reporting,-and-Light-application-development.html
> I 'm fine with SQL and I know some PL/SQL but have little Python and
> no PHP experience.
> Thanks for your time,
> Shawn