[Libreoffice-bugs] [Bug 66813] Tools / SQL dialog is modal

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=66813

--- Comment #11 from Lionel Elie Mamane <lionel at mamane.lu> ---
>From a UX perspective, non-modal would be much better. There might be technical
challenges to make it non-modal, but I never took the time to dig into it.
Mainly, as far as I understand, we open _one_ connection to the database, which
allows to do _one_ SQL command concurrently (unless we use asynchronous APIs,
which we don't). So, during execution of an SQL command, basically nothing else
can happen within (the same odb file in) Base. The modality of the dialog might
just be a work-around for (older versions of) Base not handling that correctly.

The "busy" signal is good, during execution of the SQL command _only_ (that is
between the click on "Execute" button in the dialog and having the result of
the command), _not_ during the whole time that the dialog is merely open.

If someone wants to look into it, I would recommend:

1) Make the dialog non-modal
2) For best UX, change the "busy" signal to be only while command is being
executed.
3) Test it.
3.1) Execute a SQL command in the "Tools/SQL" dialog. Wait for the result. Do
not close the dialog, but use the Base UI (e.g. double-click on a query or on a
table). Should work well. Go back to dialog. Execute another SQL command.
3.2) Try to run a long-standing SQL command in the "Tools/SQL" dialog, then try
with the mouse in the UI to force execution of another SQL command (easiest is
double-click on a query or on a table).
4) What happens in 3.2? The best would be that the UI just waits for the dialog
command to finish, then does the requested thing. What might happen instead is
that the SQL command from the dialog is aborted.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210119/a2f1b4ea/attachment.htm>