Postgres Pro
Downloads
Home   >   mailing lists

Thread: Tool

Tool

From
Bob Pawley
Date:
I am developing a database which needs testing prior to developing the host program.
 
I am looking for an easy-to-learn tool. I want to develop an interface that I can use to enter and display information in a similar fashion to how a user would operate the database.
 
A GUI tool would be ideal.
 
I am running Postgresql v 8.0 on Windows XP.
 
Bob Pawley

Re: Tool

From
Philippe Ferreira
Date:
> I am developing a database which needs testing prior to developing the
> host program.
>
> I am looking for an easy-to-learn tool. I want to develop an
> interface that I can use to enter and display information in a similar
> fashion to how a user would operate the database.
>
> A GUI tool would be ideal.
>
> I am running Postgresql v 8.0 on Windows XP.
>

Hi,

If you need a GUI to manage your Postgresql databases, you have "PgAdmin"...

Philippe Ferreira.

Re: Tool

From
Bob Pawley
Date:
Thanks I am using pgadmin for development. I'm looking for a tool with which
I can develop an interface that will be used for entering and accessing
information in context with the user tasks.

Bob


----- Original Message -----
From: "Philippe Ferreira" <phil.f@worldonline.fr>
To: "Bob Pawley" <rjpawley@shaw.ca>
Cc: "Postgresql" <pgsql-general@postgresql.org>
Sent: Friday, February 10, 2006 9:30 AM
Subject: Re: [GENERAL] Tool


>
>> I am developing a database which needs testing prior to developing the
>> host program.
>>  I am looking for an easy-to-learn tool. I want to develop an interface
>> that I can use to enter and display information in a similar fashion to
>> how a user would operate the database.
>>  A GUI tool would be ideal.
>>  I am running Postgresql v 8.0 on Windows XP.
>>
>
> Hi,
>
> If you need a GUI to manage your Postgresql databases, you have
> "PgAdmin"...
>
> Philippe Ferreira.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

Re: Tool

From
Bob Pawley
Date:
This looks quite interseting.
 
Thanks Wes
 
Bob
----- Original Message -----
Sent: Friday, February 10, 2006 9:14 AM
Subject: RE: [GENERAL] Tool

You may wish to consider creating a web interface GUI. 
 
For example:  Sun's free Java Studio Creator2
 
A little to learn up front, but then the GUI goodness comes through.

 

-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Bob Pawley
Sent: Friday, February 10, 2006 12:02 PM
To: Postgresql
Subject: [GENERAL] Tool

I am developing a database which needs testing prior to developing the host program.
 
I am looking for an easy-to-learn tool. I want to develop an interface that I can use to enter and display information in a similar fashion to how a user would operate the database.
 
A GUI tool would be ideal.
 
I am running Postgresql v 8.0 on Windows XP.
 
Bob Pawley

Re: Tool

From
Tony Caduto
Date:
>
>>
>>> I am developing a database which needs testing prior to developing
>>> the host program.
>>>  I am looking for an easy-to-learn tool. I want to develop an
>>> interface that I can use to enter and display information in a
>>> similar fashion to how a user would operate the database.
>>>  A GUI tool would be ideal.
>>>  I am running Postgresql v 8.0 on Windows XP.
>>>
>>

If you are running on Windows I would recommend you use PG Lightning
Admin, it has a MUCH better user experience that PG Admin and has a form
view for dataset records, not to mention you can print, use code
completion etc.

http://www.amsoftwaredesign.com
http://www.amsoftwaredesign.com/lightning_admin.php

Re: Tool

From
Bob Pawley
Date:
Thanks very much Tony.

I'll give it a go.

Bob

----- Original Message -----
From: "Tony Caduto" <tony_caduto@amsoftwaredesign.com>
Cc: "Postgresql" <pgsql-general@postgresql.org>
Sent: Friday, February 10, 2006 11:42 AM
Subject: Re: [GENERAL] Tool


>
>>
>>>
>>>> I am developing a database which needs testing prior to developing
>>>> the host program.
>>>>  I am looking for an easy-to-learn tool. I want to develop an
>>>> interface that I can use to enter and display information in a
>>>> similar fashion to how a user would operate the database.
>>>>  A GUI tool would be ideal.
>>>>  I am running Postgresql v 8.0 on Windows XP.
>>>>
>>>
>
> If you are running on Windows I would recommend you use PG Lightning
> Admin, it has a MUCH better user experience that PG Admin and has a form
> view for dataset records, not to mention you can print, use code
> completion etc.
>
> http://www.amsoftwaredesign.com
> http://www.amsoftwaredesign.com/lightning_admin.php
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq

Re: Tool

From
"Jonel Rienton"
Date:
EMS' Postgresql Manager Lite is also pretty intuitive.

http://www.sqlmanager.net/products/postgresql/manager/download



-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Bob Pawley
Sent: Friday, February 10, 2006 1:49 PM
To: Tony Caduto
Cc: Postgresql
Subject: Re: [GENERAL] Tool

Thanks very much Tony.

I'll give it a go.

Bob

----- Original Message -----
From: "Tony Caduto" <tony_caduto@amsoftwaredesign.com>
Cc: "Postgresql" <pgsql-general@postgresql.org>
Sent: Friday, February 10, 2006 11:42 AM
Subject: Re: [GENERAL] Tool


>
>>
>>>
>>>> I am developing a database which needs testing prior to developing
>>>> the host program.
>>>>  I am looking for an easy-to-learn tool. I want to develop an
>>>> interface that I can use to enter and display information in a
>>>> similar fashion to how a user would operate the database.
>>>>  A GUI tool would be ideal.
>>>>  I am running Postgresql v 8.0 on Windows XP.
>>>>
>>>
>
> If you are running on Windows I would recommend you use PG Lightning
> Admin, it has a MUCH better user experience that PG Admin and has a form
> view for dataset records, not to mention you can print, use code
> completion etc.
>
> http://www.amsoftwaredesign.com
> http://www.amsoftwaredesign.com/lightning_admin.php
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq

---------------------------(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

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.15.4/255 - Release Date: 2/9/2006

Re: Tool

From
Philippe Ferreira
Date:
> Thanks I am using pgadmin for development. I'm looking for a tool with
> which I can develop an interface that will be used for entering and
> accessing information in context with the user tasks.
>
> Bob

Hi,

Why not OpenOffice "Base" ?

    http://www.openoffice.org/product/base.html

Philippe Ferreira.

Re: [Bulk] Re: Tool

From
"Ted Byers"
Date:
Bob,
 
If you're interested in a free java tool, you might want to look at NetBeans (now version 5).  It is one of the best I have seen, and I have used a wide variety of such tools in a number of different programming languages.  Understand, though, that you have a wide variety of options, ranging from a web interface (which may be preferred if your users will be accessing the database over a network) at one extreme to a thick client, perhaps started using Sun's Web Start, at the other. 
 
An advantage NetBeans offers is that it is easy to learn, and the user interface is quite intuitive, especially for GUI design and implementation.
 
Eclipse is another one with a good reputation, but I don't like it so much.  Its support for GUI design seems to me to be quite weak.
 
What you haven't said in any of your posts is what programming languages you know.  Nor do you indicate whether or not you have the skills required to work with an editor like emacs to create a very thin client (using a web server like Apache) with server side scripting using perl or php.  It is hard to make a recommendation without knowing something about your skills.  If you don't already have the skills of an intermediate Java programmer, then none of the tools mentioned in this thread will help you much.  If you knew only C++ (again at least at an intermediate level), for example, the only tools I know of that would be suitable are commercial (Borland's C++ Builder and Microsoft's Visual C++).  And I have no idea what the corresponding tools would be on unix/Linux (if anyone knows of such tools for Linux, I'd appreciate hearing about them as one of my computers will soon have Windows XP removed and replaced by Suse linux).
 
Cheers,
 
Ted
----- Original Message -----
Sent: Friday, February 10, 2006 1:03 PM
Subject: [Bulk] Re: [GENERAL] Tool

This looks quite interseting.
 
Thanks Wes
 
Bob
----- Original Message -----
Sent: Friday, February 10, 2006 9:14 AM
Subject: RE: [GENERAL] Tool

You may wish to consider creating a web interface GUI. 
 
For example:  Sun's free Java Studio Creator2
 
A little to learn up front, but then the GUI goodness comes through.

 

-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Bob Pawley
Sent: Friday, February 10, 2006 12:02 PM
To: Postgresql
Subject: [GENERAL] Tool

I am developing a database which needs testing prior to developing the host program.
 
I am looking for an easy-to-learn tool. I want to develop an interface that I can use to enter and display information in a similar fashion to how a user would operate the database.
 
A GUI tool would be ideal.
 
I am running Postgresql v 8.0 on Windows XP.
 
Bob Pawley

Re: Tool

From
Emi Lu
Date:
Could you suggests some tools that do not have to be super users to
install it under Linux ?

- Emi

>
>> Thanks I am using pgadmin for development. I'm looking for a tool
>> with which I can develop an interface that will be used for entering
>> and accessing information in context with the user tasks.
>>
>> Bob
>
>
> Hi,
>
> Why not OpenOffice "Base" ?
>
>    http://www.openoffice.org/product/base.html
>
> Philippe Ferreira.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org

Re: Tool

From
Tino Wildenhain
Date:
Philippe Ferreira schrieb:
>
>> Thanks I am using pgadmin for development. I'm looking for a tool with
>> which I can develop an interface that will be used for entering and
>> accessing information in context with the user tasks.
>>
>> Bob
>
>
> Hi,
>
> Why not OpenOffice "Base" ?

Someone should help to get the SDBC driver running
with current OpenOffice and Postgres. :(