qStudio should immediately load a driver when opening a database

[richb-hanover]

Using a fresh install of qStudio 3.10 on macOS 12.7.5, I dragged a SQLite database to the window. It opened properly in the top-left corner, showing the path to the SQLite file in the top half, and listing the tables in the bottom half. This is fine.

I then typed a PRQL query, and hit Cmd-E to execute it. Two things happened:

1. I saw a message asking if I would like to install the driver. On clicking "OK", some magic happened, and I got a confirmation message that it worked. (I think the results also appeared as expected.)
2. I also saw a red message across the window indicating there was some error (likely, that the driver was not loaded...)

Subsequently, everything worked fine. And kudo's for automatically loading the driver.

But I will propose another mechanism:

• Upon loading/loading a particular database, qStudio should check to see if its driver is available.
• If it is not, that's a great time to give the "we need to install the driver" message. The user is prepared, and won't ever see the second "red bar" error message, since no query has bee initiated yet.

Thanks as always

[richb-hanover]

@ryanhamilton - Here's a video showing what happens: https://youtu.be/dvpwsiyMOoM

If qStudio had asked to install the SQLite driver immediately when the database file was dragged in, it would have seemed entirely natural, and avoided the big red error bar.

(But compliments - the installation was flawless, and just worked thereafter). Thanks.

[richb-hanover]

A follow-on comment... I tried to drag a SQLite file to the qStudio window, and dragging to the top-left pane didn't "stick", even though that's where all the DB "connections" live.

Dragging to the bottom of the top-left pane did work, though. Here's what happened to me:

https://youtu.be/faJY5yXeAiA