Обсуждение: Reporting Tool?

As for me, perl + LaTeX + gs is the best combination.

Sep 28, 13:07 -0500, Chris Ruprecht wrote:

> Hi all,
>
> so far, I had no need to print any reports out of my PostGreSQL database, I was able to do everything through the
web.However, things change and now, I need to write an invoicing system. I have been using PL/PGSQL in the past, but it
doesn'tseem to have the ability to produce any type of reports. 
>
> I do not speak C/C++, tcl, Python or Perl, but I guess, I have to lean one of these. The invoices should run via cron
oncea month automagically, without any human intervention and should print on a LaserJet (the actual printing is not
theproblem). 
>
> Any suggestions?
>
> Best regards,
> Chris
>
>

my best regards,
----------------
Grigoriy G. Vovk

Sorry for answering to the reply, but I don't have the original message...

>As for me, perl + LaTeX + gs is the best combination.

Chris, this is probably the best solution for your problem, but if you don't want to elarn Perl, you can still use sed
andawk instead of it. 

LaTeX as typesetting package is a _very_ good idea (in general not only for automatisation)

But when it comes to Systemadministration, speaking a bit of Perl is always of advantage.

regards,
Stefan

Hi,

There are some other reporting tools listed at :

http://techdocs.postgresql.org/oresources.php#report

Hope that helps.

:)

Regards and best wishes,

Justin Clift


"Grigoriy G. Vovk" wrote:
>
> As for me, perl + LaTeX + gs is the best combination.
>
> Sep 28, 13:07 -0500, Chris Ruprecht wrote:
>
> > Hi all,
> >
> > so far, I had no need to print any reports out of my PostGreSQL database, I was able to do everything through the
web.However, things change and now, I need to write an invoicing system. I have been using PL/PGSQL in the past, but it
doesn'tseem to have the ability to produce any type of reports. 
> >
> > I do not speak C/C++, tcl, Python or Perl, but I guess, I have to lean one of these. The invoices should run via
crononce a month automagically, without any human intervention and should print on a LaserJet (the actual printing is
notthe problem). 
> >
> > Any suggestions?
> >
> > Best regards,
> > Chris
> >
> >
>
> my best regards,
> ----------------
> Grigoriy G. Vovk
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
     - Indira Gandhi

Are there any good books / tutorials about using perl + LaTeX + gs?  I'm just starting to learn Perl and could do with being able to report from a Postgres database.

Thanks for any help

Ben

> -----Original Message-----
> From: Grigoriy G. Vovk [mailto:grigoriy.vovk@linustech.com.cy]
> Sent: 29 September 2001 18:42
> To: Chris Ruprecht
> Cc: pgadmin
> Subject: Re: [ADMIN] Reporting Tool?
>
>
> As for me, perl + LaTeX + gs is the best combination.
>
> Sep 28, 13:07 -0500, Chris Ruprecht wrote:
>
> > Hi all,
> >
> > so far, I had no need to print any reports out of my
> PostGreSQL database, I was able to do everything through the
> web. However, things change and now, I need to write an
> invoicing system. I have been using PL/PGSQL in the past, but
> it doesn't seem to have the ability to produce any type of reports.
> >
> > I do not speak C/C++, tcl, Python or Perl, but I guess, I
> have to lean one of these. The invoices should run via cron
> once a month automagically, without any human intervention
> and should print on a LaserJet (the actual printing is not
> the problem).
> >
> > Any suggestions?
> >
> > Best regards,
> > Chris
> >
> >
>
> my best regards,
> ----------------
> Grigoriy G. Vovk
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
>

Disregard this auto attachment

*****************************************************************************
This email and any attachments transmitted with it are confidential
and intended solely for the use of the individual or entity to whom
they are addressed. If you have received this email in error please
notify the sender and do not store, copy or disclose the content
to any other person.

It is the responsibility of the recipient to ensure that opening this
message and/or any of its attachments will not adversely affect
its systems. No responsibility is accepted by the Company.
*****************************************************************************