vscode-database-client icon indicating copy to clipboard operation
vscode-database-client copied to clipboard

More infos about the columns in the tree view

Open trollfalgar opened this issue 2 years ago • 14 comments

It's possible to show more infos about the columns in the tree view, beside the type? Would be very helpful to see easily: keys, indexes, not null indicators, so on.

Something like this:

Tree view

Thanks!

trollfalgar avatar Mar 17 '22 17:03 trollfalgar

oh, I have this plan, it will come true in the future.

cweijan avatar Mar 17 '22 17:03 cweijan

oh, I have this plan, it will come true in the future.

Thanks, I'll be waiting! :)

trollfalgar avatar Mar 17 '22 18:03 trollfalgar

Hi, I canceled this plan, the tree view looks clunky after grouping the index and column. Consider using a design table. image

cweijan avatar Apr 19 '22 02:04 cweijan

I see. Oks, thanks!

trollfalgar avatar Apr 19 '22 10:04 trollfalgar

Hi, I have added the display of the index in version 5.2.1, I will continue to work here, your suggestions are welcome! image

cweijan avatar Apr 25 '22 03:04 cweijan

Hello, first, thanks for the great work.

I'm facing this issue.

image

I'll reinstall the extension and do some tests.

trollfalgar avatar Apr 25 '22 12:04 trollfalgar

What's your database server and version?

cweijan avatar Apr 25 '22 13:04 cweijan

MySQL version 8.0.28.

trollfalgar avatar Apr 25 '22 13:04 trollfalgar

Hi, I have fixed this in version 5.2.2.

cweijan avatar Apr 27 '22 03:04 cweijan

It's working nicely now, thanks.

image

One more sugestion. Would be very nice to know visualy the nullable/required columns. In the exemple below, the required fields have a little dot at the icon of the column. So the columns that dosn't have, are nullables.

image

trollfalgar avatar Apr 27 '22 14:04 trollfalgar

This is an interesting proposal, I will show the non-nullable columns in red after the next update.

cweijan avatar Apr 28 '22 02:04 cweijan

hi, I'm releasing version 5.2.4, now it will show non-nullable columns in red. image

cweijan avatar Apr 29 '22 08:04 cweijan

Great work, thanks.

Now, one more sugestion. But, it's just another visual convenience.

For foreign keys columns to show a diferente icon, like primary keys. I personaly think make sense, primary keys and foreign keys are related.

The information of foreign keys are show in the index part, but, again, a simple visual help with a icon is very nice.

trollfalgar avatar Apr 29 '22 14:04 trollfalgar

Thanks, I didn't think about foreign keys before, I will support it in the future.

cweijan avatar May 05 '22 02:05 cweijan

Hi, I have released version 5.7.4, and now you can set the display of foreign keys on the connection page. Since foreign keys will affect the speed of querying columns, I do not enable it by default. image image

cweijan avatar Aug 26 '22 08:08 cweijan

This is the effect of showing foreign keys. image

cweijan avatar Aug 26 '22 08:08 cweijan