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

I stayed on the old native tools until now. I just tried the 1.2 version of pgAdmin 4 and it is better. It remembers the last directory in the file open dialog, and you can edit the file path manually.

But it still has problems. First of all, I navigated to the directory with my SQL files. I switched to the list view and tried to sort the files by time. It didn’t work. And the directories are mixed with the files in the list, not shown at the top of the list.

Then I tried to double click on a file to open it. It didn’t work. I had to click the “select” button to open it. Pressing “select” without selecting a file first results in the dialog closing and an error: “No such file or directory”.

Then I tried to run the SQL file. It didn’t work because it seems the application can’t handle UTF files that begin with a BOM (byte order mark, files saved from the previous pgAdmin versions, nothing fancy).

The BOM is included in the text editor as a red dot at the beginning of the SQL:

[cid:image003(dot)png(at)01D2938F(dot)8464F160]

and it causes the queries to fail with errors:

[cid:image007(dot)png(at)01D2938F(dot)8464F160]

Not being to open properly files created by the previous version is not what I expected.

And in default view of the file list file / directory names are truncated if they have more than about 10 characters:

[cid:image011(dot)png(at)01D2938F(dot)8464F160]
Compare that to how much text a similar icon view shows in the native dialog:

[https://vgy.me/WHe9Iz.png]

Then, hovering over the icons shows a tooltip with the full name, but only sometimes. If you view a tooltip on one file and move to another truncated file to view the tooltip it won’t show a tooltip and the previous tooltip will remain visible.

Also hovering over files is inconsistent: Hovering over the file name (sometimes) shows the name. Hovering over the file icon in icon view (grid view as you call it) doesn’t ever show anything. Hovering over the file icon in details view (table view as you call it) shows the full file path, and hovering over the name shows just the file name. And all the tooltips are URL encoded (spaces as %20 colons, backslash as %5C, etc.).

I’ll try to use it for a few more days and see if I can adapt to it in its current state.

Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

From: vladnc(at)gmail(dot)com<mailto:vladnc(at)gmail(dot)com>
Sent: Thursday, October 27, 2016 17:29
To: Dave Page-7 [via PostgreSQL]<mailto:ml-node+s1045698n5927969h92(at)n3(dot)nabble(dot)com>
Subject: RE: pgAdmin 4 1.0-beta4 - Query Tool, Select file popup issues

Sorry, you are right, I replied to hastily, I realized what you meant after I played with Slack a bit more.

Indeed, it behaves more like a browser, for example it saves files to a Downloads folder.

Well, In this case I will wait to see what the next versions bring.

I still don’t like this, but now I understand why it was done like this.

Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

From: Dave Page-7 [via PostgreSQL]<mailto:ml-node+s1045698n5927969h92(at)n3(dot)nabble(dot)com>
Sent: Thursday, October 27, 2016 17:15
To: vnicolici<mailto:vladnc(at)gmail(dot)com>
Subject: Re: pgAdmin 4 1.0-beta4 - Query Tool, Select file popup issues

On Thu, Oct 27, 2016 at 3:06 PM, vnicolici <[hidden email]</user/SendEmail.jtp?type=node&node=5927969&i=0>> wrote:
You said “As I've pointed out a number of times now, it is not possible to use the native file dialogues because of the security imposed by webkit (the same browser engine as is used in Chrome and Safari).�
Â
I use Slack and it is also based on webkit, and it uses the native file dialog for file uploads.

If you selectively edit what I wrote, it'll always be easy to argue a point with me. Please read the paragraph in full:

As I've pointed out a number of times now, it is not possible to use the native file dialogues because of the security imposed by webkit (the same browser engine as is used in Chrome and Safari). Those security measures minimise the use of the dialogues to downloading files and form based uploads, which would make use of them very cumbersome for this purpose. We wouldn't be able to track recently used files and allow them to be opened from a menu, nor would we be able to to "Save" a file - it would always be "Save As", with no way for us to control the default directory (even if it was a file you just opened).

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

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

If you reply to this email, your message will be added to the discussion below:
http://postgresql.nabble.com/pgAdmin-4-1-0-beta4-Query-Tool-Select-file-popup-issues-tp5919048p5927969.html
To unsubscribe from pgAdmin 4 1.0-beta4 - Query Tool, Select file popup issues, click here<http://postgresql.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5919048&code=dmxhZG5jQGdtYWlsLmNvbXw1OTE5MDQ4fC0xODMzMDMwNTYz>.
NAML<http://postgresql.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>

FB06760BB945466C9B91C8A79BDD8FB2.png (206 bytes) <http://www.postgresql-archive.org/attachment/5947239/0/FB06760BB945466C9B91C8A79BDD8FB2.png>
CB330D027662472B8855722D2CF147F0.png (67K) <http://www.postgresql-archive.org/attachment/5947239/1/CB330D027662472B8855722D2CF147F0.png>
FB3D0859E7B44D42A5F4D0A41AFE6B9D.png (55K) <http://www.postgresql-archive.org/attachment/5947239/2/FB3D0859E7B44D42A5F4D0A41AFE6B9D.png>
634CF21317404223804DFB9A9FA33901.png (6K) <http://www.postgresql-archive.org/attachment/5947239/3/634CF21317404223804DFB9A9FA33901.png>
B214B1D2F2994442978314013C6152D1.png (32K) <http://www.postgresql-archive.org/attachment/5947239/4/B214B1D2F2994442978314013C6152D1.png>

--
View this message in context: http://www.postgresql-archive.org/pgAdmin-4-1-0-beta4-Query-Tool-Select-file-popup-issues-tp5919048p5947239.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.