Re: [GENERAL] interface for non-SQL people

2009-10-10 Thread justin
pere roca wrote: hi, some nice tool over there to let non-SQL knowing people to construct their queries? I'm using pgAdmin III but I know some SQL. there is no other option than constructing an HTML with forms, drop-down menus...? thanks, pERE Your best bet which is not free is

Re: [GENERAL] interface for non-SQL people

2009-10-10 Thread Martin Gainty
facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. Date: Sat, 10 Oct 2009 21:36:19 -0400 From: jus...@emproshunts.com To: pero...@gmail.com CC: pgsql-general@postgresql.org Subject: Re: [GENERAL] interface for non-SQL people pere

Re: [GENERAL] interface for non-SQL people

2009-10-10 Thread Lew
Martin Gainty wrote: Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist

Re: [GENERAL] interface for non-SQL people

2009-10-09 Thread Joshua D. Drake
On Thu, 2009-10-08 at 19:16 -0600, Scott Marlowe wrote: On Thu, Oct 8, 2009 at 2:22 PM, Merlin Moncure mmonc...@gmail.com wrote: The #1 tool you have at your disposal is the human brain. I personally think GUI database tools are counter productive and huge time wasters. SQL requires

Re: [GENERAL] interface for non-SQL people

2009-10-09 Thread Andrew Gould
On Fri, Oct 9, 2009 at 10:15 AM, Joshua D. Drake j...@commandprompt.com wrote: On Thu, 2009-10-08 at 19:16 -0600, Scott Marlowe wrote: On Thu, Oct 8, 2009 at 2:22 PM, Merlin Moncure mmonc...@gmail.com wrote: The #1 tool you have at your disposal is the human brain.  I personally think GUI

Re: [GENERAL] interface for non-SQL people

2009-10-09 Thread Tim Bruce - Postgres
On Fri, October 9, 2009 09:06, Andrew Gould wrote: On Fri, Oct 9, 2009 at 10:15 AM, Joshua D. Drake j...@commandprompt.com wrote: On Thu, 2009-10-08 at 19:16 -0600, Scott Marlowe wrote: On Thu, Oct 8, 2009 at 2:22 PM, Merlin Moncure mmonc...@gmail.com wrote: The #1 tool you have at your

Re: [GENERAL] interface for non-SQL people

2009-10-09 Thread Joshua D. Drake
On Fri, 2009-10-09 at 09:52 -0700, Tim Bruce - Postgres wrote: I would also add that there are a LOT of performance issues with MS Access. For one, in some cases filtering out records with a where clause can be performed on the client side - meaning it grabs all records and pulls them

Re: [GENERAL] interface for non-SQL people

2009-10-09 Thread Stephan Szabo
On Fri, 9 Oct 2009, Joshua D. Drake wrote: On Thu, 2009-10-08 at 19:16 -0600, Scott Marlowe wrote: On Thu, Oct 8, 2009 at 2:22 PM, Merlin Moncure mmonc...@gmail.com wrote: The #1 tool you have at your disposal is the human brain. I personally think GUI database tools are counter

Re: [GENERAL] interface for non-SQL people

2009-10-09 Thread Joshua D. Drake
On Fri, 2009-10-09 at 10:32 -0700, Stephan Szabo wrote: Good lord people. Not be helpful much? [...] JD... Who sits in bewilderment I'm fairly bewildered as well. I mean, why would someone who is emailing with an address from a company that presumably should care about how it looks on

Re: [GENERAL] interface for non-SQL people

2009-10-09 Thread Andrew Gould
On Fri, Oct 9, 2009 at 12:18 PM, Joshua D. Drake j...@commandprompt.com wrote: On Fri, 2009-10-09 at 09:52 -0700, Tim Bruce - Postgres wrote: I would also add that there are a LOT of performance issues with MS Access.  For one, in some cases filtering out records with a where clause can be

Re: [GENERAL] interface for non-SQL people

2009-10-09 Thread Merlin Moncure
On Fri, Oct 9, 2009 at 1:32 PM, Stephan Szabo ssz...@megazone.bigpanda.com wrote: On Fri, 9 Oct 2009, Joshua D. Drake wrote: On Thu, 2009-10-08 at 19:16 -0600, Scott Marlowe wrote: On Thu, Oct 8, 2009 at 2:22 PM, Merlin Moncure mmonc...@gmail.com wrote: The #1 tool you have at your

Re: [GENERAL] interface for non-SQL people

2009-10-08 Thread ssmagin
Hi, There is a http://www.activedbsoft.com/overview-querytool.html FlySpeed SQL Query tool, it's free if you don't need data export and printing. It's query builder is very good, but the author honestly says that basic knowledge of SQL concepts is required to to build a query... pere roca

Re: [GENERAL] interface for non-SQL people

2009-10-08 Thread Merlin Moncure
On Tue, Oct 6, 2009 at 3:47 PM, pere roca pero...@gmail.com wrote:  hi,  some nice tool over there to let non-SQL knowing people to construct their queries? I'm using pgAdmin III but I know some SQL.  there is no other option than constructing an HTML with forms, drop-down menus...? Cant

Re: [GENERAL] interface for non-SQL people

2009-10-08 Thread Scott Marlowe
On Thu, Oct 8, 2009 at 2:22 PM, Merlin Moncure mmonc...@gmail.com wrote: The #1 tool you have at your disposal is the human brain.  I personally think GUI database tools are counter productive and huge time wasters.  SQL requires lateral thinking but once you have your head around how joins

[GENERAL] interface for non-SQL people

2009-10-06 Thread pere roca
hi, some nice tool over there to let non-SQL knowing people to construct their queries? I'm using pgAdmin III but I know some SQL. there is no other option than constructing an HTML with forms, drop-down menus...? thanks, pERE -- View this message in context:

Re: [GENERAL] interface for non-SQL people

2009-10-06 Thread Postgres User
EMS SQL Manager has a visual query builder, but it's a commerical product, ie it aint free. On Tue, Oct 6, 2009 at 12:47 PM, pere roca pero...@gmail.com wrote:  hi,  some nice tool over there to let non-SQL knowing people to construct their queries? I'm using pgAdmin III but I know some SQL.

Re: [GENERAL] interface for non-SQL people

2009-10-06 Thread Alvaro Herrera
pere roca escribió: hi, some nice tool over there to let non-SQL knowing people to construct their queries? I'm using pgAdmin III but I know some SQL. there is no other option than constructing an HTML with forms, drop-down menus...? IIRC pgAdmin has got a graphical query builder.