Search Mac Software Downloads
|
  Main     Development     Oilcan  

Oilcan User Reviews (1 post)Write A Review
sort: smiles | time
Jan 18 2008
***..

PETER DA SILVA  This is useful, but the user interface feels incomplete and it's missing a couple of features that, right now, mean that the "psql" command line is actually more useful.

* There is no feedback from commands like "drop view" in the query window or any feedback from the browser (like, refreshing and showing the view is gone).

* There is no way to refresh the browser except by switching namespaces.

* There is no way to copy the name of a table or view from the browser to the query window.

I am not a Mac user interface expert, but ideally you should be able to both copy the name of the selected object or column to the clipboard, and drag a column or table name to the query window. Failing that, a menu for "copy name" would suffice.

Also, the results of command queries should be available, not just the tuples.  
(Version 2.0)

praisebury
0
[ 3 Replies - Reply ]
Replies:
Jan 18 2008

DECAY29  Good points. There are a few key things missing from the program. I have used a lot of TOAD before, and the one thing I wanted was the ability to write a lot of select queries (preferably threaded), using just keystrokes if possible.

Look for actual database management features in the next full version. The refresh option is something that I had pegged but it slipped through the cracks.

Thanks for the feedback. It was very constructive.  
(Version 2.0)

praisebury
0
Jan 18 2008

PETER DA SILVA  As far as creating queries algorithmically goes, that's a big part of what I've been doing for the past three years, doing things like automatically creating tables from SNMP MIBs and HTML forms and C structures (and vice versa in the latter two cases). There's a lot of low hanging fruit there, but I didn't want to get stuck into you about that because your description did say it wasn't aiming to be a query generator.

(that kind of thing is also tremendously fun :-> )

I found the Smalltalk browser and the iTunes smart playlists to be really great sources of ideas.

Oh, one more point I forgot to add:

* Clicking on a column header should sort by that column.  
(Version 2.0)

praisebury
0
Jan 18 2008

DECAY29   The main goal was to address the lack of quick querying in pgAdmin, which I use for everything else, because it is really good.

I have already added the refresh button on the database browser. Feedback for nonselect queries should be done by the end of the weekend.

The sorting by column is trickier because I leave the result in the native structure that the Postgres API gives it in. I was playing around with a version that copies the result into an array for that very purpose.

Do me a favor, Pete. Email me directly at david@spanware.com with any other feedback or suggestions. I would appreciate a very sophisticated user/developer as yourself, if you are willing.  
(Version 2.0)

praisebury
0

 

The opinions expressed in the reviews are not necessarily those of MacUpdate.
MacUpdate waives any legal binding related to the comments and opinions expressed in the reviews.
Please contact MacUpdate politely if you wish for a comment to be reviewed by MacUpdate for removal.