Re: [pgadmin-support] pgAdmin 4 1.0-beta4 - Query Tool, Select file popup issues

Поиск
Список
Период
Сортировка
От vnicolici
Тема Re: [pgadmin-support] pgAdmin 4 1.0-beta4 - Query Tool, Select file popup issues
Дата
Msg-id DB6P195MB005606E4A6D4430E7A703387F7280@DB6P195MB0056.EURP195.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответ на Re: pgAdmin 4 1.0-beta4 - Query Tool, Select file popup issues  (Dave Page <dpage@pgadmin.org>)
Ответы pgAdmin 3 is still better than pgAdmin 4  (Vladimir Nicolici <vladnc@gmail.com>)
Список pgadmin-support

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:

 

 

and it causes the queries to fail with errors:

 

 

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:

 

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 for Windows 10

 

From: [hidden email]
Sent: Thursday, October 27, 2016 17:29
To: [hidden email]
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 for Windows 10

 

From: [hidden email]
Sent: Thursday, October 27, 2016 17:15
To: [hidden email]
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]> 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

 

cid:image001.png@01D23077.AEEF8560

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.
NAML

 

 



View this message in context: RE: pgAdmin 4 1.0-beta4 - Query Tool, Select file popup issues
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.

В списке pgadmin-support по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: [pgadmin-support] editable views
Следующее
От: Rob Musitano
Дата:
Сообщение: [pgadmin-support] Failed backup Job. How to find out why it failed.