search

mtxr / vscode-sqltools

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

Connection Explorer Side Bar Item Ordering #1351

Closed Irishmanluke closed 3 days ago

Irishmanluke commented 3 days ago

When viewing SQL objects in the connection explorer it can be difficult to find specific objects since they are not guaranteed to be in any particular order (it's dependent on the order the driver returns them in). In particular I'm noticing this when viewing tables in Databricks.

Describe the solution you'd like Add logic to sort sidebar items in the connection explorer lexicographically by label.

Describe alternatives you've considered It's not clear to me whether the ordering is better handled by the driver or by SQLTools directly. If it's meant to be handled by the driver I can move this issue over to the databricks driver extension.

gjsjohnmurray commented 3 days ago

Please raise this with the driver author. I think they should be able to fix this by adding an ORDER clause to the relevant query/ies.