Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings
Discussion options

I am searching for an intuitive way to browse through an SQLite DB, much like the SQLite Viewer extension for VS Code:

  1. DB schema on the left side (with ability to edit it - create / delete tables etc.)
  2. On single click on a table, the data appears on the right side (and can be browsed / edited)
  3. On double-click on a cell, the content can be quick-edited directly in Data browser (like in spreadsheet apps) and confirmed with Enter key

I tried tossing windows to adjust behavior to this pattern. The "Browse data" tab cannot be extracted out of the containing window and be shown besides "Database structure". The only way I could display them side by side is to drag the window containing the "DB Schema" tab to the left.

What I could not achieve was:

  • click on table to show data
    • it's either "right click -> browse table" or using the drop-down in the Browse data table, which all results in extra clicks
  • quick-edit: on double-clicking cell, the editing happens in an extra window "Edit database cell", and pressing Enter inserts a new line instead of confirming
    • Ctrl + Enter seems to apply, but the focus remains in the edit window, so I cannot just move to the next entry with up / down keys
  • close tab with a middle-click or a cross on the tab "tag" itself
    • I would have to aim at the tab close cross on the right side

My questions:

  • is this behavior achievable? (maybe I'm just missing some settings?)
  • if not - would it be realistic to implement some of the described minor GUI tweaks (e.g. as an option)? I would open according feature requests then

I am using sqlitebrowser-3.13.1-1 on Fedora 41.

Thanks for your help!

You must be logged in to vote

Replies: 0 comments

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Category
🙏
Q&A
Labels
None yet
1 participant
Morty Proxy This is a proxified and sanitized view of the page, visit original site.