Re: Usability write-up - looking at Pg, especially PgAdmin-III and Pg on Windows, from an inexperienced user PoV

On Fri, May 25, 2012 at 12:56 PM, Craig Ringer <ringerc(at)ringerc(dot)id(dot)au> wrote:
> I just had the ... pleasure ... of using Windows with Pg again and was in a
> usability review frame of mind.  I landed up trying to restore my database
> using PgAdmin-III, and was astonished at how difficult and painful it was.
> The issues weren't all PgAdmin-III either, there are a few Pg-on-Windows
> issues and a few plain warts in terms of PostgreSQL usability in general.

Agreed on all points, I've had to help people using pgAdmin with many
of the problems you point out. Note that the pgadmin-hackers list is
also relevant.

Together with an earlier study about common PostgreSQL pitfalls, I've
created an article on the wiki:
https://wiki.postgresql.org/wiki/Usability_reviews

However, I suspect posting long rants like this won't get us very far.
Instead, I think these problems should be posted one by one, with
proposed solutions, so they can be discussed in detail without
distractions. Once there seems to be a consensus for a solution, add a
TODO list item -- I suspect most of these items are quite easy to
solve in code, once it's clear *how* to address them. And the TODO
list has been short of simple items recently.

Regards,
Marti