Filter/select database(s) to list on explorer

[mtxr]

This issue is a group of similar issues across dialect.

We have a performance issue that leads to bugs related to connections timeouts, explorer not listing and some other weirdnesses.

See: #240 #262 #265 #266 #296 #300 #349 #218 #381 #383 #411

Closing other tickets in favor of this one.

[mtxr]

Created a project to check individual issues. https://github.com/mtxr/vscode-sqltools/projects/5?add_cards_query=is%3Aopen

[Gloix]

I think it's not been reported, but in MySql connections the dropdown arrow is not even shown

Querying works fine though.

EDIT: Nvm, I think there were just no tables in that DB lol.

[miversen33]

I think it's not been reported, but in MySql connections the dropdown arrow is not even shown

Querying works fine though.

EDIT: Nvm, I think there were just no tables in that DB lol.

No you are correct, the drop down arrow does not appear for existing MySQL databases. I connected to a very large one and there is no option to view the tables/views/procedures in it like there used to be. However, yes, querying does work fine.

Additionally, even with a password entered in the config, I am still occasionally asked the password for the database?

Edit: I was incorrect, it just took about 10 minutes for the drop down to appear. However queries worked immediately on database connection (took about 1 minute).