Обсуждение: application developers list?? or report engine using postgres?
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 : : +---------------------------------------+-----------------+
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
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 ============================================================ elein@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