FazBrowse GitHub Viewer | Trending |
URL:
| Home
Tools: [Download Repo ZIP]   [Original HTTPS Page]

fix(sqlite): edit Table Browser rows via implicit rowid by ZhuchkaTriplesix · Pull Request #865 · QueryaHub/Querya-Desktop · GitHub

fix(sqlite): edit Table Browser rows via implicit rowid - #865

Merged
ZhuchkaTriplesix merged 1 commit into
devfrom
issue/774-sqlite-implicit-rowid
Sep 20, 2026
Merged

ZhuchkaTriplesix merged 1 commit into
devfrom
issue/774-sqlite-implicit-rowid

Conversation

Copy link
Copy Markdown
Member

Summary

  • Tables with no declared PRIMARY KEY (`CREATE TABLE t (name TEXT)`) use implicit `rowid` as the Table Browser DML key.
  • Browse SELECT projects `"rowid", *` so Save can `UPDATE … WHERE rowid`. Status is no longer “no primary key”.
  • `WITHOUT ROWID` tables keep their declared PK (they always have one).

Closes #774

Test plan

  • Open Table Browser on `CREATE TABLE t (name TEXT)` → cells are editable, no “no primary key” status
  • Edit a cell, Save → row updates (`WHERE rowid`)
  • INTEGER PRIMARY KEY tables still use the declared PK, not a duplicate rowid column
  • `WITHOUT ROWID` table with a PK still edits via that PK
  • Views stay read-only

github-actions Bot added bug Something isn't working sqlite SQLite database driver and workspace data-grid Interactive data grid, cell editor, filtering, groupings labels Sep 20, 2026
ZhuchkaTriplesix merged commit 14eca20 into dev Sep 20, 2026
3 checks passed
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode characters
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

bug Something isn't working data-grid Interactive data grid, cell editor, filtering, groupings sqlite SQLite database driver and workspace

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant


Back | FazBrowse Home | New Git URL