Le 19/11/2009 21:35, Guillaume Lelarge a écrit :
> Le jeudi 19 novembre 2009 à 00:57:55, Dave Page a écrit :
>> On Wed, Nov 18, 2009 at 8:55 PM, Guillaume Lelarge
>>
>> <guillaume@lelarge.info> wrote:
>>> Le lundi 16 novembre 2009 à 19:08:29, Little, Douglas a écrit :
>>>> Hi,
>>>> I'm new to this community and not sure how to submit feature request.
>>>> Please advise.
>>>>
>>>> I'm converting from Teradata to greenplum, and one nice feature in our
>>>> TD query tool was a query history. Timestamp, completion code, rows
>>>> affected, and sql statement
>>>>
>>>> PGadmin seems to be very unstable in our environment, and is crashing
>>>> all the time. A query history would be real helpful. Thanks
>>>
>>> There is already a query history. But we don't record it. It would
>>> probably be interesting to do it. We need to know more about what you
>>> would like to have this. In which file should we record this? how someone
>>> can work with this history file? etc.
>>
>> It's been on my mental todo list for a while (but feel free to give it
>> a go). There is/was a similar in the DB2 management GUI which I used a
>> little a few years back - basically, they have a combo box above the
>> query input STC (spanning the width of the STC), in which every time
>> you execute a query, it adds a flattened (ie. \n's replaced with
>> spaces, double spaces replaced with single) version of the first few
>> lines to the combo list. If you select one of those queries, it simply
>> replaces the STC contents with the unflattened version of the original
>> query.
>>
>
> I recorded that as ticket # 93 (http://code.pgadmin.org/trac/ticket/93).
>
>
OK, I have something like this working. See the screenshot to have a
look at it. Actually, it loads the file at startup. If you choose an
item, it puts the query in the query text box. If you execute a query,
it adds the query in the combobox and save the contents of the combobox.
When writing the code, I had four questions:
* should we have a global history or a history per database? I prefer
the former...
* probably I need to add a Clear button?
* should I add options to allow the change the filename?
* is there anything else I have to add?
Comments?
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com
