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

On Fri, Sep 2, 2016 at 1:46 PM, Anthony DeBarros <adebarros@gmail.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@pgadmin.org> wrote:
>>
>> On Fri, Sep 2, 2016 at 12:03 PM, Mark Lascelles <mark@lascell.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@postgresql.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