Re: pgAdmin 4 1.0-beta4 - Query Tool, Select file popup issues

From: Anthony DeBarros <adebarros(at)gmail(dot)com>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: pgAdmin Support <pgadmin-support(at)postgresql(dot)org>, Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>
Subject: Re: pgAdmin 4 1.0-beta4 - Query Tool, Select file popup issues
Date: 2016-09-03 15:50:06
Message-ID: CAAQFaFKsvQ3oY_DMFneDeocaQYU06v2v+ND+hcO60dbW1R3f4g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Tried setting this in in config_local.py on Mac:

STORAGE_DIR = '/Users/adebarros/path/to/files/'

Saved file, restarted pgAdmin 4. Opened query tool and open file dialog,
and it's still pointing at root.

Meanwhile, the other issues Mark Lascelles pointed out really need to be
addressed to make this file dialog workable if you can't use the native OS
dialogs:

-- folder and file names need to be sortable
-- need to show more than the first few characters of the directory or file
name.
-- ought to be able to select/open a file by double clicking on it.
-- ability to enter path in the dialog to go straight there.

On Fri, Sep 2, 2016 at 9:47 AM, Dave Page <dpage(at)pgadmin(dot)org> wrote:

> On Fri, Sep 2, 2016 at 1:46 PM, Anthony DeBarros <adebarros(at)gmail(dot)com>
> wrote:
> > Where is config_local.py located on OS X and Windows?
>
> In the web/ directory of the installation. In a Mac app bundle you'll
> find that in Contents/Resources (right-click the bundle, and select
> Show Package Contents).
>
> You shouldn't need to modify the setting on a desktop installation -
> but having said that, I don't actually see drives listed on my Windows
> installation, only the folders at C:\. Ashesh; is there a Windows
> issue here?
>
> On Mac, there are no drives of course so it works fine here.
>
> > On Fri, Sep 2, 2016 at 8:39 AM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
> >>
> >> On Fri, Sep 2, 2016 at 12:03 PM, Mark Lascelles <mark(at)lascell(dot)es>
> wrote:
> >> > Hi,
> >> >
> >> > If this is not the correct place for pgAdmin 4 feedback, please let me
> >> > know.
> >> > I am trying to switch to pgAdmin 4, even though its beta, because
> >> > pgAdmin 3
> >> > often crashes, and I lose work - I see that is a known issue, but am
> not
> >> > sure if a fix is in progress?
> >> >
> >> > Anyway, in pgAdmin 4, I have noticed the following when Opening a File
> >> > in
> >> > Query Tool:
> >> >
> >> > - Clicking the icon to open the "Select file" popup is very slow
> >> > (Windows
> >> > 10). >3 seconds for pgAdmin4 wheras <1 second for pgAdmin 3.
> >> >
> >> > - I am presented with a list of directories, but no idea which
> >> > drive/directory I'm already in (e.g. C:\) and no obvious way to switch
> >> > to my
> >> > other drives where the files I want are located. I can't edit the file
> >> > path
> >> > directly to change this. This makes pgAdmin 4 unworkable for me
> >> > currently.
> >> > Beta 1 did allow directory changes.
> >> >
> >> > - Only the first 10 characters of filenames are shown even though
> >> > there's
> >> > much more space available. This means I can't distinguish between a
> lot
> >> > of
> >> > the files I need to.
> >> >
> >> > - When viewed as a tables, the order of directories seems random - not
> >> > by
> >> > name, size or date, and ordering by those columns doesn't work
> >> >
> >> > I appreciate the preference for a consistent look and feel, but the
> >> > native
> >> > Windows Open File dialog (as used in pgAdmin 3) seems quicker and more
> >> > fully
> >> > featured e.g. I can rename and move files and directories within it.
> >> > Perhaps
> >> > it doesn't work with the new web based paradigm though.
> >> >
> >> > I appreciate the work you are doing,
> >>
> >> Hi
> >>
> >> It uses it's own dialogue because it has to work with file storage
> >> either on the local machine in desktop mode, or on the server if
> >> running in server mode. You can control the root of the storage area
> >> by specifying a path in the config_local.py file - this is the
> >> default:
> >>
> >> ############################################################
> ##############
> >> # Storage Manager storage url config settings
> >> # If user sets STORAGE_DIR to empty it will show all volumes if platform
> >> # is Windows, '/' if it is Linux, Mac or any other unix type system.
> >>
> >> # For example:
> >> # 1. STORAGE_DIR = get_drive("C") or get_drive() # return C:/ by default
> >> # where C can be any drive character such as "D", "E", "G" etc
> >> # 2. Set path manually like
> >> # STORAGE_DIR = "/path/to/directory/"
> >> ############################################################
> ##############
> >> STORAGE_DIR = os.path.join(
> >> DATA_DIR,
> >> 'storage'
> >> )
> >>
> >> In desktop mode, you should have access to all filesystems.
> >>
> >> --
> >> Dave Page
> >> Blog: http://pgsnake.blogspot.com
> >> Twitter: @pgsnake
> >>
> >> EnterpriseDB UK: http://www.enterprisedb.com
> >> The Enterprise PostgreSQL Company
> >>
> >>
> >> --
> >> Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
> >> To make changes to your subscription:
> >> http://www.postgresql.org/mailpref/pgadmin-support
> >
> >
>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Surinder Kumar 2016-09-05 05:42:16 Re: pgAdmin 4 1.0-beta4 - Query Tool, Select file popup issues
Previous Message Dave Page 2016-09-02 13:47:21 Re: pgAdmin 4 1.0-beta4 - Query Tool, Select file popup issues