Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

qStudio should immediately load a driver when opening a database #103

Open
richb-hanover opened this issue Oct 13, 2024 · 2 comments
Open

Comments

@richb-hanover
Copy link
Contributor

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
Copy link
Contributor Author

@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
Copy link
Contributor Author

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant