sqlitebrowser / sqlitebrowser/sqlitebrowser

Create multiple tabs for each result when executing SQL

Open
#2,144 2 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

enhancement
Dominant language
C++
Stars
24.6k
Forks
2.4k
Avg merge
3d 49m
Merged PRs (30d)
3

Description

Describe the new feature

Currently only the last result, in a series of results, is shown when executing SQL. For example:

select 1 as value ;
select 2 as value ;
select 3 as value ;

will result in the value being shown for the select 3 as value ; statement. What I'm proposing is, like MySQL workbench, that the result section of the Execute SQL tab become a list of tabs and each result is listed in a separate tab. In the example above, in MySQL workbench, the result section would have 3 tabs:

  1. the first tab would be a table with one column labeled value with a single row containing 1
  2. the second tab would be a table with one column labeled value with a single row containing 2
  3. the third tab would be a table with one column labeled value with a single row containing 3

Additional info

Please answer these questions before submitting your feature request.

Is your feature request related to an issue? Please include the issue number.

No.

Does this feature exist in another product or project? Please provide a link.

Yes, MySQL Workbench.

Do you have a screenshot? Please add screenshots to help explain your idea.

Yes, see attached.

result1

result2

result3

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 at the Execute SQL tab and trace how a series of SQL statements produces the displayed result. Run the three-statement example from the issue, then verify that each result appears in its own tab with the expected value and column label.

Written by the indexing model from the issue text.

Assessment

Tech stack
cpp, sqlite
Domain
databases, desktop
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.