By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,293 Members | 1,176 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,293 IT Pros & Developers. It's quick & easy.

application developers list?? or report engine using postgres?

P: n/a
Does anyone know of a mailing list for application developers using
postgres? It'd probably be more relevant than pgsql-general for my
question.

Failing that, what do people use to generate reports with a postgres
back end? I have a requirement to produce a reporting daemon on linux
that doesn't require X windows (has to render the report and write it
back to a blob). I've been down a couple of paths that ended with
unusable/unsuitable products.

klint.

+---------------------------------------+-----------------+
: Klint Gore : "Non rhyming :
: EMail : kg@kgb.une.edu.au : slang - the :
: Snail : A.B.R.I. : possibilities :
: Mail University of New England : are useless" :
: Armidale NSW 2351 Australia : L.J.J. :
: Fax : +61 2 6772 5376 : :
+---------------------------------------+-----------------+

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 22 '05 #1
Share this Question
Share on Google+
3 Replies

P: n/a
On Wed, Feb 04, 2004 at 12:08:23PM +1100, Klint Gore wrote:
Does anyone know of a mailing list for application developers using
postgres? It'd probably be more relevant than pgsql-general for my
question.
I'd be interested in such a thing.
Failing that, what do people use to generate reports with a postgres
back end? I have a requirement to produce a reporting daemon on linux
that doesn't require X windows (has to render the report and write it
back to a blob). I've been down a couple of paths that ended with
unusable/unsuitable products.


I've tried, I think, all the non-java open-source report generators,
the promising looking java ones and several of the commercial generators.

None of them were particularly inspiring - adequate, but not really
good enough for me to want to use them in production.

At the moment I'm using a home-built crawling perl monstrosity to
generate reports. It's OK for my application, but painfully non
general purpose, and tedious to add reports for.

(Next on my todo list is to put together a general purpose report
generator - probably Qt based, XML input, text + graphs output, HTML
and (maybe) PDF output.)

Depending on your needs - the format you want the output in and the
content you want, primarily - you may want to look at

http://openreport.org/
http://big.faceless.org/
http://rlib.sicompos.com/
http://www.jfree.org/

Cheers,
Steve

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 22 '05 #2

P: n/a
kg@kgb.une.edu.au (Klint Gore) writes:
Does anyone know of a mailing list for application developers using
postgres? It'd probably be more relevant than pgsql-general for my
question.

Failing that, what do people use to generate reports with a postgres
back end? I have a requirement to produce a reporting daemon on linux
that doesn't require X windows (has to render the report and write it
back to a blob). I've been down a couple of paths that ended with
unusable/unsuitable products.


Unfortunately, "suitable" is all in the eye of the beholder.

(And a painful sting on the hand is in the eye of the bee-holder...)

A recent discussion thread on one of the Linux newsgroups involved a
proposal of a "reporting engine" coded mostly using M4 macro
rewriting.
<http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=c1a156a0.0402021228.55e27b7c%40posting.g oogle.com&rnum=1&prev=/groups%3Fhl%3Den%26lr%3D%26ie%3DISO-8859-1%26q%3Dpostgresql%2Bm4%2Blinux%2Breport%26sa%3DN% 26tab%3Dwg>

The initiator's idea is well and good; the problems are all in the
requirements.

-> You likely need the "expressiveness" of HTML, with colour, custom
alignment of columns, font selection, and such, or, with raw
ASCII, perhaps not;

-> If the results are to be used by a GUI application, then it is
quite likely important to be able to construct partial results and
have a mechanism to render them at the "display widget" (whether
that be web browser, X app, or whatever) as you go along;

-> If the results are to be "batch-processed," partial results may
be irrelevant;

-> One person's notion of "easy to program" may not agree with another's
notion;

-> I know that the Proper Implementation Language is Common Lisp;
someone else thinks it's Python, another knows that the _only_
choice is Perl, another Tcl, another Java, and another C...

As soon as an implementation language is chosen, it has a
_significant_ effect on the "shape" of the solution, pointing at
the notion that, at least with computer languages, there is some
legitimacy to the Whorfian hypothesis that language shapes
cognition.

I know that where I can, I run queries and simply cut'n'paste the
output from psql, as that is a not-half-bad text-based presentation.

When it goes beyond that, people seem to head to using the libpq API
(or JDBC) to get data out, and then implement something in [favorite
language] to massage the results to get [favorite output format].

There are enough variations in the set of [favorite languages] and in
the set of [favorite output formats] that one size does not fit all.
--
output = reverse("gro.mca" "@" "enworbbc")
http://www.ntlug.org/~cbbrowne/advocacy.html
"SIGTHTBABW: a signal sent from Unix to its programmers at random
intervals to make them remember that There Has To Be A Better Way."
-- Erik Naggum
Nov 22 '05 #3

P: n/a
I have a general purpose reporting engine that
is good for people who are good at HTML and SQL.
It takes in an XML-ish template and spews HTML.
There is a sample php application to provide the
glue for registering and running the reports
from a browser.

The engine has a limited distribution because I would like
people to buy a short stint of support to get
the pieces up and running well. The documentation
is only mediocre. There is also no GUI interface.
In otherwords, although it is production quality
it is not nicely wrapped yet.

Contact me to find out more about it and/or
read http://www.varlena.com/Reports/

elein

================================================== ==========
el***@varlena.com Varlena, LLC www.varlena.com

PostgreSQL Consulting, Support & Training

PostgreSQL General Bits http://www.varlena.com/GeneralBits/
================================================== ===========
Its a doggy dog world out there.
On Wed, Feb 04, 2004 at 12:08:23PM +1100, Klint Gore wrote:
Does anyone know of a mailing list for application developers using
postgres? It'd probably be more relevant than pgsql-general for my
question.

Failing that, what do people use to generate reports with a postgres
back end? I have a requirement to produce a reporting daemon on linux
that doesn't require X windows (has to render the report and write it
back to a blob). I've been down a couple of paths that ended with
unusable/unsuitable products.

klint.

+---------------------------------------+-----------------+
: Klint Gore : "Non rhyming :
: EMail : kg@kgb.une.edu.au : slang - the :
: Snail : A.B.R.I. : possibilities :
: Mail University of New England : are useless" :
: Armidale NSW 2351 Australia : L.J.J. :
: Fax : +61 2 6772 5376 : :
+---------------------------------------+-----------------+

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 22 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.