[Libreoffice-bugs] [Bug 126624] Suggested database connection string parameters incorrect in URL entry dialog

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #12 from Lionel Elie Mamane <lionel at mamane.lu> ---
(In reply to Alex Thurgood from comment #10)
> Ideally, the dialog itself would provide for separate fields for each part
> of the connection string and an extra field for supplementary parameters
> (where daisychaining of such connection string parameters is allowed), and
> would only provide those fields that would correspond to the selected DB
> type. In such a case, we could have example resource strings for each type
> of DB connection, but we are talking about at least of tens of different DB
> engines (certainly all of the main ones out there in use today). It seems to
> me that there is currently no way to do this simply (from a UI perspective)
> without causing frustration for the end user (...)

It *is* possible, it is just more work. It means making a separate dialog for
each DBMS, like e.g. MySQL already has. It is completely possible, it just
needs work in LibreOffice UI and/or documentation for each DBMS.

There are two things in my mind:

 * the one-line patch that we should do *now* to remove,
   from the prompt that is used for _all_ DBMS
   (that don't have a specific UI dialog in LibreOffice),
   the misleading / wrong example.

 * the "more work, but better for the user" solution,
   which would be something like a combination of:

   - lots of examples in documentation

   - several DB-specific UI in the LibreOffice "new connection" dialog

But anyway, even if we do the "more work better" version, we _still_ need to
have a generic fallback for the unknown DBMS, so we _still_ need to do this
one-line patch.

-- 
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/20190812/0acaee36/attachment.html>