Some low hanging fruit features for better usability

[bigbasti]

What

Coming from IntelliJ I am used to some features I'm missing from DBCode which should be very easy o build:

All refers to the DBCODE:CONNECTIONS view (tree view of connections and tables)

• Selecting a db table (or multiple) and hitting CTRL+C to copy the name(s) of the tables (Yes, I know I can right click and copy name)
• In intelliJ selecting a table and hitting CTRL+Q to quickly get the DDL in a preview window was insanely useful
• hovering over columns with the mouse and getting useful information about its type and attributes - the current tooltip is basically useless as it doesnt add any value

VISUAL EDIT

• Selecting multiple cells and editing them at the same time. I know this might be a limitation by ag-grid but would be super useful as i used this feature in IntelliJ all the time

Why (problem/use case)

• improve flow and usability

Additional Context

In addition, I would like to say that DBCode is an awesome product and I love using it. Im 100% subscribing after the test period :)
But having those features above would elevate the tool even further!

[mikeburgh]

Glad you're enjoying it.

I just released 1.29.4, I added:

Ctrl/Cmd+C - when focused in the tree will now copy the name (or names of multiple selections).

F4 - This will do the dll creation, ctrl+q was already bound to other features of VSCode.

I added more information to the column tooltip, it's a bit redundant as a lot of it is in the description, if there is something specific you are looking for, let me know.

Multi cell editing - You can do this via the Inspector panel. Select multiple rows in the grid, then edit a value in the Inspector, and it applies to all selected rows. Ag grid does not support it in the grid (they have a fill feature but it's not what you are looking for I don't think.

[bigbasti]

Hi!

that was quick - thanks a lot!

✅ Tooltips are looking perfect now

⚠️ Copying the names of selected tree elements is bugy: When you click on a table it is selected, but instantly looses focus as the focus jumps to the table tab (visual editor), if you hit CTRL+C now it will send this commant to the open tab instad to the tree with the selected table.

Sometimes clicking multiple times or SHIFT clicking the tables keeps the focus in the tree, then CTRL+C is working as expcted

❌ Generating DDLs doesn't work for me at all. I can see the horkey is mapped in the settings, but using it while having a Table selected just opens a new editor without content

thanks again for providing such quick updates.

[kackburt]

Tested this also on MacOS:

• Tooltip looks good
• Cmd+c works, but as mentioned by @bigbasti it feels buggy, since it jumps directly to the open tab.
• F4 works, but has same issue as above.

=> Workaround is to right click on the tree item and then press either Cmd+c or F4.

To me it's questionable, if the behaviour of automatically changing focus to open tab should be touched.

[mikeburgh]

yeah the focus thing is a bit of a hassle.. I spent a bunch of time today getting it to more closely match VSCode.. here is where it's at at the moment:

• Single click: Opens the table, focus stays on the tree item, does not move to the grid, also opens in what is preview mode, meaning it will be reused if you don't interact with it
• Double click: Opens the table, focus moves to first cell, and its opened as dirty so it wont be re used
• Enter key pressed on a table: Same as double click.

This is close to what VSCode does in the file tree, the exception being enter, in the file tree, that triggers rename.

But I think this solves all the use cases.. keyboard warriors get focus from enter.. otherwise it's double click to open and focus, single to open (peak it)

[mikeburgh]

I just released 1.29.5 which has the above changes.. as the focus stays when you single click, makes the keyboard shortcuts work.

Which DB are you using that gives you the blank open editor with F4 ? There are some that don't provide the DDL (SQL Server for example), guessing it could be one of them ?

[bigbasti]

Which DB are you using that gives you the blank open editor with F4 ?

I tried it with PostgreSQL 17.6 and Oracle XE 18 - both open a blank editor for me