search

mtxr / vscode-sqltools

Database management for VSCode
https://vscode-sqltools.mteixeira.dev?utm_source=github&utm_medium=homepage-link
MIT License
1.49k stars 301 forks source link

Filter/select database(s) to list on explorer #322

Open mtxr opened 5 years ago

mtxr commented 5 years ago

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 commented 5 years ago

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

Gloix commented 5 years ago

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

Querying works fine though.

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

miversen33 commented 4 years ago

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

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).