Tables div supports longer names and dedup information

[nwoolmer]

Is your feature request related to a problem?

1.

I have tables with long names ("{guid}_{name}"). I have organised them this way round to group similar guids together in the window and the file system. i.e guid_foo and guid_bar will be next to each other for the same guid.

However, using DAY partition and WAL, I can only see the first character of the name, and cannot move the vertical divider to expand the div any further into the code div.

See screenshot for example.

Actioned a while ago, thank you!

It would be useful for me to be able to visualise the upsert keys in some fashion alongside the partitioning/indexing etc.

I appreciate that 7.3.0 only just came out!

Describe the solution you'd like.

For 1.

Freedom to expand the tables div further
Perhaps secondary visuals might work too (i.e tooltip when hovering over etc.)

For 2.

Perhaps icons next to the fields to match indexed symbols and designated timestamps.

Describe alternatives you've considered.

Using shorter names - possible if/when this comes: QuestDB Public Roadmap

Reversing the name ordering - would group tables by name instead of guid, which is less ideal for my use case.

Additional context.

[insmac]

Hi @Takheos, many thanks for your feedback! 🙇

Regarding upsert keys, we can add an indication for each column (or an icon) in a row, if it's being used as a deduplication key (similar to how we display designated timestamp indication or column type).

For the long table names problem, we can do a few things, which are not mutually exclusive, they can be added together:

• Bump the allowed max pane width from 500px to something bigger (we can perhaps make it dynamic to, say, half a viewport width)
• Add a tooltip with the full table name, visible if the text is longer than its container.

[nwoolmer]

Hi @insmac , thanks for your time.

Re: upsert keys, I think that could fit nicely with the current style you have for icons and I don't think it'd be too crowded. Not sure what the icon could be. Perhaps a 'D', or an up arrow (upsert key) or something else in your icon pack!

Re: max pane width, I think changing this would be the most immediately useful for me.

Re: tooltip, this could be useful too depending on responsiveness etc. - however, the above change would already be a huge help, and you may find better uses for a tooltip in future (for example, table statistics like number of rows, storage size etc.)

Thanks for your help!

[marregui]

In the meantime, you can query the dedupness of columns with this idiom:

select "column", type, upsertKey from table_columns('signal')

upsert columns will feature a massive True in the 3rd column.