microsoft / microsoft/vscode-mssql

[Feature Request]: Large data types should be able to be viewed in a larger dialog

Open
#22,314 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Area - Query Result Area - View/Edit data Enhancement
Dominant language
TypeScript
Stars
1.9k
Forks
610
Avg merge
2d 3h
Merged PRs (30d)
97

Description

Users may have large amounts of data in a table, and when viewing or editing that data in the Query Results or Table Explorer/Edit Data UX, nvarchar(max) and similarly large data types are unwieldy to edit inline.

It would be nice to have specific data types instead open in a modal or a sidebar dialog for viewing and (if supported) editing.

varbinary(max)
varchar(max)
nvarchar(max)
XML
JSON
vector

Thoughts:

  • For variable length types, maybe there's also a threshold for a set length where it opens in the dialog (e.g. nvarchar(200+) in the dialog, but lower is inline.
  • For some (maybe all?) of these data types (namely XML and JSON), we can display as a monaco editor
  • Buttons in the dialog for copy and (if editable) paste

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by locating the Query Results and Table Explorer/Edit Data entry points that render cell values. Define which listed data types and length thresholds use a modal or sidebar, then verify viewing, copying, and supported editing behavior for each; done means the agreed types no longer require unwieldy inline editing.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql, typescript, vscode
Domain
database, frontend
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.