search

dbcodeio / public

The Power of Databases, The Convenience of VS Code: All in One Place
29 stars 1 forks source link

Context Menu Customization Suggestions for Database ("Show Tables" and "Count Tables") #78

Closed devpkr1 closed 2 weeks ago

devpkr1 commented 1 month ago

Hi Mike,

I hope this message finds you well.

I wanted to share a couple of suggestions for enhancing the context menu for the database feature. I believe these additions would significantly improve user experience:

Show Tables: When a user selects this option, it would display a list of tables within the database, along with the number of records for each table in the main area.

Count Tables: This option would provide the total number of tables in the database, also displayed in the main area.

I think these changes would make the extension more user-friendly. If you find these suggestions valuable, I would appreciate it if you could implement them. I've attached a screenshot for your reference.

Image

Thank you for considering these enhancements!

Best regards, Pradeep

mikeburgh commented 1 month ago

Thanks, trying to understand the benefit of these two.

The list of tables and the number of rows in them you already get in the explorer (if we can get the row counts during introspection which we cannot always get). Showing that data in a table seems to replicate that ? And for the tables we cannot get row count on in introspection we could do select count(*) on but that could lead to more problems on larger tables.

The count of tables, in theory we could put this just after the tables group ? Then people can see it without any actions needing to be taken… don't know if it will look cluttered, maybe it's a setting people can disable if they don't want it..

mikeburgh commented 1 month ago

I just added the count of items in the DB Explorer for tables, views, procs, columns etc.. what do you think ? feels a little busy.. but I am open to feedback on if it should stay/go or become a setting.

devpkr1 commented 1 month ago

Thank you for your feedback on this suggestion! It’s looking great now. I can see the count of tables directly in the DB Explorer. Overall, it looks really good at this point, so let’s proceed with this.

mikeburgh commented 3 weeks ago

Okay I will close this for now. See if there are other use cases for showing a list of tables and row counts in the main window

devpkr1 commented 3 weeks ago

Sure, I’ll keep an eye out for any other use cases where displaying a list of tables and row counts in the main window could add value.