Thread: Feature request: autosave for Query Tool

Feature request: autosave for Query Tool

From
Josh Berkus
Date:
Despite the improvements, pgAdmin is still a bit crashy on Mac.  I think
this will continue to be the case for some releases to come.

In the meantime, it would be useful if we could define an autosave
interval for query windows.  Currently, losing hours of SQL tinkering
work when pgadmin crashes unexpectedly is a fact of life.

Ones related to saved files would be saved to their files, and unnamed
windows would be saved to /tmp/.  I'd picture a single preferences
setting, which would set the autosave interval in minutes.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


Re: Feature request: autosave for Query Tool

From
Dave Page
Date:
On Fri, Aug 26, 2011 at 8:09 PM, Josh Berkus <josh@agliodbs.com> wrote:
> Despite the improvements, pgAdmin is still a bit crashy on Mac.  I think
> this will continue to be the case for some releases to come.

Really? I use it every day and don't recall the last time I saw a
crash that wasn't caused by development code. Crash reports are always
helpful...

> In the meantime, it would be useful if we could define an autosave
> interval for query windows.  Currently, losing hours of SQL tinkering
> work when pgadmin crashes unexpectedly is a fact of life.
>
> Ones related to saved files would be saved to their files, and unnamed
> windows would be saved to /tmp/.  I'd picture a single preferences
> setting, which would set the autosave interval in minutes.

Yes, that would be a nice addition. I'm not sure I'd want it to save
to the original file though, incase I was intending to save it under
another name. Probably just have it auto-save to the home directory or
somewhere less potentially volatile than /tmp, and offer to recover
that file if it exists the next time the query tool is opened.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


Re: Feature request: autosave for Query Tool

From
Guillaume Lelarge
Date:
On Fri, 2011-08-26 at 20:20 +0100, Dave Page wrote:
> On Fri, Aug 26, 2011 at 8:09 PM, Josh Berkus <josh@agliodbs.com> wrote:
> > Despite the improvements, pgAdmin is still a bit crashy on Mac.  I think
> > this will continue to be the case for some releases to come.
> 
> Really? I use it every day and don't recall the last time I saw a
> crash that wasn't caused by development code. Crash reports are always
> helpful...
> 

Only boot the Mac to check if my patches work there too, so can't really
say.

And seeing how "mini" is my macmini these days, doing more on it would
be really painful (hey, Core2Duo 1.83GHz doesn't help for sure).

> > In the meantime, it would be useful if we could define an autosave
> > interval for query windows.  Currently, losing hours of SQL tinkering
> > work when pgadmin crashes unexpectedly is a fact of life.
> >
> > Ones related to saved files would be saved to their files, and unnamed
> > windows would be saved to /tmp/.  I'd picture a single preferences
> > setting, which would set the autosave interval in minutes.
> 
> Yes, that would be a nice addition. I'm not sure I'd want it to save
> to the original file though, incase I was intending to save it under
> another name. Probably just have it auto-save to the home directory or
> somewhere less potentially volatile than /tmp, and offer to recover
> that file if it exists the next time the query tool is opened.
> 

Someone else already asked for something like this: auto-open after a
crash.


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com