Skip to content

dbui v0.2.7

Choose a tag to compare

@JosueRhea JosueRhea released this 14 Sep 23:53
· 69 commits to main since this release

This build is unsigned. It is not notarized by Apple, so macOS will
refuse to open it until you clear the quarantine flag. See
Installing below. The in-app updater will not offer this
release — install it by hand.

One report — "⌘S doesn't work after filtering rows" — and three ways the commit
could return without saying anything.

⌘S says what it did

A key that does nothing is indistinguishable from a key that is broken, and
save_pending_edits had three exits that returned in silence.

The one that was a real bug: a row dbui cannot identify — a view, or a
table with no primary key — accepted typing into every field and staged
nothing at all. The refusal reached a small red line in the sidebar, and only
after ⌘S had already answered "no changes to commit on this tab" to a screen
full of edits. It now stops before the batch and says "Cannot commit — table
has no primary key"
.

The other two: pressing ⌘S while the previous batch is still in flight — which
is exactly the press someone makes when the first one looked like it did
nothing — now says "Already committing — one moment", and pressing it with
no tab open says so rather than shrugging.

The filter is not what breaks a commit

Filtering a table, editing one of the rows left, and committing works. That was
worth proving rather than asserting, so it is now proved three times over:
against a SQLite file, and — behind DBUI_LIVE_TESTS=1 — against PostgreSQL
and MySQL, each driving the real window through ⌘F, a WHERE, an edit and ⌘S,
then reading the row back on a second connection to confirm it reached the
server.

The UI suite had only ever run against a file. The half it could not reach is
the engine's: a primary key that introspects differently, or a value the server
plans as the wrong type, arrives as a dead ⌘S and shows up on no SQLite run.

Installing

This release is not signed or notarized, so Gatekeeper blocks it on first
open. After dragging dbui to Applications:

xattr -dr com.apple.quarantine /Applications/dbui.app

Then open it normally. Alternatively, try to open it once, then go to System
Settings → Privacy & Security and click Open Anyway.

Signed and notarized builds will return in a later release. Until then the
in-app updater will not offer this version — it requires a notarized build
carrying the same Team Identifier as the copy you are running, and it refuses
anything that fails that check.

Verify your download against SHA256SUMS:

shasum -a 256 -c SHA256SUMS