If query development is an important part of what you need to do, consider dbQwikEdit. It's not open or free. But you can get a minimal config for free (I think) and it's pretty cheap copnsidering what it can do. It uses ODBC and can read any DB that ODBC points to (Oracle, MySQL, Postgres, SQLServer, etc...). You can enter your queries in by hand (being the sql savy people we are, that's what we'd do). But there is also a GUI that users can run that'll hand-hold them through building SQL using graphics. Pretty neat. This feature allows users to run "ad-hoc". THe output is just tabular. But you can export to lots of different formats. Just a thought. http://www.dbqwikedit.com/ -dave -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Thomas Kellerer Sent: Thursday, August 23, 2007 10:07 AM To: pgsql-general@xxxxxxxxxxxxxx Subject: Re: reporting tools Ned Lilly wrote on 23.08.2007 15:44: > This is specifically why we released OpenRPT as open source - it's very > lightweight, no Java required. http://sf.net/projects/openrpt I am a Java developer and thus I have no problems in using Java based tools. Especially because I ususally only have a JDBC driver for the databases I use around (especially with Oracle this is *very* nice, because it does not require a full client install, only a single .jar file) But OpenRPT looks quite nice, I'll have a look at it as well. I guess I need to install the whole ODBC "shebang" for that, right :) Thomas ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
